Gáspár Nagy on software

coach, trainer and bdd addict, creator of SpecFlow

Scripting database including data in SQL Server 2008 Management Studio

by Gáspár on March 18, 2009

I was always missing a function in the management studio of the different SQL Server versions. This was to generate a script from an existing database, that also contains the INSERT statements for the existing data in the tables.

Today I have found out, that there is already such a feature in the Management Studio of SQL 2008, although it is not so easy to find it.

Actually it is very simple. You only have to use the “Generate Scripts” wizard, and on the options step, you have to enable the “Script Data” option somewhere at the end of that long list.

wizard options

Comments are closed.