how to Upgrade/migrate MS SQL 2005 SP3 X86 to X64 with 40+ live databases

I have 40+ live databases on this server below is the info on MSSQL 2005.

Microsoft SQL Server Management Studio            9.00.4035.00            SP3      Standard Edition
Microsoft Analysis Services Client Tools            2005.090.4035.00
Microsoft Data Access Components (MDAC)      2000.086.3959.00 (srv03_sp2_rtm.070216-1710)
Microsoft MSXML                              2.6 3.0 6.0
Microsoft Internet Explorer                        6.0.3790.3959
Microsoft .NET Framework                        2.0.50727.3603
Operating System                              5.2.3790       Windows server 2003 Standard Edition x64 SP2
                                          
Hardware environnent                         HP DL380 G5 2 x 2.83Ghz Quadecore, 8GB RAM

I have some future plan of installing high end Enterprise Project Management solutions which requires x64 bit architecture of MSSQL too… I would like to get my existing MSSQL server which is X86 get converted to X64 what steps are involve; please provide as much info as possible.
LVL 1
immipathanAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DBAduck - Ben MillerPrincipal ConsultantCommented:
The way to do this is to stop SQL Server x86 and uninstall SQL Server and then reinstall SQL Server x64 version and then stop SQL Server and make sure that the file structures are all the same as before.  Move the database files .mdf and .ldf of all system and User databases back in the place where they were before and then start SQL Server.  It will see the master, model, msdb and the user databases and use them as if it never left the server.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.