Post reply

From Database to VSS or VSS to database

  • November 15, 2005 at 12:25 am

    #88493

    Hi,

    We know SQL Server 2000 and VSS is not tightly integrated, I guess many DBAs have faced problems keeping the code in these two places sychronized.

    I would like to know your thoughts on the following process (there is one common login under which the objects are created)

    Process #1

    Developers work on the database objects in the SQL Server directly and the DBA maintains the VSS by scripting the database into the VSS at the end of the day

    Process #2

    Developers maintain both the VSS and the database by checking out the VSS script file first and make changes

    Thanks

    Sachin


    Regards,
    Sachin Dedhia

  • November 16, 2005 at 1:43 am

    #604103

    in process one, where is the audit information on who, when and how all the changes were made? A snapshot will always have the one person as the who and the history of changes may not be accurate.

    in process two - what happens when a developer destroys the database and all the other developers are compromised? Is the database audited against what is in the source control?

    I like all developers to work on their own databases, they screw it up - they fix it. They need to check out and check in the source code. If it ain't in the source code system - It doesn't make it into any other environment. That way the source code system holds the truth of the system - developers can change it and they are responsible and can be audited.

    Then the database is built from a labeled set of source code to prove the code holds together on a scheduled interview as a heartbeat of the project. Breakages are quickly sorted out as the source control has a full audit trail. This database is then used to compare and synchronize your testing, UAT and eventually your production databases.

    It helps to have a tool that does all of this - http://www.dbghost.com

     

     

    regards,

    Mark Baekdal

    MSN m_baekdal@hotmail.com

    +44 (0)141 416 1490

    +44 (0)208 241 1762

    http://www.dbghost.com

    http://www.innovartis.co.uk

    Build, Comparison and Synchronization from Source Control = Database change management for SQL Server

     

     

     

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

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