SQL Compare is for use in a development environment when changes made to a local database need to be pushed to a live database on a remote server. Traditionally, this meant spending hours trawling through database schemas, hand-generating migration scripts. SQL Compare will automate this process for you. It will compare and synchronize all database objects, including, but not limited to, tables, stored procedures, views and user-defined functions. SQL Compare does this fiddly and tedious job properly - for example dependencies and referential integrity are properly taken into account and the SQL scripts are of a very high quality.