Generate Sql Script with Data

Generate Sql Script with Data

In this Article we learn how to generate sql Database script with Data.

 Step1:

Open Sql Server and right click on the Specific database(for which you want to creat script)

 ­Database -------> Right click --------> Task‑‑‑‑‑‑‑>Generate Scripts

                                  

 Step2:

Now Click on Next Button

                                   

  

Step3:

Click on Next button

                        

Step4:

Now Click on Advanced .

                        

                          

Step 5:

Select Schema and data‑‑‑‑‑‑‑>Click on OK 

  

  

                         

Step 6:

Give the Script Name and location where you want to save it  ------->Click on Next

                     

Step 7:

Click on Finish.