Demo database environment for the CYBERTEC Migrator

Installation • Using the demo environment • Contact

This repository facilitates the setup of a database environment that may be used in a test-run of the CYBERTEC Migrator, a user-friendly tool that helps you to organize and efficiently migrate Oracle databases to PostgreSQL.

Use the demo-env script to

• start a PostgreSQL instance with a demo database
• start an Oracle Express Edition instance containing the HR demo schema
• stop both database instances

Both database management systems are provided as container images. The provided configuration does not use volume containers, which means changes to the databases are not persisted when restarting the instances.

The following table shows the connection strings, user and passwords provided by the default settings

Requirement: an installed and running CYBERTEC Migrator (>= 3.7.0) since the demo databases join into the existing Docker network created by the Migrator.

On the host where the Migrator is installed:

1. Clone this git repository
2. Change directory into cloned repository

git clone https://github.com/cybertec-postgresql/cybertec_migrator_demo
cd cybertec_migrator_demo

The CYBERTEC Migrator has to be up and running before starting a demo database.

• Start the PostgreSQL instance with the demo database

  ./demo-env up demo_db

• Start the Oracle instance with the HR schema

  # Starting an Oracle instance takes some time.
  # You can connect to the database when 'docker ps' shows a 'healthy' status.
  ./demo-env up oracle

• The following command will stop all running instances

  ./demo-env down

The EXTERNAL_DEMO_POSTGRES_PORT and EXTERNAL_DEMO_ORACLE_PORT variables in the .env file (generated by executing the ./demo-env script) control the choice of port on which the demo databases are served.

• Sales