From: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Converting Access .mdb to postgres |
Date: | 2019-08-14 17:09:09 |
Message-ID: | alpine.LNX.2.20.1908140958530.17042@salmo.appl-ecosys.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I have the need to convert a flat-file Access database to postgres. I've
exported the .mdb tables using mdbtools. There's an accompanying metadata
PDF with column names and data types for each of the 84 tables, but no
description of the tables or column headings. I've asked the agency to
provide that information ... if they have it. No table has primary or
referential keys and, of course, there's no E-R diagram of the schema.
If anyone's done this I'd appreciate learning from your experiences. And I
assume there are no tools to automate all or part of the process so it must
be done manually.
Among the tables are many lookup tables. I don't know whether to leave them
as tables or apply a different structure to them.
Advice, suggestions, and recommendations are all welcome.
TIA,
Rich
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2019-08-14 17:27:11 | Re: Converting Access .mdb to postgres |
Previous Message | Moreno Andreo | 2019-08-14 16:49:39 | How to conditionally change the 2nd part of a full join |