public static void RunSqlPackage(string instance, string database)
{
StringBuilder sqlPackageProcessOutput = new StringBuilder();
LogWriter Log = new LogWriter("----- Running RunSqlPackage -----");
string sqlPackagePath = LocateSQLPackage();
Log.LogWrite($"sqlpackage.exe found at {sqlPackagePath}");
string filePath = Dacpac.GenerateFilename(instance, database, Dacpac.outputFolder, Dacpac.currentDateTime);
Log.LogWrite($"File path is set to {filePath}");
string sqlCommandParams = GenerateSqlPackageCommand(sqlPackagePath, filePath, instance, database);
Log.LogWrite($"SQL Command Params: {sqlCommandParams}");
System.Diagnostics.Process sqlPackageProcess = CreateSqlPackageProcess(sqlPackagePath, sqlCommandParams);
sqlPackageProcess.Start();
sqlPackageProcess.BeginOutputReadLine();
sqlPackageProcess.BeginErrorReadLine();
sqlPackageProcess.WaitForExit();
}
private void getButton_Click(object sender, RoutedEventArgs e)
{
Dacpac CurrentJob = new Dacpac(instance, database);
SqlTools.RunSqlPackage(instance, database);
}
