导出到MySQL（C＃） [英] Export Pervasive to MySQL (C#)

问题描述

我在寻找一种从Pervasive 11导出整个数据库的方法，发送它并导入MySQL服务器。我试图将它导出到xml文件，但我有问题导入到MySQL。

i'm looking for a way to export whole database from Pervasive 11, send it and import to MySQL server. I've tried to export it to xml file but i had problems with import it to MySQL.

任何想法？

推荐答案

你真的有两个选择：
1.自己写。
2.使用第三方工具。

You really have two options: 1. Write it yourself. 2. Use a third party tool.

自己写：
如果你自己写需要注意数据类型的差异。 Pervasive和MySQL支持不同的数据类型。如果你有一个不直接支持MySQL的Pervasive数据类型，你需要在写它之前进行转换。除此之外，过程相当简单：读取记录，转换任何数据，写入记录。对所有表重复此操作。

Write it yourself: If you are writing it yourself, you need to watch out for data type differences. Pervasive and MySQL support different data types. If you've got a Pervasive data type that isn't directly supported by MySQL, you'll need to convert it before writing it. Beyond that, the process is fairly simple: Read the records, convert any data, write the record. Repeat for all of the tables.

使用第三方工具：
有几个工具可以做你想要的。它们可能需要多次传递以获取所有表，但在大多数情况下可以自动化。属于此类别的工具包括：
- Pervasive Data Integrator - http://integration.pervasive.com/
- Informatica电源中心 - http：// www.informatica.com/us/products/enterprise-data-integration/powercenter/
还有其他工具。

我找到了此链接 http://www.etltools.net/etl-tools-comparison.html 但不能代表完整性或准确性。我只使用Pervasive Data Integrator和Microsoft SSIS（当从Pervasive到MS SQL时）。

Use a third party tool: There are several tools available that can do what you want. They may require multiple passes to get all of the tables but that can be automated in most cases. Tools that fall into this category include: - Pervasive Data Integrator - http://integration.pervasive.com/ - Informatica Power Center - http://www.informatica.com/us/products/enterprise-data-integration/powercenter/ There are other tools as well.
I did find this link http://www.etltools.net/etl-tools-comparison.html but cannot speak for the completeness or accuracy of the information. I've only used the Pervasive Data Integrator and Microsoft SSIS (when going from Pervasive to MS SQL).

这篇关于导出到MySQL（C＃）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！