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

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.

 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.

Name and location
 Step 7: Click on Finish.