sql_loader_example.pl
perl sql_loader_example.pl --url=<schema url> --dbname=<dbname> --dbuser=<dbuser> --dbpass=<dbpass> [ --quiet ]
perl sql_loader_example.pl --url=<schema url> --print_http_headers
perl sql_loader_example.pl --help
- Pass the url to use to scrape db schema from with --url flag. - specify dbname with --dbname - specify dbuser with --dbuser - specify dbpass with --dbpass - show this screen and exit with --help - Test server response by requesting headers only with --print_http_headers flag ( does not rebuild db ) - do not print any informational messages with --quiet option
The database specified by dbname must already exist and note that this script DROPS all existing tables found, as it is assumed if you are running this script you are either creating a new db for first time or you are rebuilding your db for testing/development purposes.
screen scrape db schema from intranet and create sql to load into db.
SQL::Loader
To install SQL::Loader, copy and paste the appropriate command in to your terminal.
cpanm
cpanm SQL::Loader
CPAN shell
perl -MCPAN -e shell install SQL::Loader
For more information on module installation, please visit the detailed CPAN module installation guide.