##connect to the feed database and then run query to find tables my $from_feed_host="production-feed.czdsk6vbk.us-west-2.rds.amazonaws.com"; my $from_feed_dsn = "DBI:mysql:database=$dbrow;host=$from_feed_host"; #my $from_feed_dsn = "DBI:mysql:host=$from_feed_host"; my $from_feed_user="root"; my $from_feed_pass="sewetrol"; my $dbh2 = DBI->connect( $from_feed_dsn, $from_feed_user, $from_feed_pass, { RaiseError => 1, PrintError => 1 }) or die ( "Couldn't connect to database: " . DBI-$ ##Connect to the test feed02 database instance and insert data in staging my $destination_host="staging-feed02.czrdsk.us-west-2.rds.amazonaws.com"; my $destination_dsn = "DBI:mysql:database=$dbrow;host=$destination_host"; my $destination_user="root"; my $destination_pass="S3w3l^16"; my $dbh3 = DBI->connect( $from_feed_dsn, $from_feed_user, $from_feed_pass, {RaiseError => 1, PrintError => 1 }) or die ( "Couldn't connect to database