Mink Machine

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 correct 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:
C:\Program Files (x86)\EPiServer\CMS\[version]\Upgrade\Database\sql (or similar).

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:

0005_0001_0422_0004to0005_0001_0422_0122.sql 0005_0001_0422_0122to0005_0001_0422_0252.sql … 0006_0001_0237_0000to0006_0001_0287_0000.sql 0006_0001_0288_0000to0006_0001_0316_0000.sql

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.

Related posts

Comments

No comments yet.

Leave a reply

Your email address will not be published. Required fields are marked *

Featured stories

New Years Eve in Sydney

New Years Eve in Sydney

"Opera House is seen in front of the massive fireworks in the harbor area, celebrating the 75th anniversary of the Harbour Bridge."
Reliving history in Washington D.C.

Reliving history in Washington D.C.

"As I entered the heavily guarded Rotunda in the center, some of the most famous documents in the world laid before me."
Sessions in Seville

Sessions in Seville

"I end my journey in front of the tomb of Columbus, located inside the world’s largest Gothic cathedral."
Chilling in Chile

Chilling in Chile

"My weary feet has reached Valparaiso. After almost a month of traveling across the South American continent I realize that this is as far south as I will come, due to weather conditions."
Greetings from Moldova

Greetings from Moldova

"But Chisinau is an unexpected gem in the wilderness. Even though Moldova is one of the poorest countries in Europe, the capital has its fair share of impressive buildings and post-Soviet architecture."
I still love you, New York

I still love you, New York

"Now I’m back and our roles are somewhat reversed. Like River Song and the Doctor, we meet again under different circumstances."

Instagram

Seville
Venice
Fever Ray
Rome
Basel
Kuala Lumpur