Script table data in SQL Server 2008


When you script your database objects, the default setting for script data for a table is false. You can change the setting to true to script your table data.
Right click on your database>>Tasks>>Generates Scripts… (Load the Wizard)>> click NEXT>>Choose database and click NEXT>>within Choose Script Options window, scroll down to Table/View options section and change Script data option to True.>>Next to choose table to script>> click NEXT and NEXT to clcik the  Finish
button. You will have your table along with the data in a script.
Advertisements


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s