从oracle导入数据到mysql [英] Import data to mysql from oracle

问题描述

我有2个数据库，第一个是一个Mysql数据库，它用于一个网站。第二个是Oracle数据库，它具有我想在网站上显示的数据，数据必须是新的，我的意思是，我需要执行一个过程，每30分钟从oracle数据库迁移数据到Mysql。

I have 2 databases, the first one is a Mysql db and it is used for a website. The second one is an Oracle db and it has data that I want to show on the website and that data must be fresh, I mean, I need to execute a process to migrate data to Mysql from oracle db every 30 minutes.

因为我说的是每30分钟迁移60000行，我认为最佳的做法是（考虑性能）：

Because I am talking about 60000 rows to migrate every 30 minutes, I think that optimal way to do it is something like (thinking about performance):

insert into mysql_db.table.field1, mysql_db.table.field2, mysql_db.table.field3 select oracle_db.table.field1, oracle_db.table.field2, oracle_db.table.field3 from oracle_db.table

Oracle数据库在Windows上，Mysql在Linux 。

The Oracle db is on Windows and Mysql is on Linux (Ubuntu).

这是可能吗？怎么样？

Is that possible? how? else, suggest me a different way please.

推荐答案

有MySQL数据库的ODBC驱动程序，您可以尝试使用数据导出工具命令行支持），位于 dbForge Studio for Oracle 中。

Having ODBC driver for the MySQL database, you could try Data Export tool (with command line support) in dbForge Studio for Oracle.

这篇关于从oracle导入数据到mysql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！