0

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?

jscott
  • 24,484
  • 8
  • 79
  • 100
kylex
  • 1,421
  • 5
  • 14
  • 18

3 Answers3

2

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.

lg.
  • 4,649
  • 3
  • 21
  • 20
  • 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
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 ...

aleroot
  • 3,180
  • 6
  • 29
  • 37
  • 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
0

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.

Ally Reilly
  • 366
  • 1
  • 7