03/18/2015 08:11 PM Database migrations
Virto Commerce

Database migrations

Updated:

Introduction

Most of the VirtoCommerce store data is stored in a database (DB). As our platform evolves, the DB structure might change and former DB (that was created in previous versions) might get obsolete. Such DB's need to migrate. We'll publish migration scripts and list them here.

Migrations

From version 1.6 to 1.7:

From version 1.7 to 1.8:

  • Execute this SQL script on AppConfig (in case you have separate) database.
  • Execute this SQL script on Security (in case you have separate) database.

From version 1.8 to 1.9:

From version 1.9 to 1.10:

From version 1.10 to 1.11:

From version 1.11 to 1.12

  • Execute this SQL script on Catalogs (in case you have separate) database.

From version 1.12 to 1.13

  • Execute first this SQL script, then this script and this script on Orders (in case you have separate) database.
  • Execute this SQL script  on Catalogs (in case you have separate) database.
  • Execute this script to migrate to asp.net identity security and this script to convert AccountId to string on Security