Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
up vote 2 down vote accepted

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.

share|improve this answer
Can I connect to the remote database using a local copy of SQL Server, or using some other software, or is it all done via the control panel on the website? – kylex Jun 24 '10 at 15:39

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

TO DISK = 'Z:\SQLServerBackups\SampleDatabase.bak' 

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 ...

share|improve this answer
nice answer. you went and did all the work for him. on the restore the SSMS user interface gives you a wizard to "restore from backup" and in the wizard you choose a "file source" db backup file as your restore source. – djangofan Jun 24 '10 at 18:00

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.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.