We have a system created by Parallels that relies on huge (800+) tables to support everything.
I need to study this system in order to be able to write queries to extract data to generate reports on various needs.
I obviously have difficulty isolating which tables are currently relevant for the task, so I thought the best way would be to create and print ERD on several pages for the whole table system.
I tried to drag all the tables using TOAD - which crashed :) In the second attempt, I dragged the AN tables after the successful (long) MZ tables.
I even managed to resize them, arrange and save the ERD to a file.
However, when I enter print or print preview, the print subprocess prints hehe.
Any suggestions on how to print this massive ERD? or maybe another method? The names of the tables do not seem to be taken for granted, so I cannot (and honestly do not really want to) sort through more than 800 tables, and I hope that I will not miss what I need or parts.
I would really appreciate any advice or ideas on how to proceed before I even start writing scripts and code.
The database is on mySQL under CentOS, some tables are InnoDB, some of them are MyISAM. Many tables have foreign keys.
Thank!
source
share