Dear bosses, do data migration, recently the Oracle data needs to be migrated to mysql, then also faces a problem is the Oracle of new data during the process of migration will not automatically transfer, so must carry on the data synchronization, information search on the net looking at kettle can do this step, but for their posts a little look not to understand, is there any bosses can further guidance, or help to find some more detailed information, small white here thank you very much!

CodePudding user response:

Bosses are invited to speak

CodePudding user response:

Kettle related resources: https://blog.csdn.net/songzehao/article/details/81814625

CodePudding user response:

Oracle kettle can do - mysql data migration, but still need to suspend the service for a period of time, such as bank also can apply for a short time and banking regulators closed upgrade system,

Static migration, migration to migration of static and dynamic migration, a lot of stock data, dynamic migration is static migration, to continue migration dynamic data, you can do first migration of static and dynamic migration for several times, after the suspension of service, to do the final live migration, and then to switch from the system,

CodePudding user response:

Main is specific steps don't know much about it

CodePudding user response:

Just have a data synchronization tool (support any table in any database data synchronization, data source can be a table, view, third-party interface, millions of data synchronization takes only ten seconds)

Note: is any database, any table, very fast

CodePudding user response:

winter snow crystal reference 5 floor response:

just have a data synchronization tool (support any table in any database data synchronization, data source can be a table, view, third-party interface, millions of data synchronization takes only ten seconds)

Note: is any database, any table, very fast

bosses what tools, thank you very much