Post reply

need tool for db version comparison and updating...

  • October 18, 2005 at 8:23 am

    #89688

    Hi,

    I am working on an application in an area in where we need to change our db structure quite often.

    So what I am looking for is a tool which can compare two databases (only the structure (tables, columns, indexes, constraints,...)) and shows me the differences.

    It would be great if such a tool can help me also with the conversion from the older version to the newer version.

     

    Cheers,

    Jan

  • October 18, 2005 at 10:51 am

    #598002

    Look at SQL Compare from Red-Gate:

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

     

  • October 19, 2005 at 1:38 am

    #598157

    Thanks!!

    This is exactly what I am looking for..

    Does anyone know some more tools so we can do a good comparison between them?

    Jan

  • October 19, 2005 at 1:46 am

    #598158

    ApexSQL has a nice product as well, frequently advertised here.

    There are lots of others as well, a quick Google for "sql server database compare" will find you a whole bunch.  Price/quality varies, Red-Gate and ApexSQL both have nice products.

     

  • October 20, 2005 at 2:08 am

    #598588

    I have tried a few different ones.. and have found Redgate to be the best in quickness , ease of use...

     

  • October 20, 2005 at 5:47 am

    #598639

    I use Redgate for exactly this purpose and I consider it to be an excellent tool.

  • October 20, 2005 at 7:49 am

    #598711

    I am using "XSql Object Compare" to keep databases in sync.  It is doing a great job.

Viewing 7 posts - 1 through 6 (of 6 total)

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