Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

3 Answers

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
add comment

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

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
add comment

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
add comment

Your Answer

 
discard

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.