Generate SQL Script and Data for table in SQL Server

Total Page Preview: 000000003015

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

http://www.sql-datatools.com

Relpy






Notify me of new comments via email. Notify me of new posts via email.

Recent Posts

How to get the alternate rows or records from table in sql server

Data Warehouse Three Tier Architecture

SQL Server - Fragmentation on azure sql database

Limitations of Azure SQL Database

PIVOT and UNPIVOT in SQL Server with Example

SQL Server - Find unused indexes on azure SQL database scripts

SQL Server - Find all index with key columns on Azure SQL Database

Find Resource usage in Azure SQL Database using script or T-SQL

How to Set client IP Address using the firewall security in Azure SQL Using Portal

What are the types of User Define Function and difference between a nested UDF and recursive UDF in SQL server?

Top 60 SQL Server Interview Questions Answers for freshers and experienced

Top 16 performance query optimization techniques in SQL Database?

What is a Trigger and type of trigger in SQL server?

How many types of dimension tables available in data warehouse?

Data warehouse Interview Questions Answers for freshers and experienced

What are the differences between OLTP and OLAP?

What is Table Variable? Explain its advantages and disadvantages?

What are the different types of Error Handling in SQL Server?

Cloud Data Engineer SQL Server Interview Questions Answers for freshers and experienced

What are characteristics and advantages of stored procedure?

Facebook User: