Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
SQLT-DUMPER(1)	      User Contributed Perl Documentation	SQLT-DUMPER(1)

NAME
       sqlt-dumper - create a dumper script from a schema

SYNOPSIS
	 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

DESCRIPTION
       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.

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

SEE ALSO
       perl, SQL::Translator, SQL::Translator::Producer::Dumper.

perl v5.24.1			  2014-11-24			SQLT-DUMPER(1)

NAME | SYNOPSIS | DESCRIPTION | AUTHOR | SEE ALSO

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=sqlt-dumper&sektion=1&manpath=FreeBSD+12.0-RELEASE+and+Ports>

home | help