问题描述
我有一个在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.
这篇关于从Oracle到Postgres，MySQL或MS Access迁移的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！