[How To] script data in MSSQL Server 2008 R2 using Script Wizard

Mike10/10/2012

• Right clicking on the DB
• Click on tasks
• Click on generate scripts
• Go through the wizard and select your tables
• On the options page click the Advanced button
• Change the “Types of data to script” option, from the default “Schema only” to “Schema and data”.