Step by Step Guide - CYBERTEC Migrator

With this Step by Step Guide you can already see how the CYBERTEC Migrator works and how easy it is to use:

1. ENTER CREDENTIALS

In the first step you can enter the credentials to connect to the database you want to migrate. Connect to Oracle and make sure that connectivity is working.

The system will check the connection and make sure that all extensions needed to proceed are in place.

2. INSTALLATION OF CYBERTEC MIGRATOR: Start setup

The CYBERTEC Migrator will then enable the desired extensions and initialize the connections inside the Oracle foreign data wrapper.

3. CREATION OF SCHEMAS & FOREIGN TABLES IN POSTGRESQL: Creating staging areas

In the next step the migrator will clone the Oracle system catalog and store the relevant information in a PostgreSQL table. This information will then be transformed into the PostgreSQL staging area. Important steps such as data type transformation will be performed at this stage.

4. STEP BY STEP: Migrating structure

At this point we will import tables, indexes, triggers, and a lot more. You can of course exclude elements and make changes to the definitions. Procedures can be rewritten and adjusted to your needs.