Pro V standalone

• 
  To be clearer, I'd like to know if the standard versions of SQL Compare and Data Compare are able to be called programatically - E.g. 
  
  

  process = new Process();

  process.StartInfo.FileName = sqlDataCompare;

  process.StartInfo.Arguments = string.Format("/backup1:{0} /backup2:{1} /scriptfile:{2}", currentBackup, previousBackup, sqlDataChanges); 

  process.StartInfo.UseShellExecute = false;

  process.StartInfo.RedirectStandardOutput = true;

  process.StartInfo.RedirectStandardError = true;

  process.StartInfo.CreateNoWindow = true;

  process.StartInfo.WindowStyle = ProcessWindowStyle.Hidden;

  process.Start();

  sqlCompareOutput = process.StandardOutput.ReadToEnd();

  sqlComareError = process.StandardError.ReadToEnd();

  
  

  process.WaitForExit();

  richard_litzo October 11, 2022 09:33

  - 0 +
• 
  Hi @richard_litzo
  
  I'm not sure if they tools can be called programmatically in this manner, however, for any form of automation with these two tools, you will need SQL Toolbelt license

  DanC October 12, 2022 10:04

  - 0 +

Add comment

Please sign in to leave a comment.