blocks|key|3275481|text|+Data+Integration+工具是开源的(以前的名称是“水壶”)，可用于跨数据库迁移和许多其他用例。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3275482|从他们的数据表中：|3275483|3275484|常见用例|blockquote|3275485|3275486|3275487|具有内置支持的|3275488|数据仓库填充功能，用于在数据库应用程序之间迁移从文本文件到excel工作表的从文本文件到excel表的各种数据，包括缓慢变化的维度、从数据库垃圾dimensions|unordered-list-item|3275489|Export到文本文件或其他数据库|3275490|将数据导入数据库|3275491|3275492|输入/输出数据格式的列表可以在这个问题的接受答案中找到：Does+anybody+know+the+list+of+Pentaho+Data+Integration+(Kettle)+connectors+list?它支持所有具有JDBC驱动程序的数据库，这意味着它们中的大多数。|3275493|entityMap|0|LINK|mutability|MUTABLE|url|http://www.pentaho.com/products/data_integration/|1|https://stackoverflow.com/questions/3716378/does-anybody-know-the-list-of-pentaho-data-integration-kettle-connectors-list/3723627#3723627^0|1|G|0|0|0|0|0|0|0|0|0|0|0|0|S|28|1|0^^$0|@$1|2|3|4|5|6|7|17|8|@]|9|@$A|18|B|19|1|1A]]|C|$]]|$1|D|3|E|5|6|7|1B|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|1C|8|@]|9|@]|C|$]]|$1|G|3|H|5|I|7|1D|8|@]|9|@]|C|$]]|$1|J|3|-4|5|6|7|1E|8|@]|9|@]|C|$]]|$1|K|3|-4|5|6|7|1F|8|@]|9|@]|C|$]]|$1|L|3|M|5|6|7|1G|8|@]|9|@]|C|$]]|$1|N|3|O|5|P|7|1H|8|@]|9|@]|C|$]]|$1|Q|3|R|5|P|7|1I|8|@]|9|@]|C|$]]|$1|S|3|T|5|P|7|1J|8|@]|9|@]|C|$]]|$1|U|3|-4|5|6|7|1K|8|@]|9|@]|C|$]]|$1|V|3|W|5|6|7|1L|8|@]|9|@$A|1M|B|1N|1|1O]]|C|$]]|$1|X|3|-4|5|6|7|1P|8|@]|9|@]|C|$]]]|Y|$Z|$5|10|11|12|C|$13|14]]|15|$5|10|11|12|C|$13|16]]]]

The <a href="http://en.wikipedia.org/wiki/Pentaho" rel="nofollow noreferrer">Pentaho</a> <a href="http://www.pentaho.com/products/data_integration/" rel="nofollow noreferrer">Data Integration</a> <a href="http://en.wikipedia.org/wiki/Extract,_transform,_load" rel="nofollow noreferrer">ETL</a> tools are available as open source (also known under the former name "Kettle") for cross-database migration and many other use cases.

From their data sheet:

<blockquote>
 Common Use Cases 
 
 <ul>
 <li>Data warehouse population with built-in support for slowly changing
 dimensions, junk dimensions</li>
 <li>Export of database(s) to text-file(s) or other databases </li>
 <li>Import of data into databases, ranging from text-files to excel
 sheets </li>
 <li>Data migration between database applications </li>
 <li>...</li>
 </ul>
</blockquote>

A list of input / output data formats can be found in the accepted answer of this question: <a href="https://stackoverflow.com/questions/3716378/does-anybody-know-the-list-of-pentaho-data-integration-kettle-connectors-list/3723627#3723627">Does anybody know the list of Pentaho Data Integration (Kettle) connectors list?</a>
It supports all databases with a JDBC driver, which means most of them.

blocks|key|1958066|text|检查我的这个问题，它包含了一些非常好的想法：Searching+for+(freeware)+database+migration+tool|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1958067|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/2072789/searching-for-freeware-database-migration-tool^0|M|1C|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

Check this question of mine, it includes some very good ideas: <a href="https://stackoverflow.com/questions/2072789/searching-for-freeware-database-migration-tool">Searching for (freeware) database migration tool</a>

blocks|key|4875806|text|您可以尝试一下Oracle+Migration+Workbench。如果您想定期将Informix数据读入http://download.oracle.com/docs/html/B15858_01/toc.htm，使用异构服务可能是更好的选择。检查hs4odbc或dg4odbc，具体取决于您拥有的Oracle版本。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|4875807|我希望这能帮到你，罗纳德。|4875808|entityMap|0|LINK|mutability|MUTABLE|url|http://download.oracle.com/docs/html/B15858_01/toc.htm^0|1H|1I|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]]|C|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]]]

