One large database or several small ones for different companies
Posted on 2010-08-29
I am marketing an online application and I am thinking what is a best solution with respect to the database architect.
1- To have a large database with an Account field - size to under 5 billions records,. use mssql
2- To have a similar database for each account size to millions of records, using mssql express
For item 2 is there a good way to keep the database structure same after modifications - How?
This is a very important question please help - thanks