不同DBMS之间的数据迁移 [英] Data migration between different DBMS's

问题描述

因为我没有得到任何令人满意的答案我的问题它似乎我们必须为此编写自己的程序，我们正处于设计阶段，我们正在考虑使用哪种格式来备份数据。

该程序将以Delphi编写。

需要在Oracle / Informix / Msserver之间导出/导入数据，非常重要这里是性能问题，因为该程序将在1-2 GB的数据库上运行。除了正常的数据外，数据库中还有一些Blob必须被备份。

我们想到了Xml-Data或逗号分隔的数据，因为它们都是透明的（这是很好的有），但Blob必须在这里考虑。在这种情况下，悖论格式不是最佳选择。

任何人都可以推荐一些性能格式？

欢迎任何其他实现相同目标的想法。

Thanx in Advance。

解决方案

我使用了一个名为 OmegaSync 的优秀程序对于我的备份，但它只会通过ODBC处理Informix，而不是直接处理。如果您发现可以使用OmegaSync，则会发现其性能优异，因为它首先比较数据库，然后才能同步差异。你可能想使用这个想法，如果你自己做自己的编程，如果效率是你的第一个目标。

但编程数据库转换是非常复杂的，因为其他答案你的问题已经说那么为什么不只是开发你需要的SQL，并且这样做的转换。例如：将Informix架构转换为Oracle架构或任何其他RDBMS 为了移动数据，请查看以下资源：移动非-informaix数据在计算机和数据库空间之间

您可以优化SQL，我肯定会是一个足够的速度，如果你倾倒和加载你的数据聪明。

As i couldnt get any satisfying answer to my Question it seems we have to write our own program for that, we are in the design phase and we are thinking which format shall we use to backup the data.

The program will be written in Delphi.

Needed is Exporting/Importing data between Oracle/Informix/Msserver, very important here is the Performance issue, as this program will run on a 1-2 GB Databases. Beside the normal data there are Blobs in the Database which have to be backuped.

We thought of Xml-Data or comma-separated data as both are transparent (which is nice to have), but Blobs must be considered here. Paradox format is not optinal in this case.

Can anybody recommend some performant formats?

Any other Ideas to achieve the same Goal are welcome.

Thanx in Advance.

解决方案

I use an excellent program called OmegaSync for my backups, but it will only handle Informix via ODBC and not directly. If you find you can use OmegaSync, you'll find its performance to be excellent, because it compares the databases first, and then syncs only the differences. You might want to use this idea if you decide to do the programming yourself if efficiency is your number one goal.

But programming database conversion is very complex as others answers to your question have said. So why not just develop the SQL you need, and do the conversion that way. For example see: Convert Informix Schema to Oracle Schema Or Any Other RDBMS For moving the data, check out sources like: Moving non-informaix data between computers and dbspaces

You can optimize the SQL to what I'm sure will be an adequate speed if you dump and load your data smartly.

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