Skip to content

Script Out Table Data in SQL Server 2008

SQL Server 2008 has a new feature where you can script out data in tables via INSERT statements. Just do the following:



1. Right click on the database and select “Generate Scripts…”

2. Select the database.

3. This is the hidden part. Set “Script Data” to true.

4. Select Tables.

5. Select Tables.

6. You can script out a table script per file or as a single file. I prefer ANSI text.

7. Hit Finish.

Categories

SQL Server

Dan View All

Blog owner.

%d bloggers like this: