Exporting a MS SQL express database

Question

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?

Answer 1

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.

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

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