Is now in the oracle database migration to the mysql database, tried to use navicat premium to transform, and the. SQL file form the oracle data and export structure, but speed is slow, at least more than three days, but also in the case of normal network connection, often a long period of time, a decade or two hours after the database connection is broken,
Validate what fast some way can use the



(PS: in order to watch about 3 g + DMP file, the largest data table has 600 + ten thousand)

CodePudding user response:

1, ogg data synchronization can be used, the data synchronization to mysql from oracle, this is very fast, and most recommended
2, to export the data structure (not derivative according to), then on the mysql data structure to sync all the past, then use the ETL tool (such as kettle) parallel data to mysql