Sharp Migrations - not here anymore, go to github

Sharp migrations is a framework to help you deal with database changes and versioning over time. The idea comes from the excellent Ruby on Rail's migrations and it is the best way to alter your database in a structured and organised manner.

Interested? Get started!

Nuget package: install-package sharpmigrations

THIS PROJECT IS NOW HOSTED ON GITHUB:

SharpMigrations


With sharp-migrations you will be writing code like:

    public class _003_Create_table_Artist : SchemaMigration {
        
        public override void Up() {
            
            Add.Table("Artist").WithColumns(
                Column.AutoIncrement("ArtistId").AsPrimaryKey(),
                Column.String("Name", 120)
            );

            Add.ForeignKey("FK_Artist_Album")
               .OnColumn("ArtistId")
               .OfTable("Album")
               .ReferencingColumn("ArtistId")
               .OfTable("Artist")
               .OnDeleteNoAction();
        }

        public override void Down() {
            Remove.ForeignKey("FK_Artist_Album").FromTable("Album");
            Remove.Table("Artist");
        }
    }

Last edited Nov 27, 2013 at 1:38 PM by andrecarlucci, version 13