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.

Import csv to razorsql