Good afternoon,
What is the best procedure for exporting data from a MySQL table (versao 1.3), for an Oracle 10G Version table)?
The table I want to export has almost 300,000 lines.
Thanks.
Export MySQL data and import in Oracle
- stcoutinho
- Moderador
- Posts: 850
- Joined: Wed, 11 May 2011 5:15 pm
- Location: são Paulo - SP
OI,
There are some possibilities:
a) You could generate a text file (CVS or delimited) in this MySQL table and then make a load via SQL * Loader in Oracle;
b) You could use the Oracle SQLDeveloper tool and migrate this MySQL table to Oracle. More Details You can find here: http://www.oracle.com/technetwork/datab ... 93223.html
c) Use a conversion tool, such as DRPU. More information on: http://www.drpudatabase.com/
and) Create a DBLink in Oracle pointed to MySQL and pull the table there. It has a good article in this link: http://www.devmedia.com.br/acessando-ou ... odbc/13124
Options is that they are not lacking. You need to see if you just need to migrate once the table or will be a periodic process. If it is a continuous action, you can use for example the A / E options (automating the process).
Hugs,
Sergio Coutinho
There are some possibilities:
a) You could generate a text file (CVS or delimited) in this MySQL table and then make a load via SQL * Loader in Oracle;
b) You could use the Oracle SQLDeveloper tool and migrate this MySQL table to Oracle. More Details You can find here: http://www.oracle.com/technetwork/datab ... 93223.html
c) Use a conversion tool, such as DRPU. More information on: http://www.drpudatabase.com/
and) Create a DBLink in Oracle pointed to MySQL and pull the table there. It has a good article in this link: http://www.devmedia.com.br/acessando-ou ... odbc/13124
Options is that they are not lacking. You need to see if you just need to migrate once the table or will be a periodic process. If it is a continuous action, you can use for example the A / E options (automating the process).
Hugs,
Sergio Coutinho
-
- Information
-
Who is online
Users browsing this forum: No registered users and 18 guests