Post reply

Subversion with SQL SRVR- How to manage SP AND TABLES

  • May 8, 2006 at 2:03 pm

    #93975

    Hi,

    We have subversion running and I wanted to know whats the best way of using it for SQL SERVER purposes like updating stored procedures, altering tables, and other kind of scripts associated with daily database tasks...

    Can somebody guide me how I can maitain copies of sp,*.sql in repository?

    Thanks in advance.

  • May 11, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • May 11, 2006 at 8:54 am

    #637284

    Since Subversion is essentially a file management system, all you have to do is generate the appropriate files and then import those files into Subversion.  For tables, stored procs, views, functions etc. you can always right - click in Enterprise Manager, go to All Tasks and generate scripts. 

    Do you have a specific question?

  • May 11, 2006 at 9:01 am

    #637291

    there is a plug in for source safe on this site which keeps all the DDL in source sage for you; you could use that application as far as source control for table and proc definitions, etc

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

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

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