version control of sql

Results 1 to 3 of 3

Thread: version control of sql

  1. #1
    Join Date
    Dec 1969

    Default version control of sql

    can anyone please let me know if i have to track db changes and maintain a version control for sql databases ( sql server 7/2000 ) what do i use ? <BR>there are a few products but everyone says nice about their own product obviously. i personally have not had a chance to go through all and check. can anyone/Dutch recommend me ? <BR><BR>any hint is highly appreciated.

  2. #2
    Join Date
    Dec 1969

    Default RE: version control of sql

    Personally I don&#039;t use version control software for sql.<BR><BR>I write everything in a test database, and move the procs/tables/whatever to the production database when ready.<BR><BR>To check between versions I created a simple proc that checks the sysobjects of both databases.<BR><BR>

  3. #3
    Join Date
    Dec 1969

    Default I have nothing to do with it..

    .. but, the way that it&#039;s done here is through storing the .SQL files in Source Safe.<BR><BR>They only track changes on the Stored Procs.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts