将MS Access迁移到PostgreSQL [英] Migrate MS Access to 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:

http://docman.sourceforge.net/home_html/projects/sql/exportSQL3.txt

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

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

这篇关于将MS Access迁移到PostgreSQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！