Multiple database vs. single database.

[Albion]

I have a few Access databases that I am converting over to SQL. What would be more beneficial; to create an individual database in SQL for each of these database or to create one company wide database and just add all the tables from each individual access database?

thanks

-al

 

[fluteplr]

Probably the 2nd but without a lot more detail, its kind of hard to say. Why where they broken into separate databases in the first place? For example.

 

[tlbroadbent]

The answer really depends on the relationship between the databases. If one is for Personnel, another for Payroll, and another for Sales and Inventory, one could make a valid argument for combining the first 2 DBs into 1. The Sales and Inventory database has a different purpose and perhaps a different set of users and should probably remain separate DB even in SQL Server.

In general, I would try to keep related data together.

If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm