Changes for version 0.006
- let you dump fixtures from an unversioned DB, but warn about it.
- FAQ entry about this
Documentation
commandline tool to create and manage your migrations
Answers to Frequently Asked Questions
Features of DBIx::Class::Migration
How to use DBIx::Class::Migration
Add MySQL migration
Using a web framework
Final thoughts
Prepare your first Migration
Upgrade the Database
Bootstrap your project files
Test Your Database
A more advanced database change
Modules
Use your DB Sandbox to run Catalyst
Use the best tools together for sane database migrations
Autocreate a mysql sandbox
Utility to populate fixture data
Autocreate a postgresql sandbox
Control your Perl Migration Run Scripts
Give your Run Script a Schema
DB Sandbox Role
Schema Loader Factory
Tools to manage database Migrations
Build a target_dir in /share
Autocreate a Sqlite sandbox
Build a sandbox at target_dir
Build a tempory target_dir
Build a sandbox in a temporary directory
Use your fixtures in a test case.
Examples
- examples/MusicBase/app.psgi
- examples/MusicBase/bin/my-dbic-migration
- examples/MusicBase/dist.ini
- examples/MusicBase/lib/MusicBase/Schema.pm
- examples/MusicBase/lib/MusicBase/Schema/MigrationScript.pm
- examples/MusicBase/lib/MusicBase/Schema/Result/Artist.pm
- examples/MusicBase/lib/MusicBase/Schema/Result/ArtistCd.pm
- examples/MusicBase/lib/MusicBase/Schema/Result/Cd.pm
- examples/MusicBase/lib/MusicBase/Schema/Result/Country.pm
- examples/MusicBase/lib/MusicBase/Schema/Result/Track.pm
- examples/MusicBase/lib/MusicBase/Schema/ResultSet/Artist.pm
- examples/MusicBase/lib/MusicBase/Web.pm
- examples/MusicBase/lib/MusicBase/Web/Controller/Root.pm
- examples/MusicBase/lib/MusicBase/Web/Model/Schema.pm
- examples/MusicBase/lib/MusicBase/Web/View/HTML.pm
- examples/MusicBase/share/etc/musicbase_web.pl
- examples/MusicBase/share/etc/musicbase_web_test.pl
- examples/MusicBase/share/fixtures/1/all_tables/_dumper_version
- examples/MusicBase/share/fixtures/1/all_tables/artist/1.fix
- examples/MusicBase/share/fixtures/1/all_tables/artist/2.fix
- examples/MusicBase/share/fixtures/1/all_tables/cd/1.fix
- examples/MusicBase/share/fixtures/1/all_tables/cd/2.fix
- examples/MusicBase/share/fixtures/1/all_tables/cd/3.fix
- examples/MusicBase/share/fixtures/1/all_tables/track/1.fix
- examples/MusicBase/share/fixtures/1/all_tables/track/2.fix
- examples/MusicBase/share/fixtures/1/all_tables/track/3.fix
- examples/MusicBase/share/fixtures/1/all_tables/track/4.fix
- examples/MusicBase/share/fixtures/1/all_tables/track/5.fix
- examples/MusicBase/share/fixtures/1/all_tables/track/6.fix
- examples/MusicBase/share/fixtures/1/all_tables/track/7.fix
- examples/MusicBase/share/fixtures/1/conf/all_tables.json
- examples/MusicBase/share/fixtures/2/all_tables/_dumper_version
- examples/MusicBase/share/fixtures/2/all_tables/artist/1.fix
- examples/MusicBase/share/fixtures/2/all_tables/artist/2.fix
- examples/MusicBase/share/fixtures/2/all_tables/cd/1.fix
- examples/MusicBase/share/fixtures/2/all_tables/cd/2.fix
- examples/MusicBase/share/fixtures/2/all_tables/cd/3.fix
- examples/MusicBase/share/fixtures/2/all_tables/country/1.fix
- examples/MusicBase/share/fixtures/2/all_tables/country/2.fix
- examples/MusicBase/share/fixtures/2/all_tables/country/3.fix
- examples/MusicBase/share/fixtures/2/all_tables/track/1.fix
- examples/MusicBase/share/fixtures/2/all_tables/track/2.fix
- examples/MusicBase/share/fixtures/2/all_tables/track/3.fix
- examples/MusicBase/share/fixtures/2/all_tables/track/4.fix
- examples/MusicBase/share/fixtures/2/all_tables/track/5.fix
- examples/MusicBase/share/fixtures/2/all_tables/track/6.fix
- examples/MusicBase/share/fixtures/2/all_tables/track/7.fix
- examples/MusicBase/share/fixtures/2/conf/all_tables.json
- examples/MusicBase/share/fixtures/2/conf/countries.json
- examples/MusicBase/share/fixtures/2/countries/_dumper_version
- examples/MusicBase/share/fixtures/2/countries/country/1.fix
- examples/MusicBase/share/fixtures/2/countries/country/2.fix
- examples/MusicBase/share/fixtures/2/countries/country/3.fix
- examples/MusicBase/share/fixtures/3/all_tables/_dumper_version
- examples/MusicBase/share/fixtures/3/all_tables/artist/1.fix
- examples/MusicBase/share/fixtures/3/all_tables/artist/2.fix
- examples/MusicBase/share/fixtures/3/all_tables/artist/3.fix
- examples/MusicBase/share/fixtures/3/all_tables/artist_cd/1-1.fix
- examples/MusicBase/share/fixtures/3/all_tables/artist_cd/1-2.fix
- examples/MusicBase/share/fixtures/3/all_tables/artist_cd/2-3.fix
- examples/MusicBase/share/fixtures/3/all_tables/artist_cd/3-4.fix
- examples/MusicBase/share/fixtures/3/all_tables/cd/1.fix
- examples/MusicBase/share/fixtures/3/all_tables/cd/2.fix
- examples/MusicBase/share/fixtures/3/all_tables/cd/3.fix
- examples/MusicBase/share/fixtures/3/all_tables/cd/4.fix
- examples/MusicBase/share/fixtures/3/all_tables/country/1.fix
- examples/MusicBase/share/fixtures/3/all_tables/country/2.fix
- examples/MusicBase/share/fixtures/3/all_tables/country/3.fix
- examples/MusicBase/share/fixtures/3/all_tables/country/4.fix
- examples/MusicBase/share/fixtures/3/all_tables/country/5.fix
- examples/MusicBase/share/fixtures/3/all_tables/country/6.fix
- examples/MusicBase/share/fixtures/3/all_tables/track/1.fix
- examples/MusicBase/share/fixtures/3/all_tables/track/2.fix
- examples/MusicBase/share/fixtures/3/all_tables/track/3.fix
- examples/MusicBase/share/fixtures/3/all_tables/track/4.fix
- examples/MusicBase/share/fixtures/3/all_tables/track/5.fix
- examples/MusicBase/share/fixtures/3/all_tables/track/6.fix
- examples/MusicBase/share/fixtures/3/all_tables/track/7.fix
- examples/MusicBase/share/fixtures/3/conf/all_tables.json
- examples/MusicBase/share/fixtures/3/conf/countries.json
- examples/MusicBase/share/fixtures/3/countries/_dumper_version
- examples/MusicBase/share/fixtures/3/countries/country/1.fix
- examples/MusicBase/share/fixtures/3/countries/country/2.fix
- examples/MusicBase/share/fixtures/3/countries/country/3.fix
- examples/MusicBase/share/fixtures/3/countries/country/4.fix
- examples/MusicBase/share/fixtures/3/countries/country/5.fix
- examples/MusicBase/share/fixtures/3/countries/country/6.fix
- examples/MusicBase/share/html/index.tt
- examples/MusicBase/share/migrations/MySQL/deploy/3/001-auto-__VERSION.sql
- examples/MusicBase/share/migrations/MySQL/deploy/3/001-auto.sql
- examples/MusicBase/share/migrations/SQLite/deploy/1/001-auto-__VERSION.sql
- examples/MusicBase/share/migrations/SQLite/deploy/1/001-auto.sql
- examples/MusicBase/share/migrations/SQLite/deploy/2/001-auto-__VERSION.sql
- examples/MusicBase/share/migrations/SQLite/deploy/2/001-auto.sql
- examples/MusicBase/share/migrations/SQLite/deploy/3/001-auto-__VERSION.sql
- examples/MusicBase/share/migrations/SQLite/deploy/3/001-auto.sql
- examples/MusicBase/share/migrations/SQLite/downgrade/2-1/001-auto.sql
- examples/MusicBase/share/migrations/SQLite/downgrade/3-2/001-auto.sql
- examples/MusicBase/share/migrations/SQLite/upgrade/1-2/001-add_country.sql
- examples/MusicBase/share/migrations/SQLite/upgrade/1-2/003-change_artist.sql
- examples/MusicBase/share/migrations/SQLite/upgrade/2-3/001-create_artist_cd.sql
- examples/MusicBase/share/migrations/SQLite/upgrade/2-3/002-populate_artist_cd.sql
- examples/MusicBase/share/migrations/SQLite/upgrade/2-3/003-alter_cd.sql
- examples/MusicBase/share/migrations/SQLite/upgrade/2-3/004-alter_country.sql
- examples/MusicBase/share/migrations/SQLite/upgrade/2-3/005-new_countries.pl
- examples/MusicBase/share/migrations/SQLite/upgrade/2-3/006-new_artist.pl
- examples/MusicBase/share/migrations/_common/deploy/1/002-demo.pl
- examples/MusicBase/share/migrations/_common/upgrade/1-2/002-insert_countries.pl
- examples/MusicBase/share/migrations/_source/deploy/1/001-auto-__VERSION.yml
- examples/MusicBase/share/migrations/_source/deploy/1/001-auto.yml
- examples/MusicBase/share/migrations/_source/deploy/2/001-auto-__VERSION.yml
- examples/MusicBase/share/migrations/_source/deploy/2/001-auto.yml
- examples/MusicBase/share/migrations/_source/deploy/3/001-auto-__VERSION.yml
- examples/MusicBase/share/migrations/_source/deploy/3/001-auto.yml
- examples/MusicBase/share/musicbase-schema/bin/start
- examples/MusicBase/share/musicbase-schema/bin/stop
- examples/MusicBase/share/musicbase-schema/bin/use
- examples/MusicBase/share/musicbase-schema/etc/my.cnf
- examples/MusicBase/share/musicbase-schema/tmp/mysqld.log
- examples/MusicBase/share/musicbase-schema/var/ib_logfile0
- examples/MusicBase/share/musicbase-schema/var/ib_logfile1
- examples/MusicBase/share/musicbase-schema/var/ibdata1
- examples/MusicBase/share/musicbase-schema/var/mysql/columns_priv.MYD
- examples/MusicBase/share/musicbase-schema/var/mysql/columns_priv.MYI
- examples/MusicBase/share/musicbase-schema/var/mysql/columns_priv.frm
- examples/MusicBase/share/musicbase-schema/var/mysql/db.MYD
- examples/MusicBase/share/musicbase-schema/var/mysql/db.MYI
- examples/MusicBase/share/musicbase-schema/var/mysql/db.frm
- examples/MusicBase/share/musicbase-schema/var/mysql/event.MYD
- examples/MusicBase/share/musicbase-schema/var/mysql/event.MYI
- examples/MusicBase/share/musicbase-schema/var/mysql/event.frm
- examples/MusicBase/share/musicbase-schema/var/mysql/func.MYD
- examples/MusicBase/share/musicbase-schema/var/mysql/func.MYI
- examples/MusicBase/share/musicbase-schema/var/mysql/func.frm
- examples/MusicBase/share/musicbase-schema/var/mysql/general_log.CSM
- examples/MusicBase/share/musicbase-schema/var/mysql/general_log.CSV
- examples/MusicBase/share/musicbase-schema/var/mysql/general_log.frm
- examples/MusicBase/share/musicbase-schema/var/mysql/help_category.MYD
- examples/MusicBase/share/musicbase-schema/var/mysql/help_category.MYI
- examples/MusicBase/share/musicbase-schema/var/mysql/help_category.frm
- examples/MusicBase/share/musicbase-schema/var/mysql/help_keyword.MYD
- examples/MusicBase/share/musicbase-schema/var/mysql/help_keyword.MYI
- examples/MusicBase/share/musicbase-schema/var/mysql/help_keyword.frm
- examples/MusicBase/share/musicbase-schema/var/mysql/help_relation.MYD
- examples/MusicBase/share/musicbase-schema/var/mysql/help_relation.MYI
- examples/MusicBase/share/musicbase-schema/var/mysql/help_relation.frm
- examples/MusicBase/share/musicbase-schema/var/mysql/help_topic.MYD
- examples/MusicBase/share/musicbase-schema/var/mysql/help_topic.MYI
- examples/MusicBase/share/musicbase-schema/var/mysql/help_topic.frm
- examples/MusicBase/share/musicbase-schema/var/mysql/host.MYD
- examples/MusicBase/share/musicbase-schema/var/mysql/host.MYI
- examples/MusicBase/share/musicbase-schema/var/mysql/host.frm
- examples/MusicBase/share/musicbase-schema/var/mysql/ndb_binlog_index.MYD
- examples/MusicBase/share/musicbase-schema/var/mysql/ndb_binlog_index.MYI
- examples/MusicBase/share/musicbase-schema/var/mysql/ndb_binlog_index.frm
- examples/MusicBase/share/musicbase-schema/var/mysql/plugin.MYD
- examples/MusicBase/share/musicbase-schema/var/mysql/plugin.MYI
- examples/MusicBase/share/musicbase-schema/var/mysql/plugin.frm
- examples/MusicBase/share/musicbase-schema/var/mysql/proc.MYD
- examples/MusicBase/share/musicbase-schema/var/mysql/proc.MYI
- examples/MusicBase/share/musicbase-schema/var/mysql/proc.frm
- examples/MusicBase/share/musicbase-schema/var/mysql/procs_priv.MYD
- examples/MusicBase/share/musicbase-schema/var/mysql/procs_priv.MYI
- examples/MusicBase/share/musicbase-schema/var/mysql/procs_priv.frm
- examples/MusicBase/share/musicbase-schema/var/mysql/servers.MYD
- examples/MusicBase/share/musicbase-schema/var/mysql/servers.MYI
- examples/MusicBase/share/musicbase-schema/var/mysql/servers.frm
- examples/MusicBase/share/musicbase-schema/var/mysql/slow_log.CSM
- examples/MusicBase/share/musicbase-schema/var/mysql/slow_log.CSV
- examples/MusicBase/share/musicbase-schema/var/mysql/slow_log.frm
- examples/MusicBase/share/musicbase-schema/var/mysql/tables_priv.MYD
- examples/MusicBase/share/musicbase-schema/var/mysql/tables_priv.MYI
- examples/MusicBase/share/musicbase-schema/var/mysql/tables_priv.frm
- examples/MusicBase/share/musicbase-schema/var/mysql/time_zone.MYD
- examples/MusicBase/share/musicbase-schema/var/mysql/time_zone.MYI
- examples/MusicBase/share/musicbase-schema/var/mysql/time_zone.frm
- examples/MusicBase/share/musicbase-schema/var/mysql/time_zone_leap_second.MYD
- examples/MusicBase/share/musicbase-schema/var/mysql/time_zone_leap_second.MYI
- examples/MusicBase/share/musicbase-schema/var/mysql/time_zone_leap_second.frm
- examples/MusicBase/share/musicbase-schema/var/mysql/time_zone_name.MYD
- examples/MusicBase/share/musicbase-schema/var/mysql/time_zone_name.MYI
- examples/MusicBase/share/musicbase-schema/var/mysql/time_zone_name.frm
- examples/MusicBase/share/musicbase-schema/var/mysql/time_zone_transition.MYD
- examples/MusicBase/share/musicbase-schema/var/mysql/time_zone_transition.MYI
- examples/MusicBase/share/musicbase-schema/var/mysql/time_zone_transition.frm
- examples/MusicBase/share/musicbase-schema/var/mysql/time_zone_transition_type.MYD
- examples/MusicBase/share/musicbase-schema/var/mysql/time_zone_transition_type.MYI
- examples/MusicBase/share/musicbase-schema/var/mysql/time_zone_transition_type.frm
- examples/MusicBase/share/musicbase-schema/var/mysql/user.MYD
- examples/MusicBase/share/musicbase-schema/var/mysql/user.MYI
- examples/MusicBase/share/musicbase-schema/var/mysql/user.frm
- examples/MusicBase/share/musicbase-schema/var/test/artist.frm
- examples/MusicBase/share/musicbase-schema/var/test/artist_cd.frm
- examples/MusicBase/share/musicbase-schema/var/test/cd.frm
- examples/MusicBase/share/musicbase-schema/var/test/country.frm
- examples/MusicBase/share/musicbase-schema/var/test/dbix_class_deploymenthandler_versions.MYD
- examples/MusicBase/share/musicbase-schema/var/test/dbix_class_deploymenthandler_versions.MYI
- examples/MusicBase/share/musicbase-schema/var/test/dbix_class_deploymenthandler_versions.frm
- examples/MusicBase/share/musicbase-schema/var/test/track.frm
- examples/MusicBase/t/more-than-1.t
- examples/MusicBase/t/upgrade-1to2.t
- examples/MusicBase/t/upgrade-2to3.t
- examples/MusicBase/t/use.t
- examples/MusicBase/t/web.t