在不同的DBMS之间传输数据 [英] Transferring data between different DBMS's

问题描述

我想将Informix中拥有的整个数据库转移给Oracle.我们有一个适用于两个数据库的应用程序，我们的一位客户正在从Informix迁移到Oracle，并且需要将整个数据库转移到Oracle(结构相同).

I would like to transfer the whole Database i have in Informix to Oracle. We have an an application which works on both Databases, one of our customers is moving from Informix to Oracle, and needs to transfer the whole Database to Oracle (the structure is the same).

我们经常需要在oracle/Mssql/Informix之间传输数据，有时只是一个表而不是整个数据库.

We need often to transfer data between oracle/Mssql/Informix sometimes only one table and not the whole Database.

有人知道做这种工作的任何好的程序吗?

Does anybody know about any good program which does this kind of job?

推荐答案

Pentaho 数据集成

The Pentaho Data Integration ETL tools are available as open source (also known under the former name "Kettle") for cross-database migration and many other use cases.

从他们的数据表中:

常用案例

• 内置了对缓慢变化的内置支持的数据仓库 尺寸，垃圾尺寸
• 将数据库导出到文本文件或其他数据库中
• 将数据导入数据库，范围从文本文件到excel 床单
• 数据库应用程序之间的数据迁移
• ...

• Data warehouse population with built-in support for slowly changing dimensions, junk dimensions
• Export of database(s) to text-file(s) or other databases
• Import of data into databases, ranging from text-files to excel sheets
• Data migration between database applications
• ...

输入/输出数据格式列表可以在此问题的可接受答案中找到:

A list of input / output data formats can be found in the accepted answer of this question: Does anybody know the list of Pentaho Data Integration (Kettle) connectors list? It supports all databases with a JDBC driver, which means most of them.

这篇关于在不同的DBMS之间传输数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！