Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

copy one DB to another

11 views
Skip to first unread message

mcnewsxp

unread,
May 3, 2013, 9:06:03 AM5/3/13
to
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

unread,
May 3, 2013, 3:39:31 PM5/3/13
to
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.


--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

mcnewsxp

unread,
May 4, 2013, 11:46:22 PM5/4/13
to
mind chatting about that?
0 new messages