Sunday, 18 August 2013

Can I manage several "identical" MS SQL Databases with different data?

Can I manage several "identical" MS SQL Databases with different data?

Can I manage several "identical" MS SQL Databases with different data?
I have a set of different stores that belong to different owners I have a
common web application for all of them. The Data bases are identical (same
tables, columns store procedures etc.) but the data obviously is different
depending on the store.
I couldn't have a single database for all of them and have a column in
each table indicating to which store belongs, because of different reasons
like "legal reasons", privacy that each store wants, optimize the product
search, client search, individual backups, etc.
However every time I have to make a change in the application like adding
a new column, change a store procedure I have to repeat the same steps for
each Data Base is there any way I can have only one "MetaBase" in which I
can make the changes and then they will be applied to each individual
database?

No comments:

Post a Comment