我正在以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.
更多推荐
将MS Access迁移到PostgreSQL
发布评论