Post reply

SQL Compare with SQL Data Compare OR SQL Delta?

  • September 8, 2005 at 8:53 am

    #110183

    Hi, 

              Im looking for a good product to compare db shema, table, object, script, data etc.

    I found 2 interesting product. SQL Compare and SQL DATA Compare from Red Gate Companie, and SQL Delta.

    Anyone have already done a comparaison of these product? If you have recommendation on one of these product, pls tell me!

    http://www.sqldelta.com/index.html

    http://www.red-gate.com/SQL_Compare.htm

    http://www.red-gate.com/SQL_Data_Compare.htm

    Thx,

    Francois

  • September 9, 2005 at 2:54 am

    #588645

    Red-Gate SQL Compare is good....and very reasonably priced for what you're getting.  The Data Compare is o.k....but not as good as SQL Compare especially at identifying/scripting changes....or at least the version I used wasn't.  Fine to produce a "potential difference set to be eyeballed", but I wasn't brave enough to let it synchronise the data.  Awareness of referential integrity and the order in which to perform inserts/deletes is something a DBA must add to the use of the product.

    It's available on a trial version as well.

  • September 9, 2005 at 10:14 am

    #588782

    Been using SQL Compare and SQL Data Compare from Red-Gate for some time and really like it. Actually it saved us quite a bit of time once when our failover process didn't quite work right and we had to synchronize data between two servers (about 200 thousand records were different). The tool was a godsend.

    The folks at Red-Gate are quick to answer questions and provide improvements. That lead us to purchase more tools from them such as their SQL Backup and Log Recovery tools.

    SJ

    Accepting all invites

  • March 20, 2006 at 2:06 pm

    #627706

    if you just want to compare data try http://www.getfirefly.net/

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply