Re: Software that can automatically make sense of a DB's tables and ID names
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.kla...@aklaver.com
Software that can automatically make sense of a DB's tables and ID names
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: p...@pricom.com.au
