I am designing a database model based on an existing database that currently has 268 tables. These tables are all in 1 database.
The new model will have probably 300+ tables. We are discussing whether to keep all the tables in 1 database or separate them into multiple databases. We lose some foreign key constraints if we go multiple but that is a lot of tables to put in 1 DB.
So -- does anyone have experience with this or opinions? I can see pros and cons on both sides.