# My::DB "isa" Rose::DB
$production_db = My::DB->new('production'); # PostgreSQL
$archive_db    = My::DB->new('archive');    # MySQL

# Load bike from production database
$p = Product->new(name => 'Bike', db => $production_db);
$p->load;

# Save the bike into the archive database
$p->db($archive_db);
$p->insert;

# Delete the bike from the production database
$p->db($production_db);
$p->delete;