SQL Server Version Control

  • What is the best tool for Sql server 2005 version control ? Team foundation server (MISSCA) or VSS ? Or any other easy tool ?

    Any help would be appreciated .

    Regards,
    SQLDBA

  • I use VSS and the ApexSQL Edit editor so I can double click on the objects in VSS to check them out and open them.

  • I'm partial to SVN with tortoise and VS integration. Throw in SQL Compare professional to generate diff scripts...

    Joe

  • ApexSQL has VERY slick source code control functionality and allows the use of a number of code storage back ends.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • Apex SQL Edit has very good source control integration. Tools from other vendors like Quest and RedGate probably do, too.

    But why not just use the source code integration in Management Studio? If you create projects to contain your scripts, Management Studio will be happy to work with source control.

    Visual Studio Team Edition for Database Professionals is another way to go, if you don't mind spending the money.

  • I have heard from a number of sources that Team Edition for Database Pros is truly a 1.0 product.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

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

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