SQLT(1p)

📦
version 1.66 · 4 versions
, in debian trixie, ubuntu resolute, ubuntu stonking

✨ NAME ✨

okay so bestie, this is SQLT(1p) — the User Contributed Perl Documentation page for sqlt, and it does literally one iconic thing: convert SQL schema using SQL::Translator 💅✨

🦋 SYNOPSIS 🦋

ngl the vibes here are "here's how you talk to me." For help:

sqlt -h|--help

For a list of all parsers and producers (the full roster, the whole cast 👑):

sqlt -l|--list

To translate a schema (the main character move):

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

🌸 General Options

  • -d, --debug — print debug info 🐛
  • -v, --validate — validate the schema ✅
  • --version — show the version of SQL::Translator
  • --trace — print parser trace info 🔍
  • --show-warnings — print warnings to STDERR 🗣️

🌸 General Parser Options

  • --skip — comma-separated list of tables to skip (only implemented in some parsers, so don't come for me if your fave doesn't do it 🙈)
  • --ignore_opts — comma-separated list of table options to ignore

🌸 DBI Parser Options

  • --dsn — DSN for connecting to 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 💀 (yes it's giving destructive, that's the point)
  • --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 💅

so this script? it's part of the SQL Fairy project 🧚✨ And what it does is genuinely so slay: it will try to convert any source file for which it has a grammar into any format for which it has a producer. Like. Any to any. No cap.

⚠️ If you're using "show-warnings," be sure to redirect STDERR to a separate file — do not skip this bestie, the warnings will absolutely jump into your output otherwise 😭

In bash, you could do this:

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

And the real flex: you can specify a parser or producer located in any module that Perl knows about, which means you can easily substitute your own 🫶 your own little custom parser, your own producer, iconic behavior honestly.

👑 AUTHOR 👑

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

🌈 SEE ALSO 🌈

and that's the whole page bestie!! 🎀 this was written up for perl v5.40.0, dated 2024-11-23 — yeah it's giving vintage but it still ate 💅✨ go convert something, you've got this 🦋

📦 where this page comes from