Home > IT Answers > SQL Server > upgrade SQL Server 2008 32-bit to 64-bit
Revsoft
5 pts.
 upgrade SQL Server 2008 32-bit to 64-bit
Microsoft SQL Server
We have a new SQL STANDARD SERVER 2008 R2 x64, and an existing SQL STandard Server 2008 R2 x32. I want to migrate the database from the old x32 bit to the new x64 bit machine. Has anyone got any information regarding this, or resource to research read up on. Thank you



Software/Hardware used:
SQL STANDARD SERVER 2008 x64bit
ASKED: October 25, 2011  11:54 AM
UPDATED: January 1, 2012  10:09 AM
RELATED QUESTIONS
Answer Wiki:
All you need to do is detach the database from the old server and attach it to the new server. You can also backup the database and restore it to the new server. As far as the database is considered it doesn't care if it's on a 32bit or 64bit system.
Last Wiki Answer Submitted:  October 27, 2011  9:02 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Hi I found this, but this is for x64 enterprise..

http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/2a6a3eea-41e0-4e0a-962c-cd834d881f7c/

and i am not sure if your hardware specification, maybe you can read here

http://msdn.microsoft.com/en-us/library/ms143506.aspx

jinteik
 15,485 pts.
 

To Upgrade from Sql server 2008 32 bit to sql server 64 bit.The version and edition upgarde can be easily understood by the following microsoft website:
http://msdn.microsoft.com/en-us/library/ms143393.aspx

MaswoodKSA
 25 pts.