April 3, 2003 at 5:09 am
There's a number of 'compare tables' queries posted at the various code depots. I'm looking for opinions as to which is best in terms of options offered to sql2k.
thankx
--steve...
April 3, 2003 at 5:29 am
You want to compare table structure or data?
April 3, 2003 at 5:39 am
I currently use SQLCompare and find it quite good, have had a request in for a while to review AdeptSQL - just haven't had time, supposed to be faster, not sure how it compares on features.
Andy
April 3, 2003 at 5:57 am
quote:
You want to compare table structure or data?
Need to compare both. Can consider commercial products but really looking at lower price tier.
April 3, 2003 at 7:30 am
I think all of them are $200 or less. Lockwood also has one, should have mentioned:
http://www.lockwoodtech.com/index_sqldiff.htm
Andy
April 3, 2003 at 8:59 am
I'm currently testing Adept SQLDiff. It is nice when the tables are in different databases, but you can't compare two tables in the same database. I can only speak for the table structures not the table data.
Michelle
April 3, 2003 at 9:36 am
To compare data structure I create a script that uses checksum(). Cheap and easy...
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply