Saturday, 31 August 2013

SQL server multiple databases with same schema

SQL server multiple databases with same schema

I have a solution that is sharded across multiple SQL Azure databases.
These databases all have the exact same data schema and I generate an edmx
from one of them.
How can I maintain the schemas of multiple databases with respect to
change management? Any change in one schema has to be automatically
applied on all the other databases. Is there something I am missing? I
looked at data sync but it seems to be solving another problem. In my case
the schema is exactly the same and the data stored is different.

No comments:

Post a Comment