Database version Control

  • Maybe this is an old topic but I dont know the answer.

    What is the best Version control tool for Database management.

    I am not too happy about VSS

    Are there any better programs around ?

  • We are using a tool called "Change Manager" by Embarcadero for saving versions of database schemas. I'm not really sure you could say it is version control software. I does allow you to save versions of the schemas, and compare schema versions to identify changes. It has not checkout/checkin funtionality.

    Gregory Larsen, DBA

    If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

    Gregory A. Larsen, MVP

  • We are using a tool called "Change Manager" by Embarcadero for saving versions of database schemas. I'm not really sure you could say it is version control software. I does allow you to save versions of the schemas, and compare schema versions to identify changes. It has not checkout/checkin funtionality.

    Gregory Larsen, DBA

    If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

    Gregory A. Larsen, MVP

  • What i am really looking for is a tool that can handle the following situation.

    There is a Developement database ( let's say release 3.1.0)

    There is a Test database (let's say release 2.3.0 )

    There is a procuction database Release 2.0.0

    Now you could create seperate projects in VSS. But what is a Stored proc contains a BUG in release 2.0.0. You have to update the SPROC in 2.3.0 and 3.1.0

    The problem is this is a lot of administration.

    Is there an easy tol for this .....

  • I think it's more an admin/process thing than a tool that helps here.

    I wrote on this:

    http://www.sqlservercentral.com/columnists/sjones/vcspart1.asp

    Steve Jones

    sjones@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/sjones

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

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