Best approach? Migrating sites from WSS 3.0 to 64 bit MOSS 2007 and SQL2008
I have met lots of challenges with building the new 64 bit MOSS, and now I am nervous about the next step!
Anyone have suggestions for the BEST approach (least problems?)
I did a SQL backup and we have 32 Gb of data to move, then need to fix up the URLs for the users.
possible problems:
- SQL2005 to SQL2008
- 32bit to 64 bit
- WSS to MOSS (not a problem in itself I believe)
Ruth, UK
Answers
Hi Ruth,
Migration from 32 bit machine to 64 bit machine and from SQL 2005 to 2008 is not a problem for SharePoint. From my opinion, I recommend you deploy a new MOSS farm and use database migration method. For the detailed steps, you can refer to Technet document below:
Chapter overview: Deploy a new farm, then migrate databases (Office SharePoint Server)
http://technet.microsoft.com/en-us/library/cc263186.aspx
Follow the instructions in this document will help achieve your goal successfully. Don’t miss or skip any steps especially the post-upgrad steps to ensure all the sites can work without problem.
http://technet.microsoft.com/en-us/library/cc263327.aspx
Hope this helps
Lu Zou
TechNet Subscriber Support in forum
If you have any feedback on our support, please contact tngfb@microsoft.com
- Marked As Answer byMike Walsh MVPMVP, ModeratorWednesday, November 04, 2009 4:47 AM
All Replies
Hi Ruth,
Migration from 32 bit machine to 64 bit machine and from SQL 2005 to 2008 is not a problem for SharePoint. From my opinion, I recommend you deploy a new MOSS farm and use database migration method. For the detailed steps, you can refer to Technet document below:
Chapter overview: Deploy a new farm, then migrate databases (Office SharePoint Server)
http://technet.microsoft.com/en-us/library/cc263186.aspx
Follow the instructions in this document will help achieve your goal successfully. Don’t miss or skip any steps especially the post-upgrad steps to ensure all the sites can work without problem.
http://technet.microsoft.com/en-us/library/cc263327.aspx
Hope this helps
Lu Zou
TechNet Subscriber Support in forum
If you have any feedback on our support, please contact tngfb@microsoft.com
- Marked As Answer byMike Walsh MVPMVP, ModeratorWednesday, November 04, 2009 4:47 AM
- Advice to anyone doing the database migration route.
Ensure your MOSS server has both the WSS and MOSS service packs applied.
Check the build number in Central Admin Operations - should now match the list from Microsoft (a start point here: http://www.synergyonline.com/blog/blog-moss/Lists/Posts/Post.aspx?List=fcb287b5%2D7a1a%2D4206%2Da04f%2D2a97805e4a25&ID=104)
My MOSS server looked OK, behaved OK as a prototype, but on checking the server version / build number, did not actually recognise the SP2. Check the build number in Central Admin Operations, click on your server
My process:
Remove MOSS SP2
reboot
Add WSS SP2
Add MOSS SP2
Run the Config and Technologies wizard
reboot
Then my database could be restored sucessfully.
Ruth, UK
