Wednesday, July 31, 2013

SharePoint Pre-Upgrade Checker Fails on database diagram!!

This is the kind of stuff that drives you crazy.  SQL Server has supported a simple tool to
diagram databases for years.  Now there are better tools out there but I like the fact that it sits right inside SQL Server Management Studio and helps me visualize my data as I design.

NOTE:  Don't even try to do this on a content database as the preupgrade check will see the
extra tables and sprocs this creates as a schema change and flag your MOSS 2007 DB as not
worthy of an upgrade to 2010.

Thanks to http://selfinflictedsharepoint.blogspot.com/2010/06/sharepoint-pre-upgrade-checker-fails.html


Here are the details:

To correct the error, and allow the Pre-Upgrade Checker to run successfully, we
performed the following:
 We backed up the SharePoint_Content Database before making any changes.  This
  is critical in case something goes wrong.
   I deleted the dbo.sysdiagrams table from Content_Database -> Tables -> System
  Tables
   I deleted the following stored procedures from Content_Database –>
  Programmability -> Stored Procedures -> System Stored Procedures
   sp_upgraddiagrams
   sp_helpdiagrams
   sp_helpdiagramdefinition
   sp_creatediagram
   sp_renamediagram
   sp_alterdiagram
   sp_dropdiagram
   The screenshot  below illustrates these a little better.

No comments:

Post a Comment