- Right click on the database and go to Tasks -> Generate Scripts
- Select the tables that you want to generate the script for
- Go to Set scripting options and click the Advanced button
- In the General category, go to type of data to script
- There are 3 options: Schema Only, Data Only, and Schema and Data. Select the appropriate option and click on OK
Half finished documentation, scripts and other scraps from my work related projects.
Friday, May 23, 2014
Exporting Data from SQL Server Managment Studio as INSERT statements
Another quirk of Microsoft SQL Server Management Studio 2008 - they made the option to export table data as SQL insert statements almost impossible to find. Here's how you do it:
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment