TechNet
Products
IT Resources
Downloads
Training
Support
Products
Windows
Windows Server
System Center
Microsoft Edge
Office
Office 365
Exchange Server
SQL Server
SharePoint Products
Skype for Business
See all products »
Resources
Channel 9 Video
Evaluation Center
Learning Resources
Microsoft Tech Companion App
Microsoft Technical Communities
Microsoft Virtual Academy
Script Center
Server and Tools Blogs
TechNet Blogs
TechNet Flash Newsletter
TechNet Gallery
TechNet Library
TechNet Magazine
TechNet Wiki
Windows Sysinternals
Virtual Labs
Solutions
Networking
Cloud and Datacenter
Security
Virtualization
Updates
Service Packs
Security Bulletins
Windows Update
Trials
Windows Server 2016
System Center 2016
Windows 10 Enterprise
SQL Server 2016
See all trials »
Related Sites
Microsoft Download Center
Microsoft Evaluation Center
Drivers
Windows Sysinternals
TechNet Gallery
Training
Expert-led, virtual classes
Training Catalog
Class Locator
Microsoft Virtual Academy
Free Windows Server 2012 courses
Free Windows 8 courses
SQL Server training
Microsoft Official Courses On-Demand
Certifications
Certification overview
Special offers
MCSE Cloud Platform and Infrastructure
MCSE: Mobility
MCSE: Data Management and Analytics
MCSE Productivity
Other resources
Microsoft Events
Exam Replay
Born To Learn blog
Find technical communities in your area
Azure training
Official Practice Tests
Support options
For business
For developers
For IT professionals
For technical support
Support offerings
More support
Microsoft Premier Online
TechNet Forums
MSDN Forums
Security Bulletins & Advisories
Not an IT pro?
Microsoft Customer Support
Microsoft Community Forums
Sign in
Home
Library
Wiki
Learn
Gallery
Downloads
Support
Forums
Blogs
Resources For IT Professionals
United States (English)
Россия (Pусский)
中国(简体中文)
Brasil (Português)
Skip to locale bar
Post an article
Translate this page
Powered by
Microsoft® Translator
Wikis - Page Details
First published by
Prasad_Joshi1
When:
23 Apr 2013 2:33 AM
Last revision by
Gokan Ozcifci
(eMicrosoft Partne)
When:
16 Aug 2013 6:07 AM
Revisions:
3
Comments:
0
Options
Subscribe to Article (RSS)
Share this
Can You Improve This Article?
Positively!
Click Sign In to add the tip, solution, correction or comment that will help other users.
Report inappropriate content using
these instructions
.
Wiki
>
TechNet Articles
>
SharePoint 2010: Database Cleanup during MOSS to SharePoint 2010 Upgrade
SharePoint 2010: Database Cleanup during MOSS to SharePoint 2010 Upgrade
Article
History
SharePoint 2010: Database Cleanup during MOSS to SharePoint 2010 Upgrade
As SharePoint 2010 is a strong platform most of the old applications hosted on MOSS 2007 are getting migrated to SharePoint 2010 (Sooner it will be 2013).
Migration itself requires many considerations which includes but not limited to following items
Size of migration. (Content database and Custom databse if exists)
Migration approach (Tools based to Attch upgrade method)
Customizations done on old platform i.e MOSS 2007
Any third party tool used for customizations in old platform Ex Workflow products, Grids like Telerik etc
Each of above topics can be explained in deatils but we are discussing about the attach upgrade menthod here and issue which one can face after such upgrade.
If one takes the approach of content databse attach upgrade method for migration, its required that customizations developed on old plaform should be rebuilt using SharePoint 2010 API Ex: Webparts, Event Receiver etc. If in some cases we cant get the old WSP's or solutions for rebuilding then the features can throw error after upgrade.
This doesnt break the functionality of the iste in most of the cases where features missing are not part of core application functionality but the farm can be unstable due to such missing features. An error can be seen in 'Upgrade & Migration' link in Central Admin for such databases like '
Database is up to date, but some sites are not completely upgraded
'and the upgrade status will be failed.
Whats Next:
An excellent utility is provided at codeplex for cleaning these unwanted\missing features. It an be downloaded from
here.
Once the databse is clean with this utiltiy we can run the upgrade command again to complete the upgrade.
the powershell command for the same is
Upgrade-SPContentDatabase -Identity 'Conetnt Database name here'
To summarize the steps for upgrade,
Get database backup from MOSS 2007
Before attaching the database clear all the unwanted solutions from solution store (This can be done on dev box).
Attach the database backup to new environment. Note while attaching the database if has a site collection at root ('/'). it creates issue while upgrade. Hence the other database which has this root site collection needs to be removed till this upgrade.
Or we can upgrade the database in test web application created temporarily in development box.
Run the utility (Feature admin) on the database for all the site collection in restored database.
Delete the other site collections completely from this database using powershell except required site collection in case we are just migrating single site collection in shared conetnt database. (Using Remove-SPSIte command)
Upgrade the database using powershell
Take the backup of this new database and then restore it on prod.
Deploy the customizations developed for this site collection
Once done review the databse status again from 'Upgrade & Migration ' it should show 'No action required'. the upgrade is successful.
SharePoint 2007
,
SharePoint 2010
,
Upgrade
[Edit tags]
Leave a Comment
Please add 1 and 8 and type the answer here:
Post
Wiki - Revision Comment List(Revision Comment)
Wikis - Comment List