Copying a database into a Cloud Platform CD environment¶

Selecting the source database¶

To select a source database for database syncing:

1. Sign in to the Cloud Platform user interface with an account that has the Execute pipelines permission.

2. Select the application you want to use.

3. In the left menu, click Pipelines.

4. Select More Links > View Application Info.

   

5. In the DB Sync source environment, section, select the environment to copy the database from, and your selection will be saved.

   

Adding deployment steps to your YAML file¶

After selecting a source database for syncing and adding a cde-databases key to your YAML file, add a post-deploy step to your events key as displayed in the following example, replacing db1 and db2 with databases listed as parameters in the cde-databases key:

version: 1.2.0

cde-databases:
  - db1
  - db2

events:

  post-deploy:
    steps:
      # Deploy the build artifact to an on-demand environment,
      # and sync the specified databases.
      - deploy:
          script:
            - pipelines-deploy
            - pipelines-sync-dbs db1 db2

In the previous example, the pipelines-deploy command creates the environment and deploys the build result. The pipelines-sync-dbs command syncs the databases provided as parameters, provided they are also listed as parameters in the cde-databases key.