public IImportAssets(SqlConnection sqlConn, MetaModel MetaAPI, Services DataAPI, MigrationConfiguration Configurations) { _sqlConn = sqlConn; _metaAPI = MetaAPI; _dataAPI = DataAPI; _config = Configurations; }
public CleanupDefects(SqlConnection sqlConn, MetaModel MetaAPI, Services DataAPI, MigrationConfiguration Configurations) : base(sqlConn, MetaAPI, DataAPI, Configurations) { }
public ExportRequests(SqlConnection sqlConn, MigrationConfiguration Configurations) : base(sqlConn, Configurations) { }
public ImportFeatureGroups(SqlConnection sqlConn, MetaModel MetaAPI, Services DataAPI, MigrationConfiguration Configurations) : base(sqlConn, MetaAPI, DataAPI, Configurations) { }
public ExportEpics(SqlConnection sqlConn, MigrationConfiguration Configurations) : base(sqlConn, Configurations) { }
public ExportConversations(SqlConnection sqlConn, MigrationConfiguration Configurations) : base(sqlConn, Configurations) { }
public ImportRegressionTests(SqlConnection sqlConn, MetaModel MetaAPI, Services DataAPI, MigrationConfiguration Configurations) : base(sqlConn, MetaAPI, DataAPI, Configurations) { }
//Verifies the connection to the SQL Server staging database. private static void VerifyStagingDBConnection(MigrationConfiguration.StagingDatabaseInfo v1DatabaseInfo) { try { SqlConnectionStringBuilder sb = new SqlConnectionStringBuilder(); sb.DataSource = v1DatabaseInfo.Server; sb.UserID = v1DatabaseInfo.Username; sb.Password = v1DatabaseInfo.Password; sb.InitialCatalog = v1DatabaseInfo.Database; sb.MultipleActiveResultSets = true; if (_config.V1StagingDatabase.TrustedConnection == true) sb.IntegratedSecurity = true; else sb.IntegratedSecurity = false; _sqlConn = new SqlConnection(sb.ToString()); _sqlConn.Open(); _logger.Info("-> Connection to staging database \"{0}\" verified.", v1DatabaseInfo.Database); } catch (Exception ex) { _logger.Error("-> Unable to connect to staging database \"{0}\".", v1DatabaseInfo.Database); throw ex; } }
public ExportAttachments(SqlConnection sqlConn, MetaModel MetaAPI, Services DataAPI, V1APIConnector ImageConnector, MigrationConfiguration Configurations) : base(sqlConn, MetaAPI, DataAPI, Configurations) { _imageConnector = ImageConnector; }
public ExportProjects(SqlConnection sqlConn, MigrationConfiguration Configurations) : base(sqlConn, Configurations) { }
public ExportListTypes(SqlConnection sqlConn, MigrationConfiguration Configurations) : base(sqlConn, Configurations) { }
public ExportTestSteps(SqlConnection sqlConn, MigrationConfiguration Configurations) : base(sqlConn, Configurations) { }
public ExportAttachments(SqlConnection sqlConn, MigrationConfiguration Configurations) : base(sqlConn, Configurations) { }
public IExportAssets(SqlConnection sqlConn, MigrationConfiguration Configurations) { _sqlConn = sqlConn; _config = Configurations; }
public ExportSchedules(SqlConnection sqlConn, MigrationConfiguration Configurations) : base(sqlConn, Configurations) { }
static void Main(string[] args) { try { CreateLogHeader(); _logger.Info("Initializing configurations."); _config = (MigrationConfiguration)ConfigurationManager.GetSection("migration"); _logger.Info("Verifying connections."); VerifyStagingDBConnection(_config.V1StagingDatabase); if (_config.V1Configurations.PerformExport == true && _config.V1Configurations.SourceConnectionToUse == "VersionOne") VerifyV1SourceConnection(); if (_config.V1Configurations.PerformImport == true || _config.V1Configurations.PerformClose == true || _config.V1Configurations.PerformCleanup) VerifyV1TargetConnection(); _logger.Info(""); //Export from source system to staging database. if (_config.V1Configurations.PerformExport == true) { _logger.Info("*** EXPORTING:"); PurgeMigrationDatabase(); ExportAssets(); _logger.Info(""); } //Import into target system from staging database. if (_config.V1Configurations.PerformImport == true) { _logger.Info("*** IMPORTING:"); ImportAssets(); _logger.Info(""); } //Close imported items in target system. if (_config.V1Configurations.PerformClose == true) { _logger.Info("*** CLOSING:"); CloseAssets(); _logger.Info(""); } //Do claenup tasks in target system. if (_config.V1Configurations.PerformCleanup== true) { _logger.Info("*** CLEANUP:"); CleanupAssets(); _logger.Info(""); } _sqlConn.Close(); _logger.Info("Data migration complete!"); } catch (Exception ex) { _logger.Error("ERROR: " + ex.Message); _logger.Error("INNER: " + ex.InnerException.ToString()); _logger.Error("TRACE: " + ex.StackTrace.ToString()); _logger.Info(""); _logger.Info("Data migration terminated."); } finally { _logger.Info(""); _logger.Info(""); Console.WriteLine(); Console.WriteLine("Press ENTER to close:"); Console.Read(); Environment.Exit(0); } }
public ImportCustomFields(SqlConnection sqlConn, MetaModel MetaAPI, Services DataAPI, MigrationConfiguration Configurations, string AssetType) : base(sqlConn, MetaAPI, DataAPI, Configurations) { _assetType = AssetType; }
public ImportMembers(SqlConnection sqlConn, MetaModel MetaAPI, Services DataAPI, MigrationConfiguration Configurations) : base(sqlConn, MetaAPI, DataAPI, Configurations) { }
public ExportCustomFields(SqlConnection sqlConn, MetaModel MetaAPI, Services DataAPI, MigrationConfiguration Configurations, string InternalAssetType) : base(sqlConn, MetaAPI, DataAPI, Configurations) { _InternalAssetType = InternalAssetType; }
public ExportIterations(SqlConnection sqlConn, MetaModel MetaAPI, Services DataAPI, MigrationConfiguration Configurations) : base(sqlConn, MetaAPI, DataAPI, Configurations) { }
public ExportMembers(SqlConnection sqlConn, MigrationConfiguration Configurations) : base(sqlConn, Configurations) { }