AnsweredAssumed Answered

Separate Databases or just add tables?

Question asked by S.Williams on Oct 14, 2015
Latest reply on Oct 21, 2015 by jbrown

So what is the "best practice" on deciding when to use another database or just add more tables to a single database?

And how many tables is too many in a single database?


for example: say I have a CRM project that has a database with 12 tables

I now want a project management system that needs another 12 tables but it could also use a table or 2 from the CRM system.

Then later I need a Venue management system that also has a bunch of tables but could use tables from above also.


In general I guess I'm asking, when is it time to create another database -vs- just adding more tables and what considerations are there.