Could someone explain the concept of Migrators (specifically fluentmigrator)? Here are the (possibly confused) facts Ive gleaned on the subject: Is it a way to initially create then maintain upd...

I'm using EF 5.0 and I would like to start using Code-based migrations I've used fluent migrator and there is a concept of migration order. Migrations can be migrated/rollback no matter the databa...

Is it possible to create a filtered index with FluentMigrator? The scenario is that I want to create a unique index on a column that may contain NULLs, so the filter should exclude rows with NULL f...

Calling FluentMigrator's builder methods while inside the action that I pass to Execute.WithConnection causes a null reference exception to be thrown. What I am trying to do is select some data so...

Are there any tutorials or example code for executing FluentMigrator migrations from within code? Some "Getting Started..." tutorial would be just awesome. All I was able to find was FluentMi...

Does the current iteration of fluentmigrator work with SQL Server 2012? Its not listed under the supported databases.

I am using fluentmigrator to add a new column to a table. I then want to update each row in the table with a unique value for that column. Currently when I use: Update.Table("Foo").InSchema("dbo"...

Is it possible to create a trigger with FluentMigrator, without resorting to raw SQL? I have looked through the object model for the version currently released on Nuget (FluentMigrator.1.0.1.0) an...

I am trying to use the ROWVERSION (or TIMESTAMP) datatype on a SQL Server table for optimistic concurrency control. My table is setup using FluentMigrator and I do not know how to get the datatype...

I'm using fluent migrator to manage my database migrations, but what I'd like to do is have the migrations run at app start. The closest I have managed is this: public static void MigrateToLatest(...

I have a data-centered application with SQL Server. The environments in which it´ll be deployed are not under our control and there´s no DBA in there (they are all small businesses) so we need the ...

In a FluentMigrator migration, if I'm defining a relationship, say: Create.Table("RelatedTable") .WithColumn("RelatedTableId").AsGuid().PrimaryKey() .WithColumn("MainTableId").AsGuid().NotNullab...

I am attempting to get migrations working with my project using fluent migrator. But due to the lack of documentation I am struggling to figure out how to rollback and have the Down method called f...

In fluentMigrator, is it possible to set a column default to a function? Specifically, I'm adding a uniqueidentifier (Guid) column to a SQL Server 2008 table that already contains data, and it's ...