Re: Converting Access .mdb to postgres

On Wed, 14 Aug 2019, Rich Shepard wrote: Off the mail list. Sorry all. I thought it went to only Adrian. Rich

Re: Converting Access .mdb to postgres

On Wed, 14 Aug 2019, Rich Shepard wrote: Thanks, Adrian. This looks like it has all the information I need. Adrian, Off the mail list. I'm reading that metadata document and it seems to me that it's not well constructed. Perhaps this is an Access thing[1]; perhaps the DBA's have limited know

Re: Converting Access .mdb to postgres

On Wed, 14 Aug 2019, Adrian Klaver wrote: Here: https://www.streamnet.org/data/downloadable-data/ Link: Data Exchange Standard (DES). Adrian, Then I missed it when I was in that subdirectory. Thanks, Rich

Re: Converting Access .mdb to postgres

On 8/14/19 11:11 AM, Rich Shepard wrote: On Wed, 14 Aug 2019, Adrian Klaver wrote: Have you looked at: https://www.streamnet.org/wp-content/uploads/2018/06/StreamNetExchangeStandard2018-1.doc Thanks, Adrian. This looks like it has all the information I need. Under which menu did you find t

Re: Converting Access .mdb to postgres

On Wed, 14 Aug 2019, Roger De Four wrote: Rich - This is the ERD for the Access db you posted Thanks, Roger. The exchange format document Adrian found also has an E-R diagram. Much appreciated, Rich

Re: Converting Access .mdb to postgres

On Wed, 14 Aug 2019, Michael Nolan wrote: It seemed like for every rule I tried there were a handful of exceptions. We wound up just rewriting the app and not trying to export the data from the previous one. Mike, This is not surprising. My interest is in the data, not the application. Much o

Re: Converting Access .mdb to postgres

On Wed, 14 Aug 2019, Adrian Klaver wrote: Have you looked at: https://www.streamnet.org/wp-content/uploads/2018/06/StreamNetExchangeStandard2018-1.doc Thanks, Adrian. This looks like it has all the information I need. Under which menu did you find this? I had looked in the Data and Resources

Re: Converting Access .mdb to postgres

A few years ago I tried to take an app someone had written for us in Access years ago and convert it to Postgres. It seemed like for every rule I tried there were a handful of exceptions. We wound up just rewriting the app and not trying to export the data from the previous one. I hope your pro

Re: Converting Access .mdb to postgres

On Wed, 14 Aug 2019, Rich Shepard wrote: I could post the .mdb on a cloud web site for download; it's 565M uncompressed; the xz-compressed tarball is a mere 42M. Will post the URL for the tarball Real Soon Now. Here it is for anyone interested: . Rich

Re: Converting Access .mdb to postgres

On Wed, 14 Aug 2019, Adrian Klaver wrote: Have you looked at: https://www.streamnet.org/wp-content/uploads/2018/06/StreamNetExchangeStandard2018-1.doc Adrian, Not yet, but I will. Didn't see it when I went to the data pages. Thanks, Rich

Re: Converting Access .mdb to postgres

On Wed, 14 Aug 2019, Roger De Four wrote: The easy way - just send it to me. The more challenging way requires using several tools like excel or Open Office. Roger, I could post the .mdb on a cloud web site for download; it's 565M uncompressed; the xz-compressed tarball is a mere 42M. When

Re: Converting Access .mdb to postgres

On 8/14/19 10:45 AM, Rich Shepard wrote: On Wed, 14 Aug 2019, Adrian Klaver wrote: So you have the tables in Postgres, correct? Adrian, Not yet. I have the schema extracted using mdb-schema. I did something similar with the USDA Nutrient database(with notion of making it a test dataset): h

Re: Converting Access .mdb to postgres

On Wed, 14 Aug 2019, Adrian Klaver wrote: So you have the tables in Postgres, correct? Adrian, Not yet. I have the schema extracted using mdb-schema. I did something similar with the USDA Nutrient database(with notion of making it a test dataset): https://ndb.nal.usda.gov/ndb/doc/index Th

Re: Converting Access .mdb to postgres

On 8/14/19 10:09 AM, Rich Shepard wrote: 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 he