public static SqlScripterOptions GetFromAppConfig()
{
var options = new SqlScripterOptions();
options.TargetServerVersion = Version.Parse(ConfigurationManager.AppSettings["TargetServerVersion"]);
options.TargetDatabaseEngineType = ConfigurationManager.AppSettings["TargetDatabaseEngineType"];
options.IncludeHeaders = Convert.ToBoolean(ConfigurationManager.AppSettings["IncludeHeaders"]);
options.AnsiPadding = Convert.ToBoolean(ConfigurationManager.AppSettings["AnsiPadding"]);
options.NoFileGroup = Convert.ToBoolean(ConfigurationManager.AppSettings["NoFileGroup"]);
options.NoCollation = Convert.ToBoolean(ConfigurationManager.AppSettings["NoCollation"]);
options.NoExecuteAs = Convert.ToBoolean(ConfigurationManager.AppSettings["NoExecuteAs"]);
options.NoFileStream = Convert.ToBoolean(ConfigurationManager.AppSettings["NoFileStream"]);
options.NoFileStreamColumn = Convert.ToBoolean(ConfigurationManager.AppSettings["NoFileStreamColumn"]);
options.NoIdentities = Convert.ToBoolean(ConfigurationManager.AppSettings["NoIdentities"]);
options.NoIndexPartitioningSchemes = Convert.ToBoolean(ConfigurationManager.AppSettings["NoIndexPartitioningSchemes"]);
options.NoTablePartitioningSchemes = Convert.ToBoolean(ConfigurationManager.AppSettings["NoTablePartitioningSchemes"]);
options.NoVardecimal = Convert.ToBoolean(ConfigurationManager.AppSettings["NoVardecimal"]);
options.NoViewColumns = Convert.ToBoolean(ConfigurationManager.AppSettings["NoViewColumns"]);
options.DriDefaults = Convert.ToBoolean(ConfigurationManager.AppSettings["DriDefaults"]);
options.DriChecks = Convert.ToBoolean(ConfigurationManager.AppSettings["DriChecks"]);
options.DriWithNoCheck = Convert.ToBoolean(ConfigurationManager.AppSettings["DriWithNoCheck"]);
options.ExtendedProperties = Convert.ToBoolean(ConfigurationManager.AppSettings["ExtendedProperties"]);
options.Triggers = Convert.ToBoolean(ConfigurationManager.AppSettings["Triggers"]);
return(options);
}
public static MigrationOptions GetFromAppConfig()
{
var options = new MigrationOptions();
options.ScripterOptions = SqlScripterOptions.GetFromAppConfig();
options.MaxThreads = Convert.ToInt32(ConfigurationManager.AppSettings["MaxThreads"]);
options.MaxErrors = Convert.ToInt32(ConfigurationManager.AppSettings["MaxErrors"]);
options.MaxAttempts = Convert.ToInt32(ConfigurationManager.AppSettings["MaxAttempts"]);
options.MaxAttempts = Convert.ToInt32(ConfigurationManager.AppSettings["MaxAttempts"]);
options.LogSql = Convert.ToBoolean(ConfigurationManager.AppSettings["LogSql"]);
return(options);
}
public SqlScripter(SqlDatabase owner, SqlScripterOptions options)
{
_owner = owner;
_options = options;
}
public SqlDatabase(string connectionString, SqlScripterOptions options)
{
_options = options;
_connection = CreateConnection(connectionString);
}
public static SqlDatabase Connect(string connectionString, SqlScripterOptions options)
{
var db = new SqlDatabase(connectionString, options);
return(db);
}
