Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Review of SQL Compare v3 Expand / Collapse
Author
Message
Posted Sunday, December 28, 2003 12:00 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, November 5, 2013 9:05 AM
Points: 976, Visits: 59
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
Post #19582
Posted Thursday, January 15, 2004 2:15 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, November 13, 2014 6:23 AM
Points: 142, Visits: 63

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
Post #95361
Posted Thursday, January 15, 2004 6:55 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, June 27, 2006 12:41 PM
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.


Post #95409
Posted Thursday, January 15, 2004 9:12 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, October 9, 2014 12:12 PM
Points: 28, Visits: 124

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!!!




Post #95466
Posted Friday, May 28, 2004 9:13 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, October 6, 2006 8:36 AM
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

Post #118288
Posted Friday, May 28, 2004 9:44 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, November 7, 2014 4:28 PM
Points: 13, Visits: 33

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

Post #118300
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse