You can either specify a SQL file in your workspace (using Administration > Custom Actions), or have the SQL files bundled and published to your binary repository (recommended).

The four available phases you can use combined with RCU:

• rcu-create-pre
• rcu-create-post
• rcu-drop-pre
• rcu-drop-post

Prerequisites

Preparing the SQL Files

Workspace

1. Go to Administration > Custom Actions
2. Create a sql script in the workspace
3. 

Binary Repository

1. Create a ZIP file and publish to your binary repository
2. Ensure that you have a MyST Studio Continuous Delivery Profile defined that is pointing to your binary repository

Configuring MyST Studio

Workspace

If you use the Workspace method:

1. Define the SQL deployment definition in the global properties section

   core.deployment[Stock-rcu-create-post].param[data-source-username]=sys
   core.deployment[Stock-rcu-create-post].param[data-source-sys-role]=sysdba
   core.deployment[Stock-rcu-create-post].param[data-source-password]=${core.product[rcu].param[db-password]}
   core.deployment[Stock-rcu-create-post].param[data-source-url]=${core.product[rcu].param[db-url]}
   core.deployment[Stock-rcu-create-post].param[execute]=resources/custom/sql/myst-rcu-post.sql
   core.deployment[Stock-rcu-create-post].param[fail-on-error]=false
   core.deployment[Stock-rcu-create-post].param[phase]=rcu-create-post
   core.deployment[Stock-rcu-create-post].present=true
   core.deployment[Stock-rcu-create-post].type=sql
   

Binary Repository

If you use the Binary Repository method:

1. Define the SQL deployment definition in the global properties section

core.deployment[Stock-rcu-create-post].artifact.repository.artifactId=myst-rcu-post
core.deployment[Stock-rcu-create-post].artifact.repository.groupId=com.rubiconred.myst
core.deployment[Stock-rcu-create-post].artifact.repository.type=zip
core.deployment[Stock-rcu-create-post].artifact.repository.version=1.0
core.deployment[Stock-rcu-create-post].param[data-source-username]=sys
core.deployment[Stock-rcu-create-post].param[data-source-sys-role]=sysdba
core.deployment[Stock-rcu-create-post].param[data-source-password]=${core.product[rcu].param[db-password]}
core.deployment[Stock-rcu-create-post].param[data-source-url]=${core.product[rcu].param[db-url]}
core.deployment[Stock-rcu-create-post].param[execute]=(EMBEDDED)/rcu_create_post.sql
core.deployment[Stock-rcu-create-post].param[fail-on-error]=false
core.deployment[Stock-rcu-create-post].param[phase]=rcu-create-post
core.deployment[Stock-rcu-create-pre].present=true
core.deployment[Stock-rcu-create-post].type=sql

Provisioning

When you run a provision (or RCU) action and depending on which phase you are using MyST will also execute the SQL.