NAME SQL::Admin - Maintain database schemas SYNOPSIS use SQL::Admin; # Merge multiple SQL files my $catalog = SQL::Admin ->get_catalog ->load ('DB2', { file => [ 'create-schema.sql', 'update-001.sql' ] }) ->save ('Pg', { file => [ 'output.sql' ] }); # ... deploy catalog $catalog->save ('Pg::DBI', { dbdsn => ... }); # Sync SQL files and db my $src = SQL::Admin->get_catalog; ->load ('Pg::DBI', { dbdsn => ... }); my $dst = SQL::Admin->get_catalog; ->load ('Pg', { file => [ 'create-schema.sql' ] }); my $diff = SQL::Admin->compare ($src, $dst); if ($diff->is_difference) { $diff->save ('Pg'); $diff->save ('Pg::DBI', { dbdsn => ... }); } DESCRIPTION