Skip to main content

Create Data Alias liquibase.properties files from your server configuration

This script creates liquibase.properties files for data aliases (DATA_ALIAS) based on your server configuration files.

Add the script to your package.json​

If your project does not already define the serverconfig2LiquibaseProperties4Data script, add it under scripts:

package.json
"scripts": {
   "Convert serverconfig.xml to Liquibase Properties for DATA_ALIAS": "serverconfig2LiquibaseProperties4Data"
}
note

The script name you define in scripts is arbitrary. Use a name that fits your project conventions.

Execute the script​

When you run the script:

  1. A terminal opens.
  2. You are prompted to select the serverconfig from which the tool can access the ASYS_ALIASCONFIG table of the target database.
  3. Ensure you have a working connection to the target database.
  4. Follow the prompts in the terminal; they will guide you through the process of creating the liquibase.properties file.

Test the created files​

After execution, you should see a new liquibase.properties file in the data/liquibase folder, named after your data alias.

Validate the configuration via the Liquibase extension:

  1. Open the Command Palette: Ctrl + Shift + P.
  2. Run Liquibase: Validate....
  3. If there are issues, run Liquibase: Edit existing Liquibase Configuration to adjust the configuration.

Known issues​

serverconfig2LiquibaseProperties4Data works only with lowercase system tables​

Database systems differ in how they handle identifier case sensitivity.
Our SSP systems use lowercase table names, and this script currently focuses on that scenario.

If your database uses uppercase, camelCase, PascalCase, or any other casing for system tables, the script might not work correctly.
In that case, you need to create the respective liquibase.properties files manually using the editor provided by the Liquibase extension for VS Code.