>>No, it creates DDL script only. For data check recent
Re: Script to Insert data Thread #
960451.
>
>Thanks, but this assumes the data is within the same database. Here, we are deploying into a new server where the data resides on a source server. Should we only execute such command by making reference the database from the other server? Is there a way to automate all that from a script?
If you've acces to both servers at the same time, you can use DTS to transfer data or you can use EM Copy Database Wizard to copy whole DB including data.
The scripts from the thread above allow you to generate another scrip with INSER command that you can run on destination server after you creted tables. See
http://www.mssqlcity.com/Scripts/ImpExp/DataAsInsertCommand.sql
--sb--