<div>
<div class="content wysiwyg-content">
Hi there,<br />
I have been given a load of .sql files, .ksh files and .ddl files which represent a database and a number of scripts that pull and manipulate data within the database.<br />
<br />
Apart from some random code comments I am struggling to understand the overall structure of the database and the function of the scripts.<br />
<br />
I was after some advice as to whether there were any tools out there that could help my by processing the files and generating an ER diagram or describing the joins etc.<br />
<br />
Any help would be much appreciated.
</div>
</div>


Hi there,
I have been given a load of .sql files, .ksh files and .ddl files which represent a database and a number of scripts that pull and manipulate data within the database.

Apart from some random code comments I am struggling to understand the overall structure of the database and the function of the scripts.

I was after some advice as to whether there were any tools out there that could help my by processing the files and generating an ER diagram or describing the joins etc.

Any help would be much appreciated.

Generating ER Diagrams and Join conditions from SQL files

The term 'shell' refers to a general class of text-based command interpreters most often associated with the UNIX and Linux operating systems. Popular shells include Bourne, Debian Almquist (dash), Korn (ksh), Bourne Again (bash) and the C shell family (csh). Some view the DOS 'cmd' prompt as a minimal shell of sorts. It is also possible to install Cygwin on Windows and emulate a full Unix environment with complete shell capabilities. Terminal emulators, such as xterm, GNOME Terminal and OS X Terminal, can be used to access shell.

Shell Scripting

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.