Posted by Erland Sommarskog on 05/24/07 21:54

(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@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

• Next in forum: Re: Rants. Difficulty to learn ETL tools?
• Prev in forum: Re: Remove neighbouring duplicates
• Thread view: Re: Use CVS server with SQL Server

[Reply to this message]