Migrate SQL Server 2005 x86 to SQL Server 2008 x64 in default instance

Hi

We need to migrate a SQL Server 2005 x86, running in a Windows Server 2003 R2 x64 to a SQL Server 2008 x64.

Thanks in advance
zdavidlnxAsked:
Who is Participating?
 
Marten RuneSQL Expert/Infrastructure ArchitectCommented:
Sorry bcsql, not entirely correct!
For clarification, step 3 for bcsqq does not include the system databases, So step 2 above is crucial since you must reinstall every job, all accounts and preserve their passwords.
Otherwise lbcsql is correct. But also check that all databases dont use custom extended stored procedures, or worse, is still using DTS packages (they can be run under sql2005, but not edited).
0
 
bcsqlCommented:
You want to change your default install of SQL 2005 from x32 to x64? you have reinstall.
1) detach databases - alluser dbs, model and msdb.
2) script logins - and jobs just in case
http://support.microsoft.com/kb/918992/
3) save db files and scripts
4) unintall SQL
5) install sql x64
6) attach dbs
7) re attached dbs once files are in correct place.
8) run scripts for logins and jobs if msdb is not reattached.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.