GraphViz or GD), automatic code generation (using Class::DBI),
converting non-RDBMS files to SQL schemas (xSV text files, Excel
spreadsheets), serializing parsed schemas (via Storable, YAML and
-XML), creating documentation (HTML and POD), and more. New to version
-0.03 is the ability to talk directly to a database through DBI to
+XML), creating documentation (HTML and POD), and more. We also
+have the ability to talk directly to a database through DBI to
query for the structures of several databases.
Through the separation of the code into parsers and producers with an
definition parts of SQL are handled (CREATE, ALTER), not the
manipulation of data (INSERT, UPDATE, DELETE).
-As of version 0.03, parsers exist for the following:
+As of version 0.06, parsers exist for the following:
Databases:
MySQL
Oracle
PostgreSQL
- Sybase
SQLite
+ Sybase
DBI-MySQL
DBI-PostgreSQL
xSV : arbitrarily delimited text files
Excel : Microsoft Excel spreadsheets
XML-SQLFairy : SQLFairy's XML format
- YAML/Storable: Serialization of schema objects
+ YAML/Storable: Serialized schema objects
And the following producers exist:
interfaces for the actual SQL::Translator modules. In the "bin"
directory, you will find:
-* sqlt-diagram
-* sqlt-graph
-* sqlt-dumper
-* sqlt
-* sqlt.cgi
+* sqlt-diagram: interface to Diagram producer
+* sqlt-diff : diff two schemas to generate schema mutation file
+* sqlt-graph : interface to GraphViz producer
+* sqlt-dumper : create a data dumper script from a schema
+* sqlt : command-line interface for text-to-text translations
+* sqlt.cgi : CGI interface for all SQLFairy functions
All scripts not ending in ".cgi" are meant to be run from the command
line with various switches to control the input and output of the
INSTALLATION
-The regular method:
+ $ perl Build.PL
+ $ ./Build
+ $ ./Build test
+ $ su
+ # ./Build install
+
+MANUAL
+
+To read the manual:
- $ perl Makefile.PL
- $ make
- $ make test
- $ su -
- # make install
+ $ perldoc SQL::Translator::Manual
COPYRIGHT
AUTHORS
-See the include AUTHORS file.
+See the included AUTHORS file.