Generate SQL Script With Data in SQL Server

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...".


 
 Step 2: Now click on the Next Button


 
 Step 3: Click on the Next button


 
 Step 4: Now click on Advanced.


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


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


 
 Step 7: Click on Finish.