SQL Server Management Studio 2008 R2 Export Structure + Data

Question

I want to export the structure and data in my database to a .sql file, then to execute as a query on another computer.

Any ideas on how to achieve this? I tried to use the database import / export wizard to no avail ...

Answer 1

Right-click on the database to run tasks, generate scripts. Make sure you select the "Schema and Data" option for "Script Data Types" when you click the "Advanced" button.