CODEWITHSUNDEEP
sql-server-2005
Graviton
Graviton

Reputation: 83254

Export Schema and Data in Microsoft SQL Server Management Express

How to export a database schema and the data in Microsoft SQL Server Management Express? In other words given a database and the data, I want to create an .sql script that will recreate the table structure and the data inside it.

Upvotes: 0

Views: 4548

Answers (2)

Ed Harper
Ed Harper

Reputation: 21505

This can't easily be done within the SQL Express Tools.

If you're willing to look at other tools, have a look at the Database Publishing Wizard from the SQL Server Hosting Toolkit. It's an open-source which will script a database and data into a single script.

Upvotes: 1

mimo
mimo

Reputation:

Go to: \Program Files\Microsoft SQL Server\100\DTS\Binn and run: DTSWizard.exe

example, mine is: H:\Program Files\Microsoft SQL Server\100\DTS\Binn\DTSWizard.exe

Thats all

Upvotes: 0

Related Questions