you could give the Oracle Migration Workbench a try. See <a href="http://download.oracle.com/docs/html/B15858_01/toc.htm" rel="nofollow">http://download.oracle.com/docs/html/B15858_01/toc.htm</a> If you want to read Informix data into Oracle on a regular basis, using the Heterogeneous Services might be a better option. Check for hs4odbc or dg4odbc, depending on the Oracle release you have.

I hope this helps,
Ronald.

blocks|key|1209863|text|我以前也这样做过，这不是一件微不足道的事情。我们最终将每个表写出到一个以管道分隔的平面文件中，并使用Oracle+SQL+Loader将每个表重新加载到Oracle中。有大量的Perl脚本用来擦除源数据，shell脚本用来尽可能地自动化这个过程，同时也可以并行运行。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1209864|可能出现的问题:+1.选择一个尽可能唯一的分隔符。2.尽可能找到与Informix数据类型匹配的数据类型。ie日期与时间戳3.在转储平面文件之前，请尝试尽可能地清理数据。4.+HS很可能太慢了..|1209865|这是几年前的事了。你可能想要研究一下金门(现在归Oracle所有)软件，它可能会对这个过程有所帮助(我做的时候GG还不存在)|1209866|另一个想法是使用ETL工具读取Informix并将数据转储到Oracle+(想到了Informatica)|1209867|祝你好运:)|1209868|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|M|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|N|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|O|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|P|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|K|$]]

I have done this in the past and it is not a trivial task. We ended up writing out each table out to a pipe delimited flat file and reloading each table into Oracle with Oracle SQL Loader. There was a ton of Perl scripts to scrub the source data and shell scripts to automate the process as much as possible and run things in parallel as well. 

Gotchas that can come up:
1. Pick a delimiter that is as unique as possible.
2. Try to find data types that match as close as possible to the Informix ones as possible. ie date vs. timestamp
3. Try to get the data as clean as possible prior to dumping out the flat files.
4. HS will most likely be too slow..

This was done years ago. You may want to investigate Golden Gate (now owned by Oracle) software which may help with the process(GG did not exist when I did it)

Another idea is use an ETL tool to read Informix and dump the data into Oracle (Informatica comes to mind) 

Good luck :)

blocks|key|4875989|text|Oracle+sqlldr-的导入实用程序|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|4875990|下面是我将50TB的数据从MySQL传输到ORacle的过程。从MySql生成csv文件，并使用oracle中的sqlldr实用程序将文件中的所有数据导出到oracle+db。这是导入数据的最快方式。我对此进行了几周的研究，并做了很多基准测试用例，sqlldr无疑是导入oracle的最好、最快的方法。|4875991|entityMap^0|E|7|0|0|47|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|H|3|-4|5|6|7|P|8|@]|D|@]|E|$]]]|I|$]]

sqlldr - Oracle's import utility

Here's what I did to transfer 50TB of data from MySQL to ORacle. Generated csv files from MySql and used sqlldr utility in oracle to export all the data from the files to oracle db. It is the fastest way to import data. I researched on this for a few weeks and done lot of benchmark test cases and sqlldr is hands down best and fastest way to import into 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). 

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?

Transferring data between different DBMS's

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云AI代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

功能1上新10个字符

功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符。

功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符。

功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符

功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符

功能4上新

文章&问答评论现已支持表情

全新交互，全新视觉，新增快捷键、悬浮工具栏、高亮块等功能并同时优化现有功能，全面提升创作效率和体验

社区富文本编辑器全新改版！诚邀体验～ 

精选全网热门MCP server，让你的AI更好用 🚀

💥开发者 MCP广场重磅上线！

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

我想把我在Informix中的整个数据库转移到Oracle上。我们有一个在两个数据库上运行的应用程序，我们的一个客户正在从Informix迁移到Oracle，并且需要将整个数据库转移到Oracle (结构相同)。我们经常需要在oracle/Mssql/Informix之间传输数据，有时只需要一个表，而不是整个数据库。有没有人知道做这种工作的好程序？

问在不同的DBMS之间传输数据
EN

回答 5

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在不同的DBMS之间传输数据EN

回答 5

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在不同的DBMS之间传输数据
EN