Migrated to MOSS 2007 SP1 or EPM 2007 SP1 .. checking your database schema version

  • Article

Updated with Infrastructure update Information (July 15th, 2008)

You have decided to migrate to the SP1 of EPM 2007 and/or MOSS 2007.

During the upgrade (done by the configuration wizard), the databases are upgraded also.

If you want to check the schema version of the databases, you can use this query in any of your farm database:

SELECT * FROM Versions

The very last version that maps to the GUID {00000000-0000-0000-0000-000000000000} with the highest ID should equal the current version of the product

Here is a table showing the different database versions

(Thanks Brian https://blogs.msdn.com/brismith)

Updated with Infrastructure Update Information

WSS:https://support.microsoft.com/kb/95165

Office Server https://support.microsoft.com/kb/951297

Database RTM SP1 Infrastructure Update July 15th, 2008
SharePoint Config DB

12.0.0.4518

3.0.7.0

3.0.10.0

12.0.0.4518

12.0.0.6219

3.0.7.0

3.0.10.0

12.0.0.4518

12.0.0.6219

12.0.0.6318

3.0.7.0

3.0.10.0
SharedServices DB

12.0.4518.1016

12.0.1.0

12.0.4518.1016

12.0.6219.1000

12.0.1.0

12.0.4518.1016

12.0.6219.1000

12.0.6318.5000

12.0.38.0

12.1.503.0
WSS Content DBs

12.0.0.4518

3.0.149.0

12.0.0.4518

12.0.0.6219

3.1.3.0

12.0.0.4518

12.0.0.6219

12.0.0.6318

3.1.5.0
Archive 12.0.57.0

12.0.4518.1016

12.0.6218.1000

12.1.104.0

12.0.4518.1016

12.0.6218.1000

12.0.6318.5000

12.1.153.0
Draft 12.0.58.0

12.0.4518.1016

12.0.6218.1000

12.1.104.0

12.0.4518.1016

12.0.6218.1000

12.0.6318.5000

12.1.153.0
Published 12.0.64.0

12.0.4518.1016

12.0.6218.1000

12.1.106.0

12.0.4518.1016

12.0.6218.1000

12.0.6318.5000

12.1.162.0
Reporting 12.0.52.0

12.0.4518.1016

12.0.6218.1000

12.1.102.0

12.0.4518.1016

12.0.6218.1000

12.0.6318.5000

12.1.151.0

If you attach a RTM content database or if you provision a new project server site with four RTM databases on a SP1 installation, the RTM databases are upgraded to SP1 during the provisioning.

You may have less lines in your databases, if they were created after applying the SP1 a Rollup or the infrastructure update.

Comments

  • Anonymous
    January 10, 2008
    You have decided to migrate to SP1 of EPM 2007 and/or MOSS 2007. During the upgrade (done by the configuration

  • Anonymous
    February 19, 2008
    I could reproduce the effect on 3 different installations. Upgrading to SP1. Provision a new PWA site. The publish database is still telling me version 12.0.4518.1016. Deleting the newly provisioned site, without deleting the DB's. Provision a new PWA site with same database settings. The publish database is telling me version 12.0.6218.1000. Does this mean that the first provisioning was RTM, or is just the version number wrong? Grtz, Kurt

  • Anonymous
    February 19, 2008
    Hi Kurt, This seems unusual, you are right. I will check on my side. Steven

  • Anonymous
    April 28, 2008
    I made a manual upgrade to the database schema running part of the SP1 setup, since I restored a database backup made with the RTM version. My blog entry describes the procedure. Regards, Marcelo Azuma

  • Anonymous
    April 28, 2008
    The comment has been removed

  • Anonymous
    June 11, 2008
    The comment has been removed

  • Anonymous
    August 27, 2008
    Para cuando sea necesario... Service Pack/Hotfix Version WSS V3.0 MOSS 2007 Infrastructure Update ( KB951695

  • Anonymous
    January 21, 2009
      This table updates this post: http://blogs.msdn.com/shaden/archive/2008/01/10/migrated-to-sp1-checking-your-database-schema-version.aspx