SQL Server Performance

Synchronizing schemas

Discussion in 'Third Party Tools' started by viteb, Feb 26, 2007.

  1. viteb New Member

    Hi.

    I want a tool to help moving database changes from dev to test and then to prod.

    It must support MS SQL Server 2005 and handle rollback in case of error and referential integrities. Price is not so important.

    The tools I have found to cover this are

    SQL Compare 5
    SQL Farm Combine 1.4
    DB Ghost 4.5.1422
    DB SynchroComp 4.0
    SQLDBcontrol 1.4

    Does anyone have a favorite or comments on any of these?


    Thanks,EB
  2. dineshasanka Moderator

    I have work with SQL Compare 5. it is quite a good tool. You can check for product reviews in this site on SQL Compare.
    in addition, I have also worked with DBMaestro it is alos a good tool.


    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/
  3. viteb New Member

    After doing some testing on trial versions we go for Red-Gate's SQL Compare.

    Seems to be simple and fast and handles most cases incl. partitioned tables. It only needs installation on client.


    Thanks,EB
  4. dineshasanka Moderator

    Also, their support is execelent

    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/
  5. FrankKalis Moderator

    Here are 2 other tools:
    ApexSQL Diff
    Idera SQL change manager

    --
    Frank Kalis
    Moderator
    Microsoft SQL Server MVP
    Webmaster:http://www.insidesql.de

Share This Page