Skip to content

KieranKaelin/cybertec_migrator

BranchesTags
 
 

Repository files navigation

CYBERTEC Migrator

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.


CYBERTEC Migrator v3 Demonstration
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.

3.14.1 - 2023-01-26

Resolved Bugs

  • Importing a migration archive on Windows causes File must be a .zip archive
  • Switching between procedure editors causes their contents to be overwritten

v3.14.0 - 2023-01-10

Features

  • Live Data stage overview: Determine the migration status of each table at a glance

  • Import migration: Create a new migration using a migration export, as an alternative to cloning

    Note: Only migration exports created with v3.14.0 and later are supported.

  • Log Panel Timezone: Choose a custom timezone for migration log timestamps

  • Sequence Editor: View and edit the details of sequences

  • Rename table columns:

    • Oracle columns named after PostgreSQL system columns (xmin, xmax, etc.) can not be migrated as is and must be renamed

  • Migration Settings:

    • Change migration name and description

    • Configure the interval between each data transfer report

Getting Started

Requirements

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

Migrator Installation

The CYBERTEC Migrator images can be obtained via two channels

💡 The Migrator Standard Edition is only available as an 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. Generate a self-signed TLS/SSL certificate or install a certificate (see FAQ for more details)
  6. 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.13.0
Pulling core_db ... done
Pulling core    ... done
Pulling web_gui ... done
[OK] Pulled v3.13.0
[INFO] Upgraded to v3.13.0
[WARN] Could not find TLS/SSL certificate
[INFO] Run './migrator configure --tls self-signed-cert' to generate a self-signed TLS/SSL certificate
➜ ./migrator configure --tls self-signed-cert
[INFO] Generating self-signed TLS/SSL certificate
Creating cybertec_migrator_web_gui_run ... done
Generating a RSA private key
.+++++
........................+++++
writing new private key to '/etc/nginx/certs/nginx.key'
-----
You are about to be asked to enter information that will be incorporated
into your certificate request.
What you are about to enter is what is called a Distinguished Name or a DN.
There are quite a few fields but you can leave some blank
For some fields there will be a default value,
If you enter '.', the field will be left blank.
-----
Country Name (2 letter code) [AU]:AT
State or Province Name (full name) [Some-State]:Lower Austria
Locality Name (eg, city) []:Wöllersdorf
Organization Name (eg, company) [Internet Widgits Pty Ltd]:CYBERTEC PostgreSQL International GmbH
Organizational Unit Name (eg, section) []:CYBERTEC Solutions
Common Name (e.g. server FQDN or YOUR name) []:
Email Address []:[email protected]
Creating cybertec_migrator_web_gui_run ... done
[OK] Generated self-signed TLS/SSL certificate
[INFO] Run './migrator up' to switch to new version
[WARN] Switching will abort running migrations
➜ ./migrator up
Recreating cybertec_migrator_core_db_1 ... done
Recreating cybertec_migrator_core_1    ... done
Recreating cybertec_migrator_web_gui_1 ... done
[OK] Started on 'https://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. Generate a self-signed TLS/SSL certificate or install a certificate (see FAQ for more details)
  6. Start the Migrator
➜ tar xf cybertec_migrator-v3.13.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.13.0-standard.tar.gz
[INFO] Extracting upgrade information
Loaded image: cybertecpostgresql/cybertec_migrator-core:v3.13.0-standard
Loaded image: cybertecpostgresql/cybertec_migrator-web_gui:v3.13.0-standard
Loaded image: postgres:13-alpine
[INFO] Extracted upgrade information
[INFO] Upgraded to v3.13.0-standard
[WARN] Could not find TLS/SSL certificate
[INFO] Run './migrator configure --tls self-signed-cert' to generate a self-signed TLS/SSL certificate
➜ ./migrator configure --tls self-signed-cert
[INFO] Generating self-signed TLS/SSL certificate
Creating cybertec_migrator_web_gui_run ... done
Generating a RSA private key
.+++++
........................+++++
writing new private key to '/etc/nginx/certs/nginx.key'
-----
You are about to be asked to enter information that will be incorporated
into your certificate request.
What you are about to enter is what is called a Distinguished Name or a DN.
There are quite a few fields but you can leave some blank
For some fields there will be a default value,
If you enter '.', the field will be left blank.
-----
Country Name (2 letter code) [AU]:AT
State or Province Name (full name) [Some-State]:Lower Austria
Locality Name (eg, city) []:Wöllersdorf
Organization Name (eg, company) [Internet Widgits Pty Ltd]:CYBERTEC PostgreSQL International GmbH
Organizational Unit Name (eg, section) []:CYBERTEC Solutions
Common Name (e.g. server FQDN or YOUR name) []:
Email Address []:[email protected]
Creating cybertec_migrator_web_gui_run ... done
[OK] Generated self-signed TLS/SSL certificate
[INFO] Run './migrator up' to switch to new version
[WARN] Switching will abort running migrations
➜ ./migrator up
Recreating cybertec_migrator_core_db_1 ... done
Recreating cybertec_migrator_core_1    ... done
Recreating cybertec_migrator_web_gui_1 ... done
[OK] Started on 'https://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 https://localhost.

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

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

Attention
If you upgrade from a Migrator version previous of 3.11.0 you have to create the TLS/SSL certificate after upgrading to the new version, before restarting the new Migrator.

./migrator update
./migrator upgrade
# Don't forget the create or install a TLS/SSL certificate
./migrator configure --tls self-signed-cert
./migrator up

  • 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

If you have a questions maybe you want to check the Migrator FAQ. If you can't find the answer there you may have more luck in one of the existing questions.

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

Customers of the paid Migrator license may use the Migrator Service Desk.

Contact

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.

About

CYBERTEC Migrator 🗄🔀🗄

Resources

Readme

License

MIT license
Activity

Stars

0 stars

Watchers

0 watching

Forks

1 fork
Report repository

Releases

No releases published

Packages

No packages published

Languages

  • Shell 100.0%