Enterprise-grade migrations are not easy; often, complexity, inconvenience and pain take over. We at CYBERTEC understand this problem, and we therefore focus on:
- Usability
- Efficiency
- Customer experience
Touring a typical Oracle to PostgreSQL migration
CYBERTEC Migrator is beautiful and easy to use. Let’s take a visual tour through our migrator, and learn how easy it can be to move from Oracle to PostgreSQL.
Step 1: Creating a migration project
Simply enter your connect strings (Oracle and PostgreSQL), verify your connections and CYBERTEC Migrator will connect to Oracle and inspect the database.
Step 2: Reading metadata from Oracle
CYBERTEC Migrator will connect to your database and read all the metadata from Oracle to prepare for the migration project.
Step 3: Assess the migration
Quickly investigate the cost of a migration and the number of objects, tables, procedures, and a lot more, within your database.
Our tool will give you an overview and provide you with estimates which can directly be used to plan your migration project.
Step 4: Include and exclude tables
Quickly investigate the cost of a migration:
Step 5: Adjust your data structures
The CYBERTEC Migrator allows you to adjust your data structures before the migration. Quickly and easily change data types and adjust constraints, NULL values and a lot more.
In addition to tables, it is also possible to adjust the definitions of views visually. Simply use our editor to make changes.
Step 6: Running your migration in stages
A migration from Oracle to PostgreSQL runs in stages. You can adjust the desired behavior at every step of the way, and re-run those stages one by one to create a final “definition” of the migration, which is then executed perfectly.
Proper error handling can be configured at every stage.
Step 7: Managing procedures
Migrating stored procedures can turn out to be the bulk of your migration efforts. We offer an easy-to-use editor to help you adjust code and track what you have done. Make your changes and check them immediately; figure out what is working, and what is not.
If you don’t want to migrate a function, because it’s broken or because it’s not needed anymore, it can be removed from the migration process simply and intuitively:
Step 8: Handling errors and fixing them
Any migration involving more than simple, flat tables will present you with changes that have to be made in order to load data into PostgreSQL. Finding and managing those changes is important to reduce the manual input needed to efficiently transform the database.
Error handling is therefore an essential part of the tooling, to make it even easier for developers and project managers alike.
Step 9: Observing success
Quickly investigate the cost of a migration:
Request a free demo
Contact us today and request a free live demonstration of the full CYBERTEC Migrator user experience. We are more than happy to show you how the CYBERTEC Migrator works!
CONTACT>>