Rechercher une page de manuel

Chercher une autre page de manuel:

sqlt.1p

Langue: en

Autres versions - même langue

Version: 2008-05-15 (ubuntu - 07/07/09)

Section: 1 (Commandes utilisateur)

NAME

sqlt - convert SQL schema using SQL::Translator

SYNOPSIS

For help:
   sqlt -h|--help
 
 

For a list of all parsers and producers:

   sqlt -l|--list
 
 

To translate a schema:

   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
 
   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
 
   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  Qjuote all field names in statements
     --no-comments      Don't include comments in SQL output
 
   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 for which it has a grammar into any format for which it has a producer.

If using ``show-warnings,'' be sure to redirect STDERR to a separate file. 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, allowing you to easily substitute your own.

AUTHOR

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

SEE ALSO

SQL::Translator, <http://sqlfairy.sourceforge.net>.
P.P.S. Une de mes photos ressemble aux siennes sauf que lui c'est un
champ labouré sous la neige vu d'avion en Italie, moi c'est les traces
de la shampooingneuse sur le sol de mon boulot vu du deuxième étage...
Pff...
-+- Fred, sur fr.rec.photo -+-