SQL Server 2008: Script Data
The SQL Server 2008 Management Studio has a nice little new feature which seems to be omitted from the documentation. The Script Wizard (Database - Tasks - Generate Scripts) now has a “Script Data” option. If selected the Wizard will generate INSERT statements for the data in the scripted tables. This can be very handy.
This is a feature of Management Studio, therefore it works also with older database server versions.
Posted: September 7th, 2008 under SQL Server.
Comments: 1
Comment from Eralper
Time: 20. January 2009, 07:09
Hello Martin,
I use the scripting data a lot especially for lookup data table values. So I found the Script Data wizard very useful. You can check my notes at http://www.kodyaz.com/articles/sql-server-script-data-with-generate-script-wizard.aspx
Thanks