SQL SERVER – Create Script to Copy Database Schema and All The Objects – Data, Schema, Stored Procedure, Functions, Triggers, Tables, Views, Constraints and All Other Database Objects

After the script is generated, the next challenge often users face is how to execute this large script as SQL Server Management Studio does not open the file. One can use SQLCMD for the same. See that in the last image of this post.

Pay attention to the option Types of data to script – select option ‘Schema and data’

As the file with data will be very large, use SQLCMD to execute the large script which will create database with schema & data.