Database compare utility

  • iland

    SSC Rookie

    Points: 49

    I am looking for database schema compare utility for sql server. QUEST had a tool called schema manager but it's not available for sql server anymore. any suggestions ?

    thank you

  • Andy Warren

    SSC Guru

    Points: 119694

    Red-Gate has one that is pretty nice and reasonably priced - SQLCompare. I've got a review of it posted at:

    http://www.sqlservercentral.com/columnists/awarren/sqlcomparereview.asp.

    Andy

  • ckempste

    SSCoach

    Points: 17983

    Hi

    SQL Compare byt redgate software is a very good and cheap tool. The only real problem I have with it is that it cant be used to generically compare say two different script files you have that were not generated from sql*compare. So its not that "generic" as such. Even so, its damn cheap and I liked the ability to save away previous comparisons. The front-end is nice and very well designed.

    Cheers

    Chris


    Chris Kempster
    www.chriskempster.com
    Author of "SQL Server Backup, Recovery & Troubleshooting"
    Author of "SQL Server 2k for the Oracle DBA"

  • K. Brian Kelley

    SSC Guru

    Points: 114486

    We're required to load all of our scripts into Visual SourceSafe. It does have compare functions, even between versions. Most Change Control software worth their salt have this functionality.

    K. Brian Kelley

    bk@warpdrivedesign.org

    K. Brian Kelley
    @kbriankelley

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

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