1SQLT-DUMPER(1)        User Contributed Perl Documentation       SQLT-DUMPER(1)
2
3
4

NAME

6       sqlt-dumper - create a dumper script from a schema
7

SYNOPSIS

9         sqlt-dumper -d Oracle [options] schema.sql > dumper.pl
10
11         ./dumper.pl > data.sql
12
13         Options:
14
15           -h|--help         Show help and exit
16           --skip=t1[,t2]    Skip tables in comma-separated list
17           --skiplike=regex  Skip tables matching the regular expression
18           -u|--user         Database username
19           -p|--password     Database password
20           --dsn             DSN for DBI
21

DESCRIPTION

23       This script uses SQL::Translator to parse the SQL schema and create a
24       Perl script that can connect to the database and dump the data as
25       INSERT statements (a la mysqldump) or MySQL's LOAD FILE syntax.  You
26       may specify tables to "skip" (also using a "skiplike" regular
27       expression) and the generated dumper script will not have those tables.
28       However, these will also be options in the generated dumper, so you can
29       wait to specify these options when you dump your database.  The
30       database username, password, and DSN can be hardcoded into the
31       generated script, or part of the DSN can be intuited from the
32       "database" argument.
33

AUTHOR

35       Ken Youens-Clark <kclark@cpan.org>.
36

SEE ALSO

38       perl, SQL::Translator, SQL::Translator::Producer::Dumper.
39
40
41
42perl v5.36.0                      2023-02-27                    SQLT-DUMPER(1)