Ejemplo n.º 1
0
        public override void RegisterRealTasks(PhysicalServer site)
        {
            DbConnectionInfo connectionInfo;

            if (_connectionString.IsNotEmpty())
            {
                connectionInfo = new DbConnectionInfo(_connectionString);
            }
            else
            {
                connectionInfo = new DbConnectionInfo
                {
                    Server       = site.Name,
                    Instance     = _instanceName,
                    DatabaseName = _databaseName,
                    UserName     = _userName,
                    Password     = _password
                };
            }

            var task = new RoundhousETask(connectionInfo, _scriptsLocation,
                                          _environmentName, _roundhouseMode,
                                          _recoveryMode, _restorePath, _restoreTimeout, _restoreCustomOptions,
                                          _repositoryPath, _versionFile, _versionXPath, _commandTimeout, _commandTimeoutAdmin,
                                          _functionsFolderName, _sprocsFolderName, _viewsFolderName, _upFolderName,
                                          _versionTable, _scriptsRunTable, _scriptsRunErrorTable, _warnOnOneTimeScriptChanges, _outputPath);

            site.AddTask(task);
        }
Ejemplo n.º 2
0
        public void TestRoundhousE()
        {
            var task = new RoundhousETask(".", "SQL2005", "TestRoundhousE", true,
                                          @"E:\external projects\kaithos\roundhouse\db\SQLServer\TestRoundhousE", "TEST",
                                          true);
            DeploymentResult results = task.Execute();

            Assert.IsFalse(results.ContainsError());
        }
Ejemplo n.º 3
0
        public void TestRoundhousE()
        {
            var connection = new DbConnectionInfo {
                Server       = "(local)",
                DatabaseName = "TestRoundhouse"
            };
            var task = new RoundhousETask(connection,
                                          @"C:\Solutions\roundhouse\code_drop\sample\db\SQLServer\TestRoundhousE", "TEST",
                                          RoundhousEMode.DropCreate, DatabaseRecoveryMode.Simple, string.Empty, 0, string.Empty, "git://somehwere", "", "", 0, 0, "", "", "", "", "", "", "", null, null);
            DeploymentResult results = task.Execute();

            System.Console.WriteLine(results);
            Assert.IsFalse(results.ContainsError());
        }
Ejemplo n.º 4
0
        public override void RegisterRealTasks(PhysicalServer site)
        {
            var serverAddressWithInstance = site.Name;

            if (!string.IsNullOrEmpty(_instanceName))
            {
                serverAddressWithInstance = @"{0}\{1}".FormatWith(serverAddressWithInstance, _instanceName);
            }

            var task = new RoundhousETask(serverAddressWithInstance, _databaseType, _databaseName, _drop,
                                          _scriptsLocation, _environmentName, _useSimpleRecoveryMode);

            site.AddTask(task);
        }
Ejemplo n.º 5
0
        public override void RegisterRealTasks(PhysicalServer site)
        {
            var connectionInfo = new DbConnectionInfo {
                Server       = site.Name,
                Instance     = _instanceName,
                DatabaseName = _databaseName,
                UserName     = _userName,
                Password     = _password
            };
            // string scriptsLocation = PathConverter.Convert(site, _path.GetFullPath(_scriptsLocation));

            var task = new RoundhousETask(connectionInfo, _scriptsLocation,
                                          _environmentName, _roundhouseMode,
                                          _recoveryMode, _restorePath, _restoreTimeout, _restoreCustomOptions,
                                          _repositoryPath, _versionFile, _versionXPath, _commandTimeout, _commandTimeoutAdmin,
                                          _functionsFolderName, _sprocsFolderName, _viewsFolderName, _upFolderName,
                                          _versionTable, _scriptsRunTable, _scriptsRunErrorTable, _warnOnOneTimeScriptChanges, _outputPath);

            site.AddTask(task);
        }
Ejemplo n.º 6
0
        public override void RegisterRealTasks(PhysicalServer site)
        {
            var connectionInfo = new DbConnectionInfo{
                Server = site.Name,
                Instance = _instanceName,
                DatabaseName = _databaseName,
                UserName = _userName,
                Password = _password
            };
            // string scriptsLocation = PathConverter.Convert(site, _path.GetFullPath(_scriptsLocation));

            var task = new RoundhousETask(connectionInfo, _scriptsLocation,
                _environmentName, _roundhouseMode,
                _recoveryMode, _restorePath, _restoreTimeout, _restoreCustomOptions,
                _repositoryPath, _versionFile, _versionXPath, _commandTimeout, _commandTimeoutAdmin,
                _functionsFolderName, _sprocsFolderName, _viewsFolderName, _upFolderName, _runBeforeUpFolderName,
                _versionTable, _scriptsRunTable, _scriptsRunErrorTable, _warnOnOneTimeScriptChanges,
                _runAfterOtherAnytimeScriptsFolderName, _runAfterCreateDatabaseScriptsFolderName, _outputPath);

            site.AddTask(task);
        }
Ejemplo n.º 7
0
        public override void RegisterRealTasks(PhysicalServer site)
        {
            // string scriptsLocation = PathConverter.Convert(site, _path.GetFullPath(_scriptsLocation));
            var instanceServer = site.Name;
            if (!string.IsNullOrEmpty(_instanceName))
                instanceServer = @"{0}\{1}".FormatWith(instanceServer, _instanceName);

            var connectionString = BuildConnectionString(instanceServer, _databaseName, _userName, _password);

            var task = new RoundhousETask(connectionString, _scriptsLocation,
                                          _environmentName, _roundhouseMode,
                                          _recoveryMode, _restorePath, _restoreTimeout,_restoreCustomOptions, _repositoryPath, _versionFile, _versionXPath, _commandTimeout, _commandTimeoutAdmin);

            site.AddTask(task);
        }