Generate SQL Script With Data in SQL Server

In this article we learn how to generate a SQL Database script with data.

In this article we learn how to generate a SQL Database script with data.
 
 Step 1: Open SQL Server and right-click on the specific database (for which you want to create a script).
 
Right-click on the database then select "Tasks" -> "Generate Scripts...".

Generate Scripts
 
 Step 2: Now click on the Next Button

Next Button
 
 Step 3: Click on the Next button

Next button
 
 Step 4:
Now click on Advanced.

Advanced
 
 Step 5: Select "Schema and data" then click on OK.

OK
 
 Step 6:
Provide the Script Name and location where you want to save it then click on Next.

Name and location
 
 Step 7: Click on Finish.

Finish