I am trying to use FluentMigrator with PostgreSQL.
I have it running the migrations successfully, however the VersionInfo
table is always in the public
schema. I read on the FluentMigrator Wiki that I could override the schema name, but it is not working.
Here is my class that I wrote to override the settings:
namespace YARA.Migrations
{
using FluentMigrator.VersionTableInfo;
[VersionTableMetaData]
public class YaraVersionTable : DefaultVersionTableMetaData
{
public override string SchemaName
{
get { return "dbo"; }
}
public override string TableName
{
get
{
return "MigrationInfo";
}
}
}
}
And here is a screenshot of the db after running the migrations; with neither the schema or changing the table name taking effect for the VersionInfo table.
Thoughts?