0

What is the most efficient way to migrate an SQL Server Express database from one server to another? I have several databases that need to be moved, and I want to do as little work as possible and avoid breaking anything.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
smartcaveman
  • 41,281
  • 29
  • 127
  • 212

1 Answers1

1

Backup and restore.

You backup your database some location and you then restore from that location but you target a new database on your target server (overwrite any changes).

It's fast and straight forward. You can however, not use this to move databases cross different versions of SQL Server (it should be fine to use this to migrate from express to standard but the other way around might be problematic as the standard edition isn't subject to the same limitations as the express edition).

John Leidegren
  • 59,920
  • 20
  • 131
  • 152
  • Will this be problematic moving from 2005 to 2008? – smartcaveman Jun 09 '11 at 11:57
  • Can't say, it might be possible, the database is going from older to newer, you'll just have to try it. I believe it would because otherwise there wouldn't be anyway for you to upgrade a database other than to reattach existing MDF/LOG files. I don't have the necessary stuff available to test it. – John Leidegren Jun 09 '11 at 12:46