CODEWITHSUNDEEP
sqlsql-server-2008
JHarley1
JHarley1

Reputation: 2112

SQL Server Management Studio 2008 R2 Export Structure + Data

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

Any ideas on how this can be achieved? I have tried using the database import/export wizards to no avail...

Upvotes: 7

Views: 11559

Answers (1)

drew
drew

Reputation: 1312

Right click on database, to go tasks, generate scripts. Make sure you choose the option "Schema and Data" for what "Types of Data to Script" when clicking on the "Advanced" button.

Upvotes: 14

Related Questions