22 September 2008
Exporting Data from SQL Server Express 2005
One area in which SQL Server Express is sorely lacking is its import/export capabilities. You can download the Microsoft SQL Server 2005 Express Edition Toolkit, but that still won't generate the INSERT statements to populate your tables on another server. If you navigate to following folder, you can run the DTS Wizard tool,
C:\Program Files\Microsoft SQL Server\90\DTS\Binn
After some Google searches, this result turned up from Vyas Kondreddi. With some tweaking, it can probably work for other databases, too.