Generate synchronization scripts in SQL Server with TableDiff
Posted April 23rd, 2008 by Andrew PopoffDBAs often have to find the differences between lookup tables in different database environments (i.e., development, quality-assurance, staging, and production). The data in these lookup tables are required to be the same across environments to ensure that your testing is accurate.
There are a variety of great tools on the market that will run these comparisons, as well as perform many other functions. You don’t need to go out and buy one because SQL Server comes with a tool called TableDiff that will do this for you.
TableDiff allows you to easily compare the data in tables, and it creates scripts for you to synchronize lookup data between your testing and production environments. TableDiff is also very useful for synchronizing data between production servers and replication servers to accommodate for when replication problems occur.
Leave a Reply