INTRODUCTION

I’ve got an ugprade project from SharePoint Portal Server 2003 (SPS 2003) to SharePoint 2010. Looking at the articles on the Internet it seems that you can’t upgrade from SPS 2003 straight to 2010. You have to upgrade to 2007 first then 2010.

I decided to use the content database backup/restore/detach/attach approach.

When I tried to restore SPS 2003 content DB to MOSS 2007 I get the following error:

==

error: pre-upgrade scan tool has not yet been run on this database SPContentDatabase

==

After looking around in Google I came accross the following article:

http://blogs.msdn.com/b/joelo/archive/2007/05/01/your-friend-prescan-what-it-does-part-2.aspx

I haven’t run PRESCAN.EXE because the client has not had any TEST environment hence they wouldn’t want to take the risk of running PRESCAN.EXE.

The PRESCAN tool somehow updates the BitFlags column in Sites table to 262144.

SOLUTION

WARNING: Microsoft does NOT support updating records in SP database directly. Therefore do this at your own risk. For me it’s working very well and the method I suggested below works if you haven’t run PRESCAN.EXE.

It is highly recommended however that you run the PRESCAN tool first so you don’t have to fiddle around with my recommended solution below!

Run the following SQL statement:

UPDATE Sites SET BitFlags = 262144

That’s it!

Tommy