MYSQL TO ORACLE CONVERTER
MySQL to Oracle Converter is a tool to Convert, Migrate data from MySQL Database to Oracle Database or from Oracle to MySQL Database. You can convert multiple tables in one go from MySQL to Oracle or from Oracle to MySQL. While transferring you can map source table columns to matching target table columns if they are not same. You can also load only a subset of rows by adding WHERE conditions.
MySQL to Oracle Converter comes with a built in scheduler so that you can run transfer jobs at specified intervals. Now no need to run jobs repeatedly, just create a Session define the schedule date and time and MySQL to Oracle Converter will automatically executes your session in the background and records the actions in a specified log file. You can later on check the log file for information.
Supports all Versions of MySQL and Oracle
Provides a command line interface also to run migration jobs manually so that it can be easily integrated with your own application.
All the sessions are stored in a repository. MySQL to Oracle Converter provides a user friendly interface to manage repository. Such as taking backup and/or restore repository from a previous backup. You can also create a new blank repository in case you need it.
Using MySQL to Oracle Converter you can perform the following conversion
- MySQL to ORACLE Database
- MySQL to ORACLE SQL Dump file
- ORACLE to MySQL Database
- ORACLE to MySQL SQL Dump file
- MySQL to MySQL SQL Dump file
- ORACLE to ORACLE SQL Dump file
- ORACLE to ORACLE Database
- MySQL to MySQL Database
Synchronize
Synchronize MySQL and Oracle databases by using UPSERT and INSERT loading option.
UPSERT
This feature will update the row in the Oracle table if a matching row exist otherwise if the matching row does not exist it will insert a new row.
INSERT
This feature will insert a row in the Oracle table only if the matching row does not exist
Top Features of MySQL to Oracle Converter
Supported Databases
- MySQL
- MySQL Dump
- Oracle
- Oracle SQL Dump
- MS Access
- PostgreSQL
- Foxpro/DBF Files
- CSV/Text or Fixed width
- MS SQL Server
- MS SQL Server Dump
- Maria DB
- Amazon RDS
- Amazon Aurora
- Google Cloud
- Azure Database for MySQL
Constraints and Indexes
Imports all Constraints and Indexes and Auto Increment attributes.
In Built Scheduler
Automatically transfer data without any interaction.
Bulk Loading
Bulk Loading feature for Oracle, MySQL and MS SQL Server databases to load millions of rows at blazing speed.
Column Mapping
Load into new or existing tables with full Column Mapping.
SQL DUMP FILES
Generate SQL dump files from any database source.
Synchronize
UPSERT and INSERT loading options to Synchronize Source and Target databases.