Create Insert Script in SQL Server 2008..

by Ravi Tuvar 10:30 PM 0 comments

If we want to generate Insert Script with data values, it was not possible before SQL Server 2008.
Now SQL Server 2008 support insert script with data also.

Here are steps for it

1. Right click on database, select task -> generate scripts

2. Follow the wizard , select DATABASE

3.In the choose script options, select Table View Options -> script data

Follow remaining options.

The script generated by wizard will have insert script with data.