Posted by Erland Sommarskog on 12/02/06 23:47

Mark Olbert (ChairmanMAO@newsgroups.nospam) writes:
> Any help and/or pointers would be greatly appreciated (including other
> strategies on how to affect the transfer

The best is of course to keep all database objects under version control.
In such case, you never have to script anything, you just get what you
need from the version-control system. You would still have to move the
data, but bcp is usually a good choice for this.

In lieu of a source-control system to get the source from, you can use
Generate Scrips from the Object Explorer in Mgmt Studio. Select the
database, right-click and then to the Tasks submenu. Once the tables
are up on the other side, you can use BCP to move the data.



--
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: SqlServer2005: Transfer Sql Server Objects
• Prev in forum: Re: Need Help Getting the day shift after midnight
• Thread view: Re: SqlServer2005: Transfer Sql Server Objects

[Reply to this message]