schambers/fluentmigrator — Issue #244: FluentMigrator with Sql Server Compact 4.0 is non-functional
Author: chappoo
Created: 2012-02-20 23:45:30+00:00
State: open

When working with the most recent (NuGet) build of FluentMigrator, I'm unable to get migrations working against Sql Server Compact 4.0.

Having debugged in to the codebase, the problem lies within the schema object queries on creation of the VersionInfo table.

FluentMigrator.Runner.Processors.SqlServer.SqlServerCeProcessor expects a SYS.SCHEMAS table which is used to query for existing schemas - Sql Server Compact 4.0 does not support schema objects, and I fail to see how this code has ever worked. I've not checked the version history so please correct me if I'm missing something obvious. I can't see any unit tests covering the SqlServerCeProcessor class, so maybe it's a work in progress?

I'm going to commence work on a pull request - just interested to know if this is a shared observation. Keen to get it remedied.