I have a plan for several separate databases. Was thinking that keeping them separate, might be good for if/when someone may want to buy one (but not all). However, for each database, there is one table that would be/is common, in terms of its structure and content. It is called customers.
what way would you structure such a series of db's?
1. put them all into one big db
2. keep them separate and put the customers table into its own space where all dbs can relate to it
3. a third way
If you recommend putting them all into one huge db, can you point me to some search terms or tutorials on, for example, 'partitioning databases' or partitioning tables or other potential search terms.