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:
  • 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
Found that gem here.

No comments: