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
