Link to home
Start Free TrialLog in
Avatar of J.R. Sitman
J.R. SitmanFlag for United States of America

asked on

I need to move an SQL 2005 database to a SQL 2008.

I need instructions to move an existing database from one server to another in the same domain.  
I read through several posts on EE, but could find one that I believe is my same situation.  
I need this done today so max points.

The existing server is 2003 and the new is 2008 R2.
Avatar of Paul Jackson
Paul Jackson
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
anything else going on?

does the database participate in replication ... mirroring etc....

any batch jobs etc to migrate,,,

what about any front end applications?

1.  ensure you have an upto date copy and run the upgrade advisor and see if there are any
     immediate issues you need to deal  with....

2.   as mentioned by jacko72 those are the 2 basic methods....
     you could also create a new database and use replication to migrate the data an structures across.... that may allow you a period of parallel running, and minimise application downtime...

3.   you basically need to choose between leaving the database in sql 2005 (or earlier ) compatability mode, or hoing for 2008  from the start...

4.  test test test...
Avatar of J.R. Sitman


WOW that was way to simple.  All the other posts I read were complicated.