private static void ImportBacpac(
string connectionString,
string targetDatabaseName,
string bacpacFileFullPath)
{
var ds = new DacServices(connectionString);
using var package = BacPackage.Load(bacpacFileFullPath);
var options = new DacImportOptions
{
CommandTimeout = DefaultCommandTimeout
};
ds.Message += (object sender, DacMessageEventArgs eventArgs) => Console.WriteLine(eventArgs.Message.Message);
ds.ImportBacpac(package, targetDatabaseName, options);
}
public async Task Import(ProgressDialogController progress)
{
await Task.Run(() =>
{
// open file
var result = new OpenFileDialogService().Show(fileName =>
{
// initialize LocalDB
Delete();
Create();
// import bacpac
_dacService.ProgressChanged += (sender, args) => progress.SetMessage($"{args.Status} : {args.Message}");
_dacService.ImportBacpac(BacPackage.Load(fileName), _databaseName);
});
progress.SetMessage(result ? "Success" : "Fail");
});
await progress.CloseAsync();
}
public static void RestoreBacpac(ICakeContext context, string connectionString, string newDatabaseName, string?bacpacFilePath)
{
if (string.IsNullOrEmpty(bacpacFilePath))
{
throw new ArgumentNullException(nameof(bacpacFilePath));
}
Initializer.InitializeNativeSearchPath();
context.Log.Information($"About to restore bacpac from {bacpacFilePath} into database {newDatabaseName}");
using (var bacPackage = BacPackage.Load(bacpacFilePath))
{
context.Log.Debug($"Loaded bacpac file {bacpacFilePath}");
var service = new DacServices(connectionString);
service.ImportBacpac(bacPackage, newDatabaseName);
}
context.Log.Information($"Finished restoring bacpac file into database {newDatabaseName}");
}
private void SQLDBBacPacImportFromFile(DacAzureEdition edition, bool importBlockOnPossibleDataLoss, string importDBConnectionString, string importDBName, string importFileFullPath)
{
DacDeployOptions dacOptions = new DacDeployOptions();
dacOptions.BlockOnPossibleDataLoss = importBlockOnPossibleDataLoss;
DacServices dacServiceInstance = new DacServices(importDBConnectionString);
// There are two events to get feed back during import.
//dacServiceInstance.Message += EventHandlerDACMessage;
//dacServiceInstance.ProgressChanged += EventHandlerDacServiceInstanceProgressChanged;
using (BacPackage dacpac = BacPackage.Load(importFileFullPath))
{
DacAzureDatabaseSpecification dbSpec = new DacAzureDatabaseSpecification();
dbSpec.Edition = edition;
dacServiceInstance.ImportBacpac(dacpac, importDBName);
dacpac.Dispose();
}
}
public override void Execute()
{
BacPackage bacpac = BacPackage.Load(this.Parameters.PackageFilePath);
this.DacServices.ImportBacpac(bacpac, this.Parameters.DatabaseName, this.CancellationToken);
}
private static async Task CloneDatabase(string[] args, CancellationToken cancellation)
{
#region Arguments
// Build the configuration root based on project user secrets
IConfiguration config = new ConfigurationBuilder()
.AddUserSecrets(typeof(Program).Assembly)
.AddCommandLine(args) // Higher precedence
.Build();
var opt = config.Get <ClonerOptions>();
if (string.IsNullOrWhiteSpace(opt.ConnectionString))
{
throw new ArgumentException($"The parameter {nameof(opt.ConnectionString)} is required.");
}
while (string.IsNullOrWhiteSpace(opt.Source))
{
Write("Enter Source DB Name: ");
opt.Source = ReadLine();
WriteLine();
}
if (string.IsNullOrWhiteSpace(opt.Destination))
{
throw new ArgumentException($"The parameter {nameof(opt.Destination)} is required.");
}
#endregion
#region Connection Strings
string neutralConnString;
string sourceConnString;
string destinationConnString;
{
var bldr = new SqlConnectionStringBuilder(opt.ConnectionString)
{
InitialCatalog = ""
};
neutralConnString = bldr.ConnectionString;
// Source
bldr.InitialCatalog = opt.Source;
sourceConnString = bldr.ConnectionString;
// Destination
bldr.InitialCatalog = opt.Destination;
destinationConnString = bldr.ConnectionString;
}
#endregion
// Initial setup
var service = new DacServices(neutralConnString);
service.Message += (object s, DacMessageEventArgs e) =>
{
WriteLine(e.Message.Message);
};
string bacpacPath = $"{Guid.NewGuid():N}.bacpac";
try
{
// Exporting package from source
{
WriteLine();
WriteLine($"============= Exporting from {opt.Source}...");
service.ExportBacpac(bacpacPath, opt.Source, null, cancellation);
WriteLine($"\u2713 Exporting {opt.Source} is complete.", ConsoleColor.Green);
WriteLine();
}
// Import package in destination
{
WriteLine($"============= Importing into {opt.Destination}...");
var package = BacPackage.Load(bacpacPath);
service.ImportBacpac(package, opt.Destination, new DacAzureDatabaseSpecification {
Edition = DacAzureEdition.Basic
}, cancellation);
WriteLine($"\u2713 Importing into {opt.Destination} is complete.", ConsoleColor.Green);
}
// Changing the navbar color
{
using var conn = new SqlConnection(destinationConnString);
using var cmd = conn.CreateCommand();
cmd.CommandText = @$ "UPDATE [dbo].[Settings] SET [BrandColor] = N'#5c5c5c', [SettingsVersion] = NEWID();";
await conn.OpenAsync(cancellation);
await cmd.ExecuteNonQueryAsync(cancellation);
WriteLine($"\u2713 Updated {opt.Destination} brand color to gray.", ConsoleColor.Green);
WriteLine();
}
}
finally
{
File.Delete(bacpacPath);
}
#region Launch Chrome
if (!string.IsNullOrWhiteSpace(opt.LaunchUrl))
{
Process process = new();
process.StartInfo.UseShellExecute = true;
process.StartInfo.FileName = "chrome";
process.StartInfo.Arguments = opt.LaunchUrl;
process.Start();
}
#endregion
}
