Export - Import Database with SQLExpress [Archive]

Click to See Complete Forum and Search --> : Export - Import Database with SQLExpress

skuehner

June 2nd, 2006, 03:00 PM

Hello,

How can I import or export a database of SQLEXPRESS? Do I need a special program? I can't find a menu entry in the Visual Studio 2005.

A Dump would be fine...

skuehner

June 2nd, 2006, 04:56 PM

I found something:

* Create dump device:

EXEC sp_addumpdevice 'disk', 'mydumpdevice', 'c:\dump.dmp'

* Make dump:

DUMP DATABASE mydb TO mydumpdevice

The problem is that I can't reload it (with LOAD DATABASE), because the db's must have the same name.

Has anyone of you another idea? A real dump (with CREATE TABLE,...) would be nice!

DanielaTm

June 5th, 2006, 03:53 AM

Sql server express doesn't support import/export database, see:

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

Can't you save a script of the database and run it on the other server?