ORACLE TO MYSQL CONVERTER
Oracle to MySQL Converter is a tool to Convert, Migrate data from Oracle Database to MySQL Database or from MySQL to Oracle Database. You can convert multiple tables in one go from Oracle to MySQL or from Oracle to MySQL database. Let’s you do mapping between Source & Target Table columns. This feature is very important if the Source and Target table columns are not in the same order. User can load all rows or subset of rows from source to target table by adding user define conditions.
Oracle to MySQL Converter (previously known as Oracle to MySQL Loader) 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 Oracle to MySQL 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.
Works flawlessly for converting data from Oracle to MariaDB and MariaDB to Oracle also 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. Oracle to MySQL 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 Oracle to MySQL Converter you can perform the following conversion
ORACLE to MySQL Database
ORACLE to MariaDB Database
ORACLE to MySQL SQL Dump file
ORACLE to MariaDB SQL Dump file
MySQL to ORACLE Database
MariaDB to ORACLE Database
MySQL to ORACLE SQL Dump file
MariaDB to ORACLE SQL Dump file
ORACLE to ORACLE SQL Dump file
ORACLE to ORACLE Database
MySQL to MySQL Database
MySQL to MariaDB Database
MySQL to MySQL SQL Dump file
ORACLE Client Not Required.
Our product comes with Oracle Client Software so you can connect it to Oracle database from any PC with or without Oracle Client software install
Even there is no need to install MySQL drivers or libraries.
UPSERT and INSERT
Synchronizes Oracle and MySQL tables by Updating a row if a matching source row exist in the target table. If the matching row does not exist it Inserts a new row in the target table
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
Top Features
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.
Select Oracle tables, choose MySQL target, Transfer data without any coding
