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