title: SQL server multiple databases with same schema
body: <p>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. </p>
  
  <p>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. </p>