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


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 http://blogs.msdn.com/brismith)

Updated with Infrastructure Update Information

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

Office Server http://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 (8)

  1. You have decided to migrate to SP1 of EPM 2007 and/or MOSS 2007. During the upgrade (done by the configuration

  2. kurt.verhaegen says:

    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

  3. stevenh-msft says:

    Hi Kurt,

    This seems unusual, you are right.

    I will check on my side.

    Steven

  4. 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

  5. stevenh-msft says:

    I has been a while, but I have checked a few things on my side..

    If your database schema is not upgraded, this means that the SharePoint And Configuration Wizard did not run successfully; Check the upgrade.log file.

    To run it manually again, use the command line version with the following parameters:

    psconfig -cmd upgrade -inplace b2b -wait -force

    Steven

  6. rcrawford says:

    New Hotfix is now out…

    Project Server 2007 hotfix package: April 25, 2008

    Published database version is  12.1.157.0

    Regards

    Richard

  7. Para cuando sea necesario… Service Pack/Hotfix Version WSS V3.0 MOSS 2007 Infrastructure Update ( KB951695