asked on

Can I Migrate/Upgrade an MS SQL 2005 SP3 (x86) Database to a New MS SQL 2008 R2 (x64) Server

I have an MS SQL 2005 SP3 (x86) that I have been asked to migrate to a new MS SQL 2008 R2 (x64) server.

The details are as follows:

Original DB

Host OS: Win Server 2003 Std SP2 (x86)

DB: MS SQL 2005 SP3 (x86)

Destination DB Details

Host OS: Win Server 2008 R2 Std SP1 (x64)

DB: MS SQL 2008 R2 (x64)

I've taken a look at the Microsoft upgrade path webpage and I can't see an upgrade path. This is very vanilla database install, so I'm hoping I'm wrong:

http://msdn.microsoft.com/en-us/library/ms143393(v=sql.105).aspx

Can any DBA's give some advice, or point me in the right direction?

Thanks,
Fin

ASKER CERTIFIED SOLUTION

didnthaveaname

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Nem Schlecht

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

didnthaveaname

I also neglected to mention that there is a canned query that can transfer all the logins for you here: http://support.microsoft.com/kb/918992

Racim BOUDJAKDJI

Why don't you test it ? Just set up SQL 2008 VM and try...That is what I usually do...

Migration risks primarly depend on the following:

> Code Supportability: some functions may be deprecated on SQL 2008
> Connectivity: see above
> Binary compatibility (32 vs 64)

Hope this helps...

Member_2_4371340

ASKER

It was as simple as backing up the database on the x86 server and then restoring to the new x64 server, then creating a new DB owner. Cheers