Get SQL dump with data from SQL server 2008 studio

Home > Windows > Microsoft SQL server > Get SQL dump with data from SQL server 2008 studio

To get SQL dump with data (Table rows including values) from SQL server 2008 studio use following steps:

1. Right click on database and from Tasks menu choose "Generate scripts"
2. Choose to generate scripts for required tables / views etc. or for entire database and click next
3. On the next screen with option to specify SQL dump destination file click "Advanced"
4. In the popup change value of "Types of data to script" from "Schema only" to "Schema and Data"
5. Close the popup and specify other details as per need
6. Export the SQL dump

Refer:

• https://stackoverflow.com/questions/1391110/how-can-i-get-a-sql-dump-of-a-sql-server-2008-database

Home > Windows > Microsoft SQL server > Get SQL dump with data from SQL server 2008 studio