Manually upgrading the database from EPiServer Commerce R2 SP1 to EPiServer Commerce R2 SP2

Posted on May 9, 2012 by Frederik Vig in EPiServer

Here’s an overview over the SQL scripts you need to execute to manually upgrade your sites commerce database from EPiServer Commerce R2 SP1 to EPiServer Commerce R2 SP2.

  1. C:\Program Files (x86)\EPiServer\CMS\6.1.379.0\Install\Modules\EPiServer Commerce 1.1.2.62\Setup\cms_db_upgrade.sql
  2. C:\Program Files (x86)\EPiServer\CMS\6.1.379.0\Install\Modules\EPiServer Commerce 1.1.2.62\MediachaseECF\Data\DeploymentPackage\SqlScripts\Update\ecf_db_ApplicationSystem_update.sql
  3. C:\Program Files (x86)\EPiServer\CMS\6.1.379.0\Install\Modules\EPiServer Commerce 1.1.2.62\MediachaseECF\Data\DeploymentPackage\SqlScripts\Update\ecf_db_BusinessFoundation_update.sql
  4. C:\Program Files (x86)\EPiServer\CMS\6.1.379.0\Install\Modules\EPiServer Commerce 1.1.2.62\MediachaseECF\Data\DeploymentPackage\SqlScripts\Update\ecf_db_CatalogSystem_update.sql
  5. C:\Program Files (x86)\EPiServer\CMS\6.1.379.0\Install\Modules\EPiServer Commerce 1.1.2.62\MediachaseECF\Data\DeploymentPackage\SqlScripts\Update\ecf_db_MarketingSystem_update.sql
  6. C:\Program Files (x86)\EPiServer\CMS\6.1.379.0\Install\Modules\EPiServer Commerce 1.1.2.62\MediachaseECF\Data\DeploymentPackage\SqlScripts\Update\ecf_db_MetaDataSystem_update.sql
  7. C:\Program Files (x86)\EPiServer\CMS\6.1.379.0\Install\Modules\EPiServer Commerce 1.1.2.62\MediachaseECF\Data\DeploymentPackage\SqlScripts\Update\ecf_db_OrderSystem_update.sql
  8. C:\Program Files (x86)\EPiServer\CMS\6.1.379.0\Install\Modules\EPiServer Commerce 1.1.2.62\MediachaseECF\Data\DeploymentPackage\SqlScripts\Update\ecf_db_Reporting_update.sql
  9. C:\Program Files (x86)\EPiServer\CMS\6.1.379.0\Install\Modules\EPiServer Commerce 1.1.2.62\MediachaseECF\Data\DeploymentPackage\SqlScripts\Update\ecf_db_SecuritySystem_update.sql
  10. C:\Program Files (x86)\EPiServer\CMS\6.1.379.0\Install\Modules\EPiServer Commerce 1.1.2.62\MediachaseECF\Data\DeploymentPackage\SqlScripts\Update\ecf_db_Users_upgrade.sql
  11. C:\Program Files (x86)\EPiServer\CMS\6.1.379.0\Install\Modules\EPiServer Commerce 1.1.2.62\Setup\ecf_products_ProductsQuery.sql

Here’s the whole tech-note: Upgrading EPiServer Commerce from version 1 R2 SP1 to 1 R2 SP2.

What I usually do is upgrade locally, check everything into source control, deploy to the different dev/test environments, download and install the new version from EPiServer World, and then manually upgrade the databases. This means I only have to step through the upgrade wizard once. I can even automatically execute the upgrade scripts in my deployment process so I don’t have to do anything manually.

Related Posts: