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