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.
- Open Microsoft SQL Server Management Studio
- Connect to the database
- Right click on the database
- Open "Tasks"
- Select "Generate Scripts..."
- Select the objects to script > all
- Set ouput type "Save scripts to a specific location"
- Click on "Advanced" (right of "Save to file")
- Change General/"Types of data to script" from "Schema only" to "Schema and data"
- Ok & Next & Next & Finish