从Oracle到Postgres，MySQL或MS Access迁移

本文介绍了从Oracle到Postgres，MySQL或MS Access迁移的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我有一个在2000 NT服务器上运行的Oracle 8i数据库.

I have an Oracle 8i database running on 2000 NT server.

我被分配了一个任务，将数据和模式一起复制到其中的任何一个

I have been assigned a task to copy data along with schema into any of these

(PostgreSQL，mysql，ms访问)

(postgresql, mysql, ms access)

我在互联网上尝试了很多，但是没有这样的工具可以帮助我.现在，我正在使用VM WARE在虚拟机中运行该NT 2000.

I have tried a lot in the internet but there is no such tool which could help me. Right now I am running that NT 2000 in virtual machine using VM WARE.

推荐答案

要将模式/数据复制到PostgreSQL，有 ora2pg .如果这是一项经常性的任务，那么有关ora2pg的一件好事是，您可以潜在地编写脚本/自动执行该过程.

For copying the schema/data to PostgreSQL there is ora2pg. If this is a recurring task then one nice thing about ora2pg is that you can potentially script/automate the process.

对于一次性导出或ad-hock导出，并且根据数据库的性质和大小，还可以使用 DbVisualizer 导出架构/数据.

For a one-time or ad-hock export, and depending on the nature and size of the database, you can also use DbVisualizer to export the schemas/data.