SSMS Create Database Scripts With Data

This is how to generate and save a script for the entire database or just a table with the data. This maybe useful if you cannot create a backup file to your local drive.

In SSMS right click on your database and go to Tasks and Generate Scripts…

You should see the following

Select the database objects.

On this page select where of how you want to save your database script and click on the Advanced button if you want the data or insert statements.

The default is Schema Only but if you want the data select Schema and Data

Click next on the summary Page and then click finished.