SQLT(1)

🌈 SQLT(1) — sqlt: convert SQL schema using SQL::Translator 💅

You're reading the SQLT(1) page from User Contributed Perl Documentation, bestie. It's giving “Perl manual, but make it cute.” 🫶

💖 NAME 💖

sqlt — convert SQL schema using SQL::Translator.

✨ SYNOPSIS ✨

Need help? Run:

  sqlt -h|--help

Wanna see every parser and producer? Run:

  sqlt -l|--list

To translate a schema, run:

  sqlt -f|--from|--parser MySQL
       -t|--to|--producer Oracle
       [options]
       file [file2 ...]

🎀 General Options 🎀

• -d, --debug — prints debug info.
• -v, --validate — validates the schema.
• --version — shows the version of SQL::Translator.
• --trace — prints parser trace info.
• --show-warnings — prints warnings to STDERR.

🎀 General Parser Options 🎀

• --skip — comma-separated list of tables to skip (only implemented in some parsers).
• --ignore_opts — comma-separated list of table options to ignore.

🎀 DBI Parser Options 🎀

• --dsn — DSN for connecting to the database (see also --use-same-auth below).
• --db-user — database user.
• --db-password — database password.

🎀 xSV Parser Options 🎀

• --fs — the field separator.
• --rs — the record separator.
• --no-trim — don't trim whitespace on fields.
• --no-scan — don't scan fields for data types and sizes.

🎀 MySQL Parser Options 🎀

• --mysql-parser-version — target MySQL parser version for dealing with /*! comments; default = 30000.

🎀 MySQL Producer Options 🎀

• --mysql-version — MySQL server version.

🎀 General Producer Options 🎀

• --producer-db-user — database user for producer.
• --producer-db-pass — database password for producer.
• --producer-dsn — DSN for producer.
• --use-same-auth — use these DSN, user, password for producer output.

🎀 DB Producer Options 🎀

• --add-drop-table — add 'DROP TABLE' statements before creates.
• --quote-table-names — quote all table names in statements.
• --quote-field-names — quote all field names in statements.
• --no-comments — don't include comments in SQL output.

🎀 PostgreSQL Producer Options 🎀

• --postgres-version — PostgreSQL server version.

🎀 Diagram Producer Options 🎀

• --imap-file — filename to put image map data.
• --imap-url — URL to use for image map.

🎀 Dumper Producer Options 🎀

• --skip — comma-separated list of tables to skip.
• --skiplike — regex for tables to skip.
• --add-truncate — add "TRUNCATE TABLE" statements for each table.

🎀 HTML/POD Producer Options 🎀

• --pretty — use CGI::Pretty for the output.
• --title — title of schema.

🎀 TTSchema Producer Options 🎀

• --template — the path to the template.
• --tt-var var=value — pass extra variables to the template.
• --tt-conf option=value — pass extra config options to Template.

🎀 XML-SQLFairy Producer Options 🎀

• --add-prefix — use an explicit namespace prefix of 'sqlf:'.
• --prefix=<p> — use the namespace prefix given as argument.
• --no-newlines — write the XML as a single line.
• --indent=<n> — use <n> characters of whitespace to indent the XML.

🎀 ClassDBI Producer Options 🎀

• --package — base package name for Class::DBI modules.

🦋 DESCRIPTION 🦋

This script is part of the SQL Fairy project. It will try to convert any source file it has a grammar for into any format it has a producer for. Slay ✨

If you're using --show-warnings, be sure to redirect STDERR to a separate file, okay? No chaos in the main output, bestie.

In bash, you could do this:

$ sql_translator.pl -f MySQL -t PostgreSQL --show-warnings \
              file.sql 1>out 2>err

You can specify a parser or producer located in any module that Perl knows about, which lets you easily substitute your own. Iconic behavior, honestly 👑

🌸 AUTHOR 🌸

Ken Youens-Clark <kclark@cpan.org>, darren chamberlain <darren@cpan.org>.

🎀 SEE ALSO 🎀

SQL::Translator, <http://sqlfairy.sourceforge.net>.

---

And that's the footer tea, bestie: perl v5.42.0, 2024-12-12 💖🦋