Home / server / Questions / 154460
Accepted
kylex
Asked: 2010-06-25 06:50:44 +0800 CST

Exporting a MS SQL express database

  • 772

I'm attempting to take a current website that uses MS SQL Express 2005 and create a redundant site on another domain.

I've only ever worked with MySQL, and can't seem to find a way to export this data. I think I read somewhere that I need to download some program to do it? What do I need to do to export this database and import it somewhere else?

sql-server-2005 database

3 Answers

  1. Best Answer

    You should do a backup and then a restore. These steps can be made by t-sql or by GUI, anyway read the manual about backup and restore.

    • 2

  2. For a command line Backup of SQL Server , similar to mysqldump try this : 

    BACKUP DATABASE SampleDatabase
TO DISK = 'Z:\SQLServerBackups\SampleDatabase.bak' 
WITH FORMAT;
GO

    save this in C:\backupMSSQL.SQL and then type this in command line : 

    OSQL.EXE -U sa -P -i C:\backupMSSQL.SQL

    this should be work like mysqldump for mysql ...

    • 2

  3. As previously mentioned you will need to do a backup and then a restore. To do this you will need to use SQL Server Management Studio Express which is a separate download. You can find it here.

    • 0