Total Page Preview:   000000002247

How to Generate SQL Script and Data for table in SQL Server

In this article I am going to explain how to Generate SQL Script with data for Table in SQL Server using Wizard.

Step 1 : Open and login into SQL Server Management Studio.

Step 2 : After login successfully Right click on your Database > Task> Generate Scripts:

Generate SQL Scripts with Data
 
Step 3 :
Generate SQL Scripts with Data
 
Step 4 : Select objects which you want to scripts:
Generate SQL Scripts with Data
 
Step 5 : Select Type of scripts which you required:
Generate SQL Scripts with Data
 
Step 6 :
Generate SQL Scripts with Data
 
Get generated scripts success :
Generate SQL Scripts with Data
 
Result :
Generate SQL Scripts with Data
 
 
Thanks 
By : Brijesh Kumar

Thank You

About Author

Brijesh Kumar

Database Developer

I have more then 6 years Experience in Microsoft Technologies - SQL Server Database, ETL Azure Cloud - Azure SQL Database, CosmosDB, Azure Data Factory, PowerBI, Web Job, Azure Function, Azure Storage, Web Apps, Powershall and Database Migration On-Premise to Azure Cloud.
LinkedIn : https://www.linkedin.com



Comments

SQL tools
11-Oct-2016
Great article. http://www.sql-datatools.com

                           
                           

                           

                           

Facebook User: