Many times we need to generate SQL Script of table not only schema but with data also. SQL server provide this functionality inbuilt. TO generate SQL script of any object in a DB of SQL server follow below steps Generate Script for an object
Follow below steps to generate script of table with data
Right click on DB -> Task -> GenerateScripts
A new Window will open as shown below, then click on 'Next' button
After clicking on Next button, a new wizard will open for selecting object for which you want to create script, select second radio button for selecting specific database object and then select the check-box of your table as shown below
After clicking on 'Next' button, Click on 'Advance' button
In the advance option change general settings of 'Types of data to script' -> Schema and data and then click on Ok button
After clicking on Ok button, you can change directory path where you want to store your script and then click on 'Next' button
Click on 'Next' button
Click finish button, your script will be stored in the given location
Open the script in SQL Server
No comments:
Post a Comment