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 --add-truncate Add "TRUNCATE TABLE" statements for each table --skip=t1[,t2] Skip tables in comma-separated list -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. If you enable "add-truncate" or specify tables to "skip," then the generated dumper script will have those hardcoded. 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 Y. Clark <kclark@cpan.org>.
perl, SQL::Translator.
To install SQL::Translator, copy and paste the appropriate command in to your terminal.
cpanm
cpanm SQL::Translator
CPAN shell
perl -MCPAN -e shell install SQL::Translator
For more information on module installation, please visit the detailed CPAN module installation guide.