Export Schema and Data in Microsoft SQL Server Management Express

Question

Hello,

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.

Answer 1

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

Answer 2

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.