Comparing multiple SQL databases

  • Hi there,

    I'm not sure if I posted this question in the correct forum, but here it is :

    I have multiple database :

    1) Development

    2) Testing

    3) Production

    The changes are first made in development database, after that is is transferred to the test database, en later after all the tests passed, it is going live in the production database.

    My question is :

    What is the best way / best tool to compare the changes between the database / schema's.

    What we want to compare is :

    everything from a table, column, stored procedure etc etc...

    Thank you all very much

    Nathan Boor

  • I use redgate sql compare for this and it works really well..

  • I use redgate SQL Compare and SQL Data Compare for this. The tools are well worth the investment.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • Hi all,

    Thanks for the replies.

    But is there nothing in SQL Server 2005/2008 that can do that ??

    And what do you think about Visual Studio Team System Database Edition ?

    What is the best tool ?

    Thank's

    Nathan

  • I am not aware of a native tool that can do the same things. You can build your own (sort of) using SMO with Powershell or other utilities.

    I have no experience with Visual Studio Team Edition - so I couldn't comment. However, I do use the redgate tools and they are well worth the money.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • The VSTS tool is Red Gate's under license.

    There are other compare tools, but there is no best one. Try one or two, pick the one that works for you.

  • Steve Jones - Editor (4/16/2009)


    The VSTS tool is Red Gate's under license.

    There are other compare tools, but there is no best one. Try one or two, pick the one that works for you.

    Now that is interesting information - did not know that.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • Steve Jones - Editor (4/16/2009)


    The VSTS tool is Red Gate's under license.

    There are other compare tools, but there is no best one. Try one or two, pick the one that works for you.

    Hi Steve,

    What exactly do you meen by VSTS tool is Red Gate's under license ?

    Do you meen that the VSTS tool is the same as Red Gate's (under water ?) ?

    Thanks

    Nathan

  • If you have Visual Studio, here you have a manual with MS Source Safe http://www.dbazine.com/sql/sql-articles/cook11

  • I agree with Steve Jones. There are many tools and they all provide the same basic functionality but with different UI and different features. You just choose the one that suits you best.

    SQLC is a good tool and very cheap compared with most other DB Compare tools and has good UI and features.

    You can get it here[/url]

Viewing 10 posts - 1 through 9 (of 9 total)

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