Hi, we have a MOSS 64bit running on a 64bit OS windows 2008 and the backend database is a 32bit server windows 2003 running SQL server 2008 32bit. Now i would like to shift the databases of Sharepoint from 32bit server to 64bit (from 32bit sql to 64bit sql) What should be done here?MVI - Most Valuable Indian

Hi Sheldon, There is a very good TechNet article to migrate database - please follow this and let us know if you have any questions. Thank you!BlueSky2010

In addition that, there are several resources here dealing specifically with Migration. http://technet.microsoft.com/en-us/library/dd622865(office.12).aspx Connect with Me! Fabian G. Williams | Twitter @FabianWilliams | Blog http://www.sharepointfabian.com | Email: fabian@adotob.com

There are 2 options Move the database to a host server that has the same name. Move the database to a host server that has a different name Which one should i choose?MVI - Most Valuable Indian

It should be move database to a host server with the same name. Since this is what you SharePoint config database would have unless you plan to move just the content databases to another 64 bit server. I would also recommened using a SQL server alias when you do this move since that would make the server name redundant for this very reason as aliases can then be pointed to any server.

Run Preupgrade scan to check readiness , First of all Migrate MOSS to 64 bit, Then Migrate Sharepoint 2007 to Sharepoint 2010 , Certain customizations need to rework, features, workflow custom code need to install again in 2010.