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); }