Dev GuideAPI Reference
Dev GuideAPI ReferenceUser GuideGitHubNuGetDev CommunitySubmit a ticketLog In
GitHubNuGetDev CommunitySubmit a ticket

Add custom database scripts

Describes how to add custom database scripts to Commerce (SaaS).

Commerce (SaaS) uses database scripts internally to alter the state of the database when necessary, such as when a new feature is released or a bug must be fixed. As an added feature, custom database scripts can also be used within your own Commerce (SaaS) solution.

Custom database scripts are executed during application startup and are only executed once for the entire life of the application. Before execution, these scripts are gathered and sorted alphabetically in ascending order (A-Z). This is the order in which they will be executed. After execution, Commerce (SaaS) will note which scripts were executed so they are not executed another time.

As a best practice, the naming of the database scripts should follow a convention to ensure execution in the proper order. Internally, Optimizely uses the following format for naming database scripts.

{date_of_script_creation}.{sequential_order}.{script_name}.sql

The {date_of_script_creation} should follow the format YYYY.MM.DD. The {sequential_order} is a two-digit number starting at "01". This number solves the ordering problem when multiple scripts were created on the same date.

📘

Prerequisites

  • ISC solution installed
  • Custom database script created
  1. Open the Configured solution in Visual Studio.
  2. Create a DatabaseScripts directory within your Extensions project.
  3. Add the custom database script to that directory and include it in the project as an Embedded Resource. This lets Commerce (SaaS) read and execute the script during application startup. Additionally, this gives the benefit of being able to deploy and execute these scripts in other environments, such as a sandbox or production.
  4. Build the solution. The database scripts in this directory should be executed on the next application startup.