EPiServer database version list

Just as the EPiServer CMS version numbers are a bit tough to remember, the corresponding database versions are even worse.

Typically you don’t really need to bother, since this stuff is taken care of by the Deployment Center. But if something goes wrong you may need to apply database upgrade scripts by hand, and then you really need to know the exact numbers.

• CMS 6 R2: 6103
• CMS 6.0: 6004
• CMS 5 R2 SP2: 5205
• CMS 5 R2 SP1: 5202
• CMS 5 R2: 5200
• CMS 5 R1 SP3: 5102

If you are unsure of your current version, there is a stored procedure called sp_DatabaseVersion which will return the correct version.

If you need the upgrade scripts, they can be found here (or corresponding location):
C:\Program Files (x86)\EPiServer\CMS\[version]\Upgrade\Database\sql.

The folder contains a lot of scripts which need to be run in correct order. The naming can seem a bit scary at first (e.g. 0005_0001_0422_0004to0005_0001_0422_0122.sql), but if you look closely they actually match the assembly versions.

Example:

The first file upgrades from 5.1.422.4 (just skip the zeros) to 5.1.422.122, where 5.1.422.4 is the assembly version of CMS 5 R1. The scripts continue in order all the way up to the latest version of CMS 6.