Connecting Tech Pros Worldwide Forums | Help | Site Map

Using CVS and SQL Server

Jonathon Roberts
Guest
 
Posts: n/a
#1: Jul 20 '05
We've been using CVS for our HTML, JAVA etc..

Now we would like to use it for our SQL CODE to. We have a large
database with many stored procedures.
I would like to have something using Ant like:

Download the latest version of source code.
If the SQL patch has been updated, run the patch to update the
Database.

I don't know how to deal with the SQL patch files. Do I update the
same file(over writing the anything from the previous patch, or just
write new files for each version?)

I am sure someone has done something like this.

What are the best practices for doing this? Could someone please
outline thier setup for SQL version control?

Thanks,
Jon



Closed Thread