We are using the SQL Data Compare and the SQL Compare to keep our development and our production databases synchronized.

The SQL Data Compare looks at tables that you specify and compares the data in each table and allows you to move data one way or the other.

The SQL Compare will compare tables,stored procedures and other db objects and show the differences between the two. The program will create a script that you can either run in the SQL Compare program or copy into query analyzer and run.