# vim: set ft=perl:
# -------------------------------------------------------------------
-# $Id: sqlt,v 1.22 2007-03-21 15:21:31 duality72 Exp $
+# $Id: sqlt 1440 2009-01-17 16:31:57Z jawnsy $
# -------------------------------------------------------------------
-# Copyright (C) 2002-4 SQLFairy Authors
+# Copyright (C) 2002-2009 SQLFairy Authors
#
# This program is free software; you can redistribute it and/or
# modify it under the terms of the GNU General Public License as
--trace Print parser trace info
--show-warnings Print warnings to STDERR
+ General Parser Options:
+
+ --skip Comma-separated list of tables to skip (only implemented in some parsers)
+ --ignore_opts Comma-separated list of table options to ignore
+
DBI Parser Options:
--dsn DSN for connecting to database
--mysql-parser-version Target MySQL parser version for dealing with
/*! comments; default = 30000
+ MySQL Producer Options:
+
+ --mysql-version MySQL server version
+
General Producer Options
--producer-db-user Database user for producer
use Pod::Usage;
use SQL::Translator;
-use vars qw( $VERSION );
-$VERSION = sprintf "%d.%02d", q$Revision: 1.22 $ =~ /(\d+)\.(\d+)/;
-
my $from; # the original database
my $to; # the destination database
my $help; # show POD and bail
my $show_version; # Show version and exit script
my $skip;
my $skiplike;
+my $ignore_opts;
my $producer_db_user; # DSN for producer (e.g. Dumper, ClassDBI)
my $producer_db_password; # db_pass "
my $producer_dsn; # db_user "
my $add_truncate;
my $mysql_parser_version; # MySQL parser arg for /*! comments
my $postgres_version; # PostgreSQL version
+my $mysql_version; # MySQL version
GetOptions(
'add-drop-table' => \$add_drop_table,
'producer-db-pass:s'=> \$producer_db_password,
'skip:s' => \$skip,
'skiplike:s' => \$skiplike,
+ 'ignore_opts:s' => \$ignore_opts,
'add_truncate' => \$add_truncate,
'add-prefix' => \$add_prefix,
'prefix:s' => \$prefix,
'version' => \$show_version,
'mysql-parser-version=i' => \$mysql_parser_version,
'postgres-version=f' => \$postgres_version,
+ 'mysql-version=f' => \$mysql_version,
) or pod2usage(2);
if ($use_same_auth) {
db_user => $db_user,
db_password => $db_password,
mysql_parser_version => $mysql_parser_version,
+ skip => $skip,
+ ignore_opts => $ignore_opts,
},
producer_args => {
imap_file => $imap_file,
indent => $indent,
newlines => $newlines,
postgres_version => $postgres_version,
+ mysql_version => $mysql_version,
package_name => $package_name,
},
);