Converting Access .mdb to postgres

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

Responses

Browse pgsql-general by date

  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