title: How Do I Automate Database Schema comparison and Synchronization Process for SQL Server Database?
body: <p>I am using SQL Compare(from Redgates) to compare Sql server Database schema comparison. And I know how to Synchronize it manually. </p>
  
  <p>Is there any process which I can make.. which automatically compares database1 schema with Database2 schema and make synchronization. And this has to be scheduled weekly once.. </p>