How to Generate Script along with Data?

One of the new features available in SQL Server 2008 is scripting the tables along with data (in the form of INSERT statements). Here are the useful links that can help you generating script with data

SQL Server 2008
http://www.kodyaz.com/articles/sql-server-script-data-with-generate-script-wizard.aspx

SQL Server 2000/2005
 http://www.microsoft.com/downloads/details.aspx?familyid=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en

 

Published Friday, August 21, 2009 12:16 PM by Madhivanan
Filed under: , ,

Comments

# How to Generate Script along with Data?

Friday, August 21, 2009 7:48 PM by SqlServerKudos

Kudos for a great Sql Server article - Trackback from SqlServerKudos

# Powershell and SMO scripting – Part 3

Saturday, August 22, 2009 4:31 PM by Martin Bell UK SQL Server MVP

In SQL Server 2008 Management Studio you can now script a table definition plus the data as INSERT statements, so how can you do that programatically with Powershell? In the third in my series of investigations I will look at how it can be done.