Streamlined Oracle to PostgreSQL migration

---

Getting Started • Running the Migrator • Contact

CYBERTEC Migrator is a streamlined and user-friendly tool that helps you to organize and efficiently migrate multiple Oracle databases to PostgreSQL. In addition to migrating your data professionally and securely with minimum effort, CYBERTEC Migrator allows you to visually monitor and track the whole process at any time.

Do you want to know if the Migrator can migrate your Oracle database to PostgreSQL? Then get the Migrator Standard Edition, a free version of the CYBERTEC Migrator, follow the offline instructions provided in Getting Started section, and try it out.

The blog article Meet the CYBERTEC Migrator provides a good introduction on how to migrate Oracle's HR demo schema to PostgreSQL. Alternatively, you may want to watch the complementary CYBERTEC Migrator YouTube playlist.

Product Demo

---

For detailed information see the list of supported migration features for Oracle.

Table of Contents

1. What's New
2. Getting Started
3. Running the Migrator
4. Getting Help
5. Contact
6. License

What's New

For older releases see Release Notes.

v3.10.1 - 2022-09-08

Resolved Bugs

• Creating a migration for Oracle 11 and below fails on reading out sequences due to a non-existent table
• The lower_bound of range subpartitions is not determined correctly during migration creation
• Running the Structure stage with REFERENCE partitions results in a non-descriptive error
• Regression in v3.10.0 causing the data of individual partitions to not be migrated correctly
• Code editors mark their complete content as erroneous instead of only the faulty section
• Revert style changes in the search and replace panel

v3.10.0 - 2022-08-31

Features

• Improve Search Panel:
  • Search package specifications and bodies
  • Consolidate DBO type filter into a single input

    

  • Select multiple search results to replace at once
    • Shift-Click to add multiple rows
    • Ctrl-Click to add/remove a single row

    

  • Improve keyboard navigation when using <Tab>
• Show information for Oracle Queues in the Sidebar

  

Resolved Bugs

• DBO creation fails due to global lock_timeout setting on target database
• Running ps inside the core container during the data stage reveals the database passwords
• Abort of data stage may sometimes hang indefinitely

Getting Started

Requirements

CYBERTEC Migrator is distributed as a set of container images that are managed with the help of Docker Compose.

• docker
• docker-compose (>= 1.27.0)
• git (>= 2.20.1)
• bash (>= 4.0)

Migrator Installation

The CYBERTEC Migrator images can be obtained via two channels

• Online installation via container registry
• From an offline installation package for environments in which networking restrictions are imposed

💡	The Migrator Standard Edition is only available as offline installation package

Online installation

You need an account on the Docker Hub container image registry.

Please get in touch with us if your account has not been granted access to the respective images. Make sure you are logged in the Docker Hub registry with the correct user.

cat ~/password.txt | docker login --username <username> --password-stdin

1. Clone this git repository
2. Change working directory to the previously cloned repository
3. Generate default configuration
4. Download and load container images
5. Start the Migrator

➜ git clone https://github.com/cybertec-postgresql/cybertec_migrator
➜ cd cybertec_migrator
➜ ./migrator configure
[OK] Generated environment file
[INFO] Run './migrator install' to complete setup
➜ ./migrator install
[INFO] Pulling v3.10.0
Pulling core_db ... done
Pulling core    ... done
Pulling web_gui ... done
[OK] Pulled v3.10.0
[INFO] Upgraded to v3.10.0
[INFO] Run './migrator up' to switch to new version
[WARN] Switching will abort running migrations
➜ ./migrator up
Creating network "cybertec_migrator-network" with the default driver
Creating cybertec_migrator_core_db_1 ... done
Creating cybertec_migrator_core_1    ... done
Creating cybertec_migrator_web_gui_1 ... done
[OK] Started on 'http://localhost'

Offline installation

Get your Migrator offline installation package. You can get the Migrator Standard Edition here for free.
For the Professional or Enterprise Edition get in touch with us to request download credentials.

1. Extract the provided archive file
2. Change working directory to newly created directory
3. Generate default configuration
4. Import container images from archive
5. Start the Migrator

➜ tar xf cybertec_migrator-v3.10.0-standard.tar.gz
➜ cd cybertec_migrator
➜ ./migrator configure
[OK] Generated environment file
[INFO] Run './migrator install' to complete setup
➜ ./migrator install --archive ../cybertec_migrator-v3.10.0-standard.tar.gz
[INFO] Extracting upgrade information
Loaded image: cybertecpostgresql/cybertec_migrator-core:v3.10.0-standard
Loaded image: cybertecpostgresql/cybertec_migrator-web_gui:v3.10.0-standard
Loaded image: postgres:13-alpine
[INFO] Extracted upgrade information
[INFO] Upgraded to v3.10.0-standard
[INFO] Run './migrator up' to switch to new version
[WARN] Switching will abort running migrations
➜ ./migrator up
Creating network "cybertec_migrator-network" with the default driver
Creating cybertec_migrator_core_db_1 ... done
Creating cybertec_migrator_core_1    ... done
Creating cybertec_migrator_web_gui_1 ... done
[OK] Started on 'http://localhost'

Running the Migrator

Use your web browser to access the Migrator on the URL shown in the terminal with migrator up. In our example it would be http://localhost.

The configuration provided with this repository starts the CYBERTEC Migrator over HTTP. The EXTERNAL_HTTP_PORT variable in the .env file (generated by ./migrator configure) controls the choice of port on which the Migrator is served.

The configuration is not meant to be used in production environment. Adapt the NGINX configuration in docker/templates/default.conf.template to your needs to run the service on HTTPS with proper credentials.

If you don't have access to an Oracle or PostgreSQL database to test the Migrator, use our Migrator demo database environment.

Upgrades

⚠️	Running migrations will be interrupted by applying upgrades

• Online upgrade

  1. Update release information
  2. Upgrade to newest version
  3. Apply upgrade
  
  

  ./migrator update
  ./migrator upgrade
  ./migrator up

• Offline upgrade

  💡	Installation archives also serve for upgrading the Migrator

  1. Update release information
  2. Upgrade to version bundled in archive
  3. Apply upgrade
  
  

  ./migrator update --archive cybertec_migrator-vX.Y.Z.tar.gz
  ./migrator upgrade --archive cybertec_migrator-vX.Y.Z.tar.gz
  ./migrator up

Getting Help

Raising an issue is encouraged. We have templates to report bugs, requesting a new feature or for general questions.

Contact

• Sales

License

The content of this repository is under the MIT License in case you have to adapt the deployment to your needs. The CYBERTEC Migrator delivered in the container images uses a proprietary license with an EULA.