Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  New to SQL Server Programming  SQL Architecture / Scaling / Indexing

Author  Topic  apchampa Starting Member 1 Post Posted - 2015-01-30 : 16:16:37 I am assisting on a project and we are in need of some SQL advice / direction. Background: This is a website designed to gather intelligence information and allow people to search on it. It will initially reside on one Windows server with an installation of SQL on the server. Eventually this system may need to be expanded to other agencies in the area and this may happen in one of two ways. #1, each new agency coming on board will have their own server & SQL install or #2, an agency may want to come on board and put their data on this original server. Sencario #1 is more likely to happen. That being said, we are looking for info on the following: 1) Once there are multiple instances of SQL involved, what is the best approach to do searches across the multiple SQL databases? The goal is to have the single interface and when you search it will bring back results from all the servers. Does this require some sort of index? 2) What generally needs to happen (or be considered) on the initial install to prepare for expanding to multiple SQL databases that may come online later? What needs to happen on the SQL side and on the website applicaiton side? These are the general questions. It is all about how to manage the SQL databases and how the searching will work.