6 September 2008
Exporting SQL Server 2005 Express data
Posted by Mikhail Esteves under: Tips; Windows .
SQL Server 2005 Express does not come with a DTS Wizard unless you install the SQL Server 2005 Express Toolkit, and run DTSWizard.exe manually. An easier way to export your schema and data to a remote SQL Server installation would be to use the SQL Server Database Publishing Wizard. This utility gives you a simple wizard you can use to directly export to a remote server.
No clue why this useful utility is not part of the standard SQL Server 2005 Express installation…