How to create script of Database in Sql Server?

In this article I will explain how to generate database script of Database in Sql Server.

Steps to Follow:

1.       Right click on the Database of which you want to generate Script. Go to Tasks>Generate Scripts.

2.       Click on next.

3.       See the image. In this step you have two options to create Database script. One is entire database script and another one is select specific Database objects. Here I go with entire Database script. After that click next.

4.      In this step specify the save location to script. There is another option i.e. advanced. In advanced you can select script with Data or only schema or only data options. Now click Next.

5.       Here summary of script will show. Click on next.

6.       Scripts will be published and saved to given path.

After the completion of publish click on finish. Database script is created on selected path.