How to Generate Script for both schema and data using SQL server management Studio 2012

In this video tutorial tutorial I will demonstrate you how to generate SQL Query Script for both schema and data using SQL Server management Studio 2012.

1. Right click on the database and select tasks --> generate scripts

2. Next --> select the requested table/tables (from select specific database objects)

3. Next -- >click advanced --> give types of data to script = "schema and data"

4. Next and click finish button.