How To Generate A Script In SQL Server 2012

In this article I will show you how to generate a script with schema and data and create a new database in SQL 2012.

Here are the steps, 

Generate a Script in SQL Server 2012

Open you SQL Server and give the login credentials.

Generate a Script in SQL 2012

Once you login you will can see all the databases In SQL in your object explorer on the right side.

explorer

Click on Databases to view all the existing databases in SQL,

databases

From the above databases let us generate a script for KTMBDB database for sample testing.

Genetare script

Right click on database and select-tasks, then Generate Scripts.

Then it will open a window with the following screenshots,

open a windows

Based on your requirement, if you want to take complete script you can just click next, else if you want to generate script only for Tables select tables from the above screen. After that click next.

Here I am generating script only for tables by selecting the tables option.

tables

Also you can choose more selective option once you click on Tables .Then click next.

click on Tables

In above screenshot there are some options for us which depends on our requirement.

Firstly, select save to new query window (Best Practise).

Then click on Advance Tab shown above.

click on Advance Tab

Now scroll down the bar and find the following options,

scroll down the bar

Here, if you want to generate a script only for Schema (Only tables without data then select Schema only else Select Schema with data).

Then click OK and then next.

Click next

Nothing to do with this screen, just click Next and then again click next.

Then automatically you will seena script in the SQL Query Window as in the following,

script

Then change your DB name beside USE at the top of very first line and remove the highlighted area and just run.

Note: Before running make sure you create a new database manually (just simple database).

Please try this when you need and hopefully you will like it.