The easiest way from Oracle to PostgreSQL

Escape the cost-intensive Oracle license trap! PostgreSQL saves your company substantial costs. The CYBERTEC Migrator allows you to migrate your databases to PostgreSQL rapidly and smoothly- with the highest possible security and the lowest possible downtime. 

NEW! ATROPOSS MIGRATION EFFORT ESTIMATE

Get a quick estimate of the effort to migrate your database to PostgreSQL through the ATROPOSS project website, partnered with Microsoft. A fantastic new tool, the Database Migration Assessment module, will allow you to rapidly assess how much effort Oracle to PostgreSQL migration will cost your company. It’s easy to use, just import your SQL- it works right in the browser and no external resources are necessary.

Try it out – get your estimate now. >>

Choose the CYBERTEC Migrator Edition that’s right for you

STANDARD

PROFESSIONAL

ENTERPRISE

 

Easy, visually guided migration for databases without SLA’s – meaning a longer period of downtime is OK

Download >>

 

Migration for performance-intensive projects with SLA’s (but a few hours of downtime is permissible)

CONTACT >>

 

Migration for databases with High Availability (Downtime needs to be in minutes, not hours)

CONTACT >>

Key Features

We work on Oracle -> PostgreSQL migration projects every day. That’s why we needed to develop an application which enables a convenient, rapid and secure migration – even for the most demanding and/or intricate of projects. Benefit from the following tried-and-true features as you migrate your databases to PostgreSQL:

  • Easy installation
  • Convenient Graphical User Interface (GUI) for customizing and testing the migration
  • Complete database schema migration
  • High-speed data migration
  • Easy rollout of the migration in production environments
  • Audit-proof migration log for download and archiving
  • Nearly-zero-downtime migration for high availability databases
  • Kubernetes & OpenShift ready
  • … and much more

The migration with our CYBERTEC Migrator is that easy! See for yourself and watch our tutorials on YouTube!

YouTube

By loading the video, you agree to YouTube’s privacy policy.
Learn more

Load video

How the CYBERTEC MIGRATOR works – the Migration Process

Our application is built to accompany you through the migration journey. The CYBERTEC Migrator is extremely user-friendly and, in addition to the graphical interface, has a guided step-by-step setup to prepare your databases for data transfer.

CYBERTEC Migrator: Migration process to Oracle

If all else fails and you get stuck, we are ready to assist you. Our team and our experience assure you the best possible results.

GET MIGRATOR >>

FREE download of the CYBERTEC Migrator Standard Edition

Databases can easily be migrated with the Standard Edition (for databases that don’t have Service Level Agreements or SLAs bound to customer applications). Request the download link by email in the form below. Try out all the features of the Migrator with a test database, and decide later if you need to upgrade to the Professional or Enterprise Edition.

Please note: You may request the download link only once per email address. We will send release updates to the email address provided on a regular basis. You may cancel your newsletter subscription at any time.

More resources and instructions

We at CYBERTEC are proud to release the CYBERTEC Migrator Standard Edition. Read more about the history of the CYBERTEC Migrator, the installation itself and planned functions. Or switch directly to the offline installation guide. Learn how to get the best out of the CYBERTEC Migrator in our latest blog posts. Stay tuned and get useful tips and tricks.

MEET THE CYBERTEC MIGRATOR

OFFLINE INSTALLATION GUIDE

CYBERTEC MIGRATOR: FEATURES IN DETAIL

Feature

STANDARD

PROFESSIONAL

ENTERPRISE

Easy installation with container images

x

x

x

Create migration with connectivity check

x

x

x

Clone migration configuration for databases with same structure (dev, test, production)

x

x

x

Overview of source database meta-data

x

x

x

Sidebar navigation and object filter

x

x

x

Configurable migration via GUI
(for details see table below)

x

x

x

Migrate Oracle Schema
(for details see
GitHub – Supported features for migration from Oracle )

x

x

x

Migration controls:
Start/abort migration
Resume migration
Re-run stage
Continue to next stag
Skip data transfer

x

x

x

Hooks to integrate user defined SQL script in the migration
add/remove script
enable/disable hook
audit content for audit purpose

x

x

x

Export code for views, triggers, etc. to file system

x

x

x

Audit Log view
Hyperlinking to database object
Download migration log
Configurable log levels

x

x

x

Search and Replace for easy code translation from PL/SQL to PL/pgSQL
Upper/lowercase
Regular expressions
Filter on attributes of specific database object types

x

x

x

REST API:
bulk processing to read databases meta-data
full migration control
retrieve migration status

x

x

x

Migrate table partitions

only data is migrated,
not the partitions

x

x

Speed optimized, parallel data transfer

lim. to 3 parallel transfers

32 parallel transfers

unlimited

Parallel creation of indexes and foreign keys

lim.  to 3 parallel workers

32 parallel workers

unlimited

Migration assessment (*)

x

x

x

Data quality validation (*)

x

x

Close-to-zero-downtime migrations with Asynchronous Replicator (*) (until 21c)

x

Support

Community forum, 1 hour consulting

12 months support: Migrator Service Desk, monthly feature releases, 4 hours consulting

12 months support: Migrator Service Desk, monthly feature releases, individual consutling

(*) Functions on the Migrator Roadmap

Configurable Migration in the user interface

Feature

STANDARD

PROFESSIONAL

ENTERPRISE

Exclude database objects (schemas, tables, triggers, …) from migration

x

x

x

Exclude columns

x

x

x

Table properties:
data type
nullable
default values

x

x

x

Constraint properties:
Rename constraint
Constraint mode (deferrable, …)
Not-null constraints
Expression for check constraints
Add/remove/reorder columns in primary/unique keys
Foreign keys delete rule

x

x

x

Index properties:
Rename index
Index expression

x

x

x

Trigger properties:
Trigger type
Trigger level
Trigger event
When condition

x

x

x

Table partitions and subpartitions:
Disable partitioning
Rename partition

x

x

Bulk changes
data types
exclude DBOs
disable partitioning

x

x

x

Code editor (view, functions, procedures):
Diff against original code
PL/pgSQL syntax check
DDL code verification against database

x

x

x

(*) Functions on the Migrator Roadmap
REQUEST INFO (NO OBLIGATION) >>

DOWNLOAD STANDARD EDITION >>

 

FAQs

Q: What are the differences between the 3 editions?
A: We have furthered the development of the CYBERTEC Migrator for many years and would now like to offer the free option of the CYBERTEC Migrator to smaller companies and private projects, so that they too can benefit from PostgreSQL. The Standard Edition has all the necessary features for a migration, but is more limited. For example, the migration of larger databases takes longer with the Standard Edition, due to the limited number of parallel transfers. With the Professional Edition, customers receive additional product support. The Enterprise Edition adds asynchronous data replication. This allows migrations to take place with a very short database downtime.

Q: How do I get the Enterprise or Professional Edition?
A: The Professional and Enterprise Editions are available through our sales team. Please contact us by email, phone or use the contact form.

REQUEST INFO (NO OBLIGATION) >>

 

Q: How often is the Migrator released?
A: The CYBERTEC Migrator is in continuous development and is kept up-to-date with monthly releases. Customers of the Professional and Enterprise Edition benefit from direct product support.

Q: What are the requirements for my system?
A: The CYBERTEC Migrator works on any system where container images can be launched. Find out more information here.

README.MD >>

SUPPORT & HELP

We are here to help you! If you have any kind of problem with your migration, please visit our customer support portal.

GET HELP >>