As a Linux using PostgreSQL and MySQL admin I am used to console tools. Therefore creating a sql dump (schema+data) from a MS SQL 2008 database is a challenging task.

  1. Open Microsoft SQL Server Management Studio
  2. Connect to the database
  3. Right click on the database
  4. Open "Tasks"
  5. Select "Generate Scripts..."
  6. Select the objects to script > all
  7. Set ouput type "Save scripts to a specific location"
  8. Click on "Advanced" (right of "Save to file")
  9. Change General/"Types of data to script" from "Schema only" to "Schema and data"
  10. Ok & Next & Next & Finish