Generate Script of Database with all the data

(1) Go to Your Database and right click on your database.

b1.png

(2) Click Next Button.

b2.png.

(3) Select the Database that you want to script. Then check the Check Box if you want to generate the script of all the objects (such as the stored procedure etc.). 

b3.PNG

(4) Select the true option from the script data, if you want to generate the script of database with data.

b4.png

(5) Click Next and Finish this task.

b5.png