Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sherrer
64 Posts |
 Posted - 2003-02-05 : 10:51:16
|
| I am running SQL Server 7.0.I am trying to compare table structures beween a test database and a production database. I am currently concerned about new fields in the test database. I am using the INFORMATION_SCHEMA.COLUMNS to do this. It seems to meet my needs, but I am just wondering if anyone has a better way to compare tables or have written procedures to do so. I will also later be comparing constraints and defaults as well.Thanks for the comments.Kevin |
|
|
jharwood
Starting Member
41 Posts |
Posted - 2003-02-05 : 11:55:31
|
| I use SqlDevPro for quick schema checks. It's a free download and works rather well. The latest version will bring up any discrepancies in a double window to compare. http://www.sqldevpro.com/-J |
 |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2003-02-05 : 14:40:58
|
| I use SQLCompare from redgate. It's an excellent tool and generates reports and change scripts to allow you to sync up schema [url]http://www.red-gate.com/sql_tools.htm[/url]. For a great review of this product have a look at [url]http://www.sql-server-performance.com/sql_compare_review.asp[/url]HTHJasper Smith |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-02-05 : 15:27:22
|
| I also use SQLCompare. It is pretty cheap and worth much more than what it costs. It is priceless. It has saved me hours of work. |
|
|
|
sherrer
64 Posts |
Posted - 2003-02-05 : 17:43:02
|
| Thanks for the comments, I will take a look at the products. The ability to create change scripts already sells me.Kevin |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-02-05 : 18:06:57
|
| You can replicate half the functionality of SQL Compare by scripting out the tables from each database and comparing them in a DIFF tool like WinDiff or ExamDiff.Damian |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-02-05 : 18:30:59
|
quote:
You can replicate half the functionality of SQL Compare by scripting out the tables from each database and comparing them in a DIFF tool like WinDiff or ExamDiff.
True, but SQLCompare is so cheap and it generates the change scripts for you. |
|
|
|
sherrer
64 Posts |
Posted - 2003-02-05 : 22:20:09
|
| Again thanks for the comments, I downloaded the trial version if the red-gate product and it is exactly what I needed. I had already written SQL that gave me all the differences between tables and constraints, but the red-gate product scripts out all the changes. I might add that thier scripts are much better than the scripts generated by SQL Server 7.0... they actually have error handling so you don't lose a table if a constraint fails to drop. As tduggan committed, the price can not be beat, it's paid for in 2 to 3 hours of my time.Thanks Jasper and tduggan |
|
|
|
|
|
|
comparing table structures between databases