Need to convert MySQL / MariaDB to Oracle or Oracle to MySQL / MariaDB then, you have come to the right place. Our tool can convert databases in just a few mouse clicks. No need to write a single piece of code. It automatically converts tables, views, schemas, constraints, default values and of course data.

It can also load data into existing tables with full column mapping support. Unlike other tools which just creates and loads data into new tables, Data Loader can be used to load data into existing tables with different table names and column names.

It comes with its own scheduler to perform conversion jobs automatically at your specified intervals.  You just need to create a Session define the execution Date and Time interval and Data Loader will automatically execute your session in the background and records the actions in a specified log file.

Synchronization: Do you need to Sync data between Oracle and MySQL tables or Vice Versa? Then look no further, our tool is capable of synchronizing data between Oracle and MySQL or MySQL and Oracle tables. i.e. it will automatically update changed rows, insert new rows and deletes deleted rows automatically at your given interval.

Since its launch 15 years ago, our converter tool has gone into continues improvement and changes to meet the demand of customers and still improving

Major Features

• Convert Oracle VIEWS to MySQL VIEWS or MySQL VIEWS to Oracle VIEWS.
  Our converter can convert Oracle Views to MySQL Views / Tables automatically. It automatically changes the Syntax and creates the views in the target database.
  
• Support for Constraints and Indexes

Data Loader migrates Constraints and Indexes. It can migrate Primary Keys, Unique Keys, Foreign Keys, NOT NULL and Default Values.

• BULK INSERT and BULK LOAD

Data Loader also supports BULK INSERT and BULK LOAD methods to load data into MySQL and Oracle databases. This method greatly improves the performance and one can load millions of rows in very less time.

• Supports UPSERT and INSERT feature.  Data Loader can be used to synchronize data from any source database to any target database.
  
  UPSERT
  This feature will update row in the target 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 target table only if the matching row does not exist.

• Full Editing feature. You can edit, delete column mappings of saved sessions.
• You can create SQL Dump files from any Source Database.
  
  SQL dump files are useful if you have to load the data into Oracle databases or MySQL
  where you don't have a direct connection.
  
  
• Support all MySQL Versions or MariaDB Versions.
  
• Doesn't require Oracle Client software or ODBC drivers. Data Loader comes with Oracle client libraries.

Basic conversion can be done in simple steps

 

And as usual Data Loader comes with it's own in built Scheduler. No need to run jobs repeatedly. Just start a Session define the Schedule Date and Time and Data Loader will automatically executes your session in the background and records the actions in a specified logfile. You can check the logfile to check the result.

The Data Loader uses Repository to Store Sessions. It provides Options to Create a new repository in case the current repository has become damaged or lost, to take backup of existing Repository and to restore repository from a backup location.

You can manage existing sessions through Manage Sessions Form. From here you can the see the Status of existing sessions, Edit, Run, Delete or View Logfile of individual Sessions.

Features:

• Wizard based
• Fast Speed
• Completely user friendly
• No need to write any code
• Select single or multiple tables to transfer
• Select or Deselect Columns while transferring
• Change Destination Datatypes and widths
• Automatic Checking of Datatype mismatch
• Specify WHERE condition to filter data
• Filter Columns and Specify Where Conditions while converting from database to Text 
• Rated Best in the category by many website
• Most Popular product in Database App. section in download.com
• Economical costs just $99 For Standard Version
• Trial version available
• Transfer Millions of rows easily and fast. That's what our existing Customers are doing
• Supports Long , Long RAW, BLOB, CLOB and Picture Data types. In a jiffy you can copy data without any coding
• Supported O/s: ,, XP,  Win 7, Win 8, Win 8.1, Windows 2008, Windows 2012

Convert MySQL Server Views to Oracle Views automatically

Examples

MySQL View

CREATE VIEW `mv` AS select `emp`.`EMPNO` AS `empno`,
cast((case `emp`.`COMM` when 1 then 'One' when 2 then 'Two' else 'NotSal' end) as decimal(10,0)) AS `Comm`,
cast((case `emp`.`SAL` when 100 then 'Hundred' when 200 then 'Two Hundred' end) as decimal(10,0)) AS `salary`,
cast(`emp`.`JDATE` as datetime) AS `jdate` from `emp`

Is converted to Oracle as follows

CREATE OR REPLACE VIEW mv as 
select empno, 
TO_NUMBER(DECODE(comm,1,'One',2,'Two','NotSal')) as Comm,
TO_NUMBER(DECODE(sal,100,'Hundred',200,'Two Hundred')) as salary, 
(jdate) as jdate
from emp

---

MySQL View

CREATE VIEW `mview_filter2` AS select `emp`.`EMPNO` AS `empno`,
cast((case `emp`.`COMM` when 1 then 'One' when 2 then 'Two' else 'NotSal' end) as decimal(10,0)) AS `Comm`,
(`emp`.`JDATE` + interval 20 day) AS `NewDate`,
cast((case `emp`.`SAL` when 100 then 'Hundred' when 200 then 'Two Hundred' end) as decimal(10,0)) AS `salary` from `emp`

Is converted to Oracle as follows

CREATE OR REPLACE VIEW "MVIEW_FILTER2" as 
select empno,
TO_NUMBER(DECODE(comm,1,'One',2,'Two','NotSal')) as Comm, 
jdate + 20 as NewDate,
TO_NUMBER(DECODE(sal,100,'Hundred',200,'Two Hundred')) as salary from emp

---

MySQL View

CREATE VIEW `mview_filter21` AS select `emp`.`EMPNO` AS `empno`,
cast((case `emp`.`COMM` when 1 then 'One' when 2 then 'Two' else 'NotSal' end) as decimal(10,0)) AS `Comm`,
(`emp`.`JDATE` - interval -(20) day) AS `NewDate`,
cast((case `emp`.`SAL` when 100 then 'Hundred' when 200 then 'Two Hundred' end) as decimal(10,0)) AS `salary` from `emp`

Is converted to Oracle as follows

CREATE OR REPLACE VIEW "MVIEW_FILTER21" as 
select empno,
TO_NUMBER(DECODE(comm,1,'One',2,'Two','NotSal')) as Comm, 
jdate-20 as NewDate,
TO_NUMBER(DECODE(sal,100,'Hundred',200,'Two Hundred')) as salary from emp

What you are waiting for?

Download Free Trial Version Now
No time limit, No email required,