Quite Often we get request regarding how to copy all the objects - including schema and data from any database and re-create it on another instance.
SQL Server 2008 & SQL Server 2008 R2 has script generator wizard which does it for us.
Pay attention to the option Types of data to script - select option "Schema and data"
After the script is generated, the next challenge often users face is how to execute this large script as SSMS does not open the file. One can use SQLCMD for the same as shown in the following image
As the file with data will be very large, use SQLCMD to execute the larger script which will create with schema & data.
SQL Server 2008 & SQL Server 2008 R2 has script generator wizard which does it for us.
Pay attention to the option Types of data to script - select option "Schema and data"
After the script is generated, the next challenge often users face is how to execute this large script as SSMS does not open the file. One can use SQLCMD for the same as shown in the following image
As the file with data will be very large, use SQLCMD to execute the larger script which will create with schema & data.
