I'm looking for an app that will compare the layout of 2 SQL tables. When developing in a DEV environment, I need a tool that will make the production tables exactly like the DEV tables (the layout).
+1
A:
SQL Compare from Red Gate and ERWin are two tools that work. Neither are free
Conrad Frix
2010-07-22 21:36:47
+1
A:
I wrote a program called "SQL Server Comparison Tool" (SCT for short). You can try it for free for 30 days; I can extend that period to 90 days.
You can download SCT from www.sql-server-tool.com
SCT can compare both structure and data. You can "record" comparisons so that you can "re-play" them later without need for entering parameters again.
Dariusz Dziewialtowski-Gintowt
2010-07-23 02:16:34