SQL Scripting (was RE: [cvsnt] Synchronize source code with database?)

[Peter Crowther]

> From: Bo Berglund [mailto:Bo.Berglund at system3r.se] 
[...]
> With SQL-Server we do it differently. Here we have moved to a 
> sql script that creates the database on the target system.
[...]
> We update this script manually (do not use the SQL automatic scripting
> function!) so wa can keep a good control over where items are 
> done and also the naming system is under control.

The auto-scripting function seems to be tolerable in SQL2000, Bo - what
problems have you come up against?  Although I agree that I'll use a
hand-maintained script if given the choice!

		- Peter