Having that execution time resolved, this export step is no hassle. With millions of row to be exported, I needed to extend the time for the PHP script to execute, and mentioned it on my previous post. However, for some reason, I could not get the field delimiter and special character escaping in the CSV exported with mysqldump to be imported properly into the Oracle database, so I ended up using PhpMyAdmin to export the data. Fortunately, SQL Developer supports importing data from CSV files.ĭefinitely I could use mysqldump to take data from the MySQL server, which is the fastest method I have known of. In fact, I do not know if Oracle provide a command-line interface for administrator to quickly import data, like MySQL LOAD DATA INFILE statement, or not.

Thus, now I can only import the data to the Oracle database using CSV files.

I guess it is not stable enough, or it is not for million-record tables. Everytime I tried, it failed after a few thousand of records. However, the method was not so good, in my opinion. All you need to do is to choose the MySQL database, right-click the database then “Tables” on the left sidebar and choose “Database Conversion > Convert Table” with the configuration similar to this screenshot below.Īs mentioned above, RazorSQL does provide the data conversion. Here I use it to convert only the table structures (the reason not to migrate the data will be explained shortly). When I open connections to both databases, I can actually use the Convert Table(s) feature in RazorSQL to convert both table structure and data between types of database. However, I found an application called RazorSQL that can deal with various types of database, including MySQL and Oracle. This step can be done in various methods, I suppose. I DO NOT have access to premium tools for this job, so just free stuff.I DO have admin access to the MySQL server.I DO NOT have admin access to the Oracle database server and use SQL Developer to connect to the database.It is definitely not the best method for everyone, but I think it would be useful for some. It was a fun time for me figuring out the “best” method to deal with the situation. I am not sure how many records a database needs to be considered big, but this one has 15 tables few of them have 2-5 million rows, and one has over 20 million.

Recently I had a task to convert a database from MySQL to Oracle.

How to export using razorsql table