static void Main(string[] args)
{
// Initialize for license aspose
LicenseAspose();
ConversionOption options = LoadConfigurations();
// Confirm do preconversion
string doPreConversion;
do
{
Console.Write("Perform pre-conversion job [Y/N]?");
doPreConversion = Console.ReadLine();
}while (!IsYesNoValue(doPreConversion));
options.DoPreConversion = YesNoToBool(doPreConversion);
// Confirm check existing data
string dataCheck;
do
{
Console.Write("Perform existing data check [Y/N]?");
dataCheck = Console.ReadLine();
}while (!IsYesNoValue(dataCheck));
options.CheckExistData = YesNoToBool(dataCheck);
// Confirm blob handling
string blobHandling;
do
{
Console.Write("Move Blobs [Y/N]?");
blobHandling = Console.ReadLine();
}while (!IsYesNoValue(blobHandling));
options.BlobHandling = YesNoToBool(blobHandling);
// Initialize
Logger.Info("Initializing conversion manager");
string srcConnectionString = ConfigurationManager.ConnectionStrings["SourceDatabase"].ConnectionString;
string destConnectionString = ConfigurationManager.ConnectionStrings["DestinationDatabase"].ConnectionString;
ConversionManager manager = new ConversionManager(srcConnectionString, destConnectionString, options);
// Configure pre-conversion script and post-conversion script
manager.AddPreConversionScript(@"SQLScripts\3.2.2.AddNewField.sql");
manager.AddPreConversionScript(@"SQLScripts\3.2.3.CreatePolicyRecords.sql");
manager.AddPreConversionScript(@"SQLScripts\3.2.4.UpdatePoliciesTable.sql");
manager.AddPreConversionScript(@"SQLScripts\3.2.5.UpdateJournalsTable.sql");
manager.AddPreConversionScript(@"SQLScripts\3.2.6.UpdateWorkbook_NotesTable.sql");
manager.AddPostConversionScript(@"SQLScripts\3.2.7.PopulateCurrentPolicy.sql");
manager.AddPostConversionScript(@"SQLScripts\4.1.EntityBalance.sql");
manager.AddPostConversionScript(@"SQLScripts\4.2.PolicyBalance.sql");
manager.AddPostConversionScript(@"SQLScripts\4.3.PolicyInsured.sql");
manager.AddPostConversionScript(@"SQLScripts\4.5.AutoPolicyNumber.sql");
manager.AddPostConversionScript(@"SQLScripts\4.6.EditBrokerRepWorkbook.sql");
manager.AddPostConversionScript(@"SQLScripts\4.7.MandatoryFields.sql");
// Start generate converesion package
manager.Run();
}