Thread: Software that can automatically make sense of a DB's tables and IDnames
People, I haven't really been keeping up with what is happening in the PG world - now I have an old Discourse DB that I want to extract some of the categories and topics from to insert into the current setup. What I was wondering is if anyone has developed software in recent years that can look at the DB as a whole and automatically make sense of how all the tables relate to each other - assuming a sensible naming convention has been used for IDs etc - and allows one to browse the tables easily without having to manually type lots of SQL statements. Discourse now has a utility for exporting and importing to do this sort of stuff but I don't have a running setup for the old data - just a data dump . . Thanks, Phil. -- Philip Rhoades PO Box 896 Cowra NSW 2794 Australia E-mail: phil@pricom.com.au
Re: Software that can automatically make sense of a DB's tables andID names
From
Adrian Klaver
Date:
On 06/12/2018 10:14 AM, Philip Rhoades wrote: > People, > > I haven't really been keeping up with what is happening in the PG world > - now I have an old Discourse DB that I want to extract some of the > categories and topics from to insert into the current setup. What I was > wondering is if anyone has developed software in recent years that can > look at the DB as a whole and automatically make sense of how all the > tables relate to each other - assuming a sensible naming convention has > been used for IDs etc - and allows one to browse the tables easily > without having to manually type lots of SQL statements. There are but the paragraph below seems to indicate you want something else. > > Discourse now has a utility for exporting and importing to do this sort > of stuff but I don't have a running setup for the old data - just a data > dump . . So you want a tool to look at a data dump and build SQL? > > Thanks, > > Phil. -- Adrian Klaver adrian.klaver@aklaver.com