NAME

sql_loader_example.pl

SYNOPSIS

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

Arguments:

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

DESCRIPTION

screen scrape db schema from intranet and create sql to load into db.

SEE ALSO

SQL::Loader