private MigSharp.Migrator CreateMigrator()
{
var providerName = DbType.ToMigSharpProvider(_database.DatabaseType);
var connection = _database.GetConnectionData();
var options = new MigrationOptions();
options.SupportedProviders.Set(providerName.AsArray());
var migrator = new MigSharp.Migrator(connection.GetConnectionString(), providerName, options);
return migrator;
}
public void Execute()
{
var connection = ConfigurationManager.ConnectionStrings["database"];
var options = new MigrationOptions();
options.SupportedProviders.Clear();
options.SupportedProviders.Add(ProviderNames.SQLite);
options.SupportedProviders.Add(ProviderNames.SqlServer2005);
options.SupportedProviders.Add(ProviderNames.SqlServer2008);
var m = new Migrator(connection.ConnectionString, connection.ProviderName, options);
m.MigrateAll(typeof(MeasuresController).Assembly);
}
/// <summary>
/// Initializes a new instance of <see cref="Migrator"/>.
/// </summary>
/// <param name="connectionString">Connection string to the database to be migrated.</param>
/// <param name="dbPlatform"></param>
/// <param name="options">Options.</param>
public Migrator(string connectionString, DbPlatform dbPlatform, MigrationOptions options)
: base(connectionString, dbPlatform, options)
{
if (connectionString == null)
{
throw new ArgumentNullException("connectionString");
}
if (dbPlatform == null)
{
throw new ArgumentNullException("dbPlatform");
}
if (options == null)
{
throw new ArgumentNullException("options");
}
_options = options;
}
/// <summary>
/// Initializes a new instance of <see cref="Migrator"/>.
/// </summary>
/// <param name="connectionString">Connection string to the database to be migrated.</param>
/// <param name="providerName">The name of the provider that should be used for this migrator (<see cref="ProviderNames"/>).</param>
/// <param name="options">Options.</param>
public Migrator(string connectionString, string providerName, MigrationOptions options)
{
if (connectionString == null)
{
throw new ArgumentNullException("connectionString");
}
if (providerName == null)
{
throw new ArgumentNullException("providerName");
}
if (options == null)
{
throw new ArgumentNullException("options");
}
_provider = options.SupportedProviders.GetProvider(providerName, out _providerMetadata);
_connectionInfo = new ConnectionInfo(connectionString, _providerMetadata.InvariantName, _providerMetadata.SupportsTransactions);
_options = options;
}
public VisualFarmMigrator()
{
_config = new VFSConfig();
_options = new MigrationOptions();
_options.SupportedProviders.Set(ProviderNames.SqlServer2008.AsArray());
}
