Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Review of SQL Compare v3


Review of SQL Compare v3

Author
Message
Robert W Marda
Robert W Marda
SSC Eights!
SSC Eights! (984 reputation)SSC Eights! (984 reputation)SSC Eights! (984 reputation)SSC Eights! (984 reputation)SSC Eights! (984 reputation)SSC Eights! (984 reputation)SSC Eights! (984 reputation)SSC Eights! (984 reputation)

Group: General Forum Members
Points: 984 Visits: 82
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rmarda/reviewofsqlcomparev3.asp



Robert W. Marda
SQL Programmer
Ipreo

Jonr
Jonr
SSC-Enthusiastic
SSC-Enthusiastic (148 reputation)SSC-Enthusiastic (148 reputation)SSC-Enthusiastic (148 reputation)SSC-Enthusiastic (148 reputation)SSC-Enthusiastic (148 reputation)SSC-Enthusiastic (148 reputation)SSC-Enthusiastic (148 reputation)SSC-Enthusiastic (148 reputation)

Group: General Forum Members
Points: 148 Visits: 65

Having used SQL Compare for a couple of years now out in-the-field, I'd agree with your observations Robert. It is an excellent product, very stable and does what it is designed to do very well - I've recommended it to a number of people. It's very good at sorting out the problems experienced by development teams who've not had the know-how to keep dev. and test / production databases in sync. Well worth the money.

(NB: I'm not involved with Red Gate in any way, other than as a happy customer!)




Jon
williamhoos@yahoo.com
williamhoos@yahoo.com
SSC Rookie
SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)

Group: General Forum Members
Points: 29 Visits: 1
I agree completely. It saves amazing amounts of time and the new version's speed is definitely worht the upgrade. A line by line and field by field option for excluding data comparisons and syncronization would be nice. Great product.



VadimK
VadimK
SSC Rookie
SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)

Group: General Forum Members
Points: 30 Visits: 147

I've been using SQL Compare for a few months and I can't agree more with Robert that SQL Compare is an amazing tool. As a DBA I manage over 20 SQL servers and this tool saved me a lot of time comparing databases between PROD, UAT and DEV. Our developers couldn't believe how quickly I was able to find differences in tables, sprocs, etc. Keep it up, Red-Gate!!!





Dean Stevens
Dean Stevens
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 1


After reading all this about Red-Gate I thought I’d give it a go.

It doesn’t work for me and I’m wondering how it can possibly work for anyone else with a database that has any interrelated objects (dependencies) at all.
I noticed the review was made on a database with only 3 tables, 2 views, 1 stored procedure, 2 database roles, 2 users, 1 default and only 2 user defined data types that I can see.

That to me is a meaningless test.

I’m a release manager at NTL in Hook, Hamshire, United Kingdom.

I ran a test on what used to be our most problematic database.
This database consists of the following objects: 796 tables (290 of which contain static data consisting of 107,186 rows), 62 views, 3352 stored procedures, 4 rules, 4 defaults, and 160 user defined functions.

That to me is a meaningful test.

I compared this to the database to be released and came up with 2609 schema changes and 169 tables with data changes consisting of 1603 deletes, 39379 inserts and 11409 updates making row changes 52391.

SQL Compare failed with 302 errors. After that I didn't bother with the data comparison.
Granted it is still better than working this out by hand, but we use another system which for our last 4 releases has never failed and does not need any modifications.
When people say this application fast (SQL Compare) – you have to put it into perspective.
I have to correct all these errors to release the software.
That would take days.

As I have said earlier, this was our most problematic database.
We now use DB Ghost which handles the release perfectly and integrates with our daily build process.

These guys are incredibly helpful and although are nowhere near as big as some of the other software vendors that say they compare and synchronise databases, they’re the best.
I can’t see how the other vendors say they ‘synchronise’ when clearly to me they don’t.

Regards,
Dean Stevens


Mike Yeager
Mike Yeager
Grasshopper
Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)

Group: General Forum Members
Points: 13 Visits: 39

Hey Dean,

We've been using SQL Compare for a couple of years now on a similarly large DB schema. The only issue we've run into with the latest version is with non-nullable columns with a default. We've found that we have to insert the column instead of adding it at the bottom of the list, then set the option to enforce column order. This forces a new table to be built and the data transferred to it instead of adding the column to the existing table definition which will fail. It sounds to me like some of the settings you've used need to be adjusted. I'd especially check on the "Include dependant database objects" option.

I've checked out Embarcadero's Change Manager product and didn't like it as well as SQL Compare, but haven't heard of DB Ghost. I'm going to look it up and give it a run. Thanks for the tip!

Mike


Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search