Пример #1
0
        public void ExecuteCore()
        {
            SqlServerAdministrator = new SqlServerAdministrator(AmbientSettings.Settings ?? Settings);

            if (!string.IsNullOrEmpty(UserName))
            {
                Logger.Log("Creating windows login '{0}' in database {1}", new object[] { UserName, Settings.DatabaseName });
                SqlServerAdministrator.CreateWindowsLogin(UserName);
                SqlServerAdministrator.CreateUser(UserName, false);
            }
        }
Пример #2
0
        protected void ExecuteCore()
        {
            SqlServerAdministrator = new SqlServerAdministrator(Settings);

            if (!string.IsNullOrEmpty(UserName))
            {
                Logger.Log("Creating login and user '{0}' in database {1}", new object[] { UserName, Settings.DatabaseName });
                SqlServerAdministrator.CreateLogin(UserName, Password);
                SqlServerAdministrator.CreateUser(UserName, false);
            }
        }
Пример #3
0
        public void Execute(Assembly asm)
        {
            Settings = new XmlSettingsParser(asm);
            SqlServerAdministrator = new SqlServerAdministrator(AmbientSettings.Settings ?? Settings);

            if (!string.IsNullOrEmpty(UserName))
            {
                Logger.Log("Creating login and user '{0}' in database {1}", new object[] { UserName, Settings.DatabaseName });
                SqlServerAdministrator.CreateLogin(UserName, Password);
                SqlServerAdministrator.CreateUser(UserName, false);
            }
        }
Пример #4
0
        protected void ExecuteCore(Assembly asm)
        {
            SqlServerAdministrator   = new SqlServerAdministrator(Settings);
            AmbientSettings.Settings = Settings;

            EnsureDatabaseExists();

            Logger.Log("Running migrations with connection string {0}", new object[] { Settings.DefaultConnectionString });
            var migrator = new Migrator.Migrator(this.Provider, Settings.DefaultConnectionString, asm,
                                                 Trace, Logger)
            {
                DryRun = this.DryRun
            };

            using (var logStream = new MemoryStream())
                using (var writer = new StreamWriter(logStream))
                {
                    migrator.Logger = new SqlScriptFileLogger(migrator.Logger, writer);
                    this.RunMigration(migrator);

                    var logOutputStream = new MemoryStream(logStream.ToArray());
                    Logger.Log(GetStringFromStream(logOutputStream));
                }
        }
Пример #5
0
        public void Execute(Assembly asm)
        {
            Settings = new XmlSettingsParser(asm);
            SqlServerAdministrator = new SqlServerAdministrator(Settings);

            EnsureDatabaseExists();

            Logger.Log("Running migrations with connection string {0}", new object[] { Settings.DefaultConnectionString });
            var migrator = new Migrator.Migrator(this.Provider, Settings.DefaultConnectionString, asm,
                                                 Trace, Logger) { DryRun = this.DryRun };

            MemoryStream logOutputStream = new MemoryStream();

            using (MemoryStream logStream = new MemoryStream())
            using (StreamWriter writer = new StreamWriter(logStream))
            {
                migrator.Logger = new SqlScriptFileLogger(migrator.Logger, writer);
                this.RunMigration(migrator);

                logOutputStream = new MemoryStream(logStream.ToArray());
                Logger.Log(GetStringFromStream(logOutputStream));
            }
        }