将MS Access迁移到PostgreSQL

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

我正在以Access文件形式获取数据.

I'm getting data as an Access file.

我的应用程序使用PostgreSQL/Java.我想将Access数据库转换为PostgreSQL. 谁能帮我编写代码

My application uses PostgreSQL/Java. I'd like to convert the Access database to PostgreSQL. can any one help me to code this

推荐答案

我怀疑是否有任何简单的自动方法.您将必须创建ddl语句以在postgresql中创建表(不确定是否可以从access导出ddl)，从access导出数据到csv，然后使用postgresql copy from命令填充表.

I doubt there is any simple automatic method. You will have to create ddl statements to make the tables in postgresql (not sure if you can export ddl from access), export the data from access to a csv, and then use postgresql copy from command to populate the tables.

或者您可以考虑尝试使用此工具:

Or you could consider trying this tool:

docman.sourceforge/home_html/projects/sql/exportSQL3.txt

但它看起来像开发版本，可能还不成熟.

but it looks like a dev version, it may not be mature.