TeX - LaTeX Stack Exchange is a question and answer site for users of TeX, LaTeX, ConTeXt, and related typesetting systems. It only takes a minute to sign up.
Sign up to join this community
I am looking for a database documentation software where I want to incorporate the output in LaTeX. I want to show the table structures, primary keys and other related information.
I found pst-dbicons (http://www.ctan.org/tex-archive/graphics/pstricks/contrib/pst-dbicons) at CTAN. I will forced to use this if I don't find an alternative. But I am not exactly looking for an ER diagram software.
Based on the comments and web search, eventually I came up with a working framework for my purpose which might be useful for others.
Export tab, quick export method, format SQL. Click Go. Your schema will be save as a SQL file.sqlt-graph <sql file name>
sqlt-graph (http://search.cpan.org/dist/SQL-Translator/script/sqlt-graph). One specific example command could be,sqlt-graph --show-datatypes -l dot -n record -f MySQL -t png --graphattr center,margin="0.0,0.0",overlap=false,sep=10,size="20.0,14,0",orientation=landscape --nodeattr fontsize=24,fontname=Helvetica --edgeattr weight=0.05,len=2.0 -o output.png input.sql
This produces a .png file which can be used in LaTeX or anywhere else.
When included in LaTeX, the output looks something like this (partially smudged out to preserve confidentiality).
-t ps or -t svg instead of -t png.