There is a table in oracle, the data has 1 million, could you tell me how to quickly put the table data guide to mysql a table in the same structure?

CodePudding user response:

Navicat this tool, you can have a try;

CodePudding user response:

The kettle is a tool, can have a try

CodePudding user response:

The building was later how to deal with? I'm also from oracle derivative according to mysql, some table data is too much, more than 600 + ten thousand, provide better tools or converted to SQL for a few days, and what's the problem with intermediate network be reversed, solving

CodePudding user response:

The

reference 3 floor VPDamon response:

the original poster was later how to deal with it? I now also from oracle derivative according to mysql, some table data is too much, more than 600 + ten thousand, provide better tools or converted to SQL for a few days, have any questions will be disqualified and intermediate network, solving

see to your message, just don't say how to do, give you a general idea for

CodePudding user response:

"To accelerate the JDBC shortcut" this article introduced parallel way to read and write data is good, I tried some useful, indeed speed for several times

CodePudding user response:

Speechless, millions will be a few days, the efficiency is too low