Use CVS server with SQL Server

Hi all!

We are a little group of databases developers, we use SQL Server and
we manage our source code with CVS.
Actually, with enterprise manager we create the SQL script. This
solution is very boring and error-friendly.
Does anyone know of any tools available for manage easily databases
object source whitout use VSS?

Thanks
Ale

(pipponec@libero.it) writes:
> We are a little group of databases developers, we use SQL Server and
> we manage our source code with CVS.
> Actually, with enterprise manager we create the SQL script. This
> solution is very boring and error-friendly.
> Does anyone know of any tools available for manage easily databases
> object source whitout use VSS?

We use VSS, but I don't see why CVS would be different. We check out
from VSS Explorer, edit in Textpad (a third-party editor), compile
the procedure through a command-line tool, test, edit, compile etc
until we are satisfied, until we check in through VSS Explorer again.
With CVS just replace VSS Explorer with the interface for CVS.

The key here is to look at your database a container for binaries. No
need to script anything.


--
Erland Sommarskog, SQL Server MVP, esquel.DeleteThis@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx