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