by At my company the software we created uses an SQL database. Any
client to whom we sell the software needs to set up a structurally
identical database on their own servers. Only a dozen or so tables
must be populated prior to using the software.
Currently we create a script of our own database, sans data, for them
to run to create their own.
I need a way to script out the database with the ability to add
comments and other code to the script without editing the script
itself every time I create it.
Would this be done in a stored procedure? Is there a SQL tool to
accomplish this? Is there any type of code anywhere that I might get
my hands on to do this?
Any help is greatly appreciated.
Phase II