GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Man Pages
SQLT-DUMPER(1) User Contributed Perl Documentation SQLT-DUMPER(1)

sqlt-dumper - create a dumper script from a schema

  sqlt-dumper -d Oracle [options] schema.sql > dumper.pl

  ./dumper.pl > data.sql

  Options:

    -h|--help         Show help and exit
    --skip=t1[,t2]    Skip tables in comma-separated list
    --skiplike=regex  Skip tables matching the regular expression
    -u|--user         Database username
    -p|--password     Database password
    --dsn             DSN for DBI

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

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

perl, SQL::Translator, SQL::Translator::Producer::Dumper.
2020-09-14 perl v5.32.1

Search for    or go to Top of page |  Section 1 |  Main Index

Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with ManDoc.