title: Synchronising tables between two SQL Server databases
body: <p>At the moment I have <code>Database_One</code> and <code>Database_Test</code>, both SQL Server databases.</p>
  
  <ul>
  <li><code>Database_One</code> represents my User's data that I shall not be modifying.</li>
  <li><code>Database_Test</code> represents a replica of <code>Database_One</code>, but has test data that I edit whilst I am developing.</li>
  </ul>
  
  <p>In the future I may have <code>Database_Two</code>, <code>Database_Three</code> etc as more clients use my program. </p>
  
  <p>Currently if I need to add a column to a table in <code>Database_Test</code>, I would need to add it to all other databases individually, manually. </p>
  
  <p>I would rather have a system where all databases are replicas of a master database, but have their own data. So that if I need to add a new column to a table in the master database, this is replicated to all others but the data is individual to each database (and therefore client).</p>
  
  <p>Is there a method that lets me do this with SQL Server databases?</p>
  
  <p>I should also add that these are SQL Server instances running in Azure.</p>
  
  <p>I would also like this mechanism to copy the database structure, but not it's data, so that I can easily setup new databases in the future.</p>