copy one DB to another

[mcnewsxp]

when my company adds a new client I need to copy an existing database into a new database. mostly table schemas and stored procs plus several lookup tables that will include the data contained in them. I would like to automate this process.
where's a good place to start?

tia,
mcnewsw8

[Erland Sommarskog]

Post by mcnewsxp
when my company adds a new client I need to copy an existing database
into a new database. mostly table schemas and stored procs plus several
lookup tables that will include the data contained in them. I would
like to automate this process.
where's a good place to start?

Keep your code under version control, including the INSERT-files for the
lookup tables, and build the databases from scripts, as well as update the
existing databases from scripts.

[mcnewsxp]

Post by Erland Sommarskog

Post by mcnewsxp
when my company adds a new client I need to copy an existing database
into a new database. mostly table schemas and stored procs plus several
lookup tables that will include the data contained in them. I would
like to automate this process.
where's a good place to start?

Keep your code under version control, including the INSERT-files for the
lookup tables, and build the databases from scripts, as well as update the
existing databases from scripts.
--
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

mind chatting about that?