Comparing Two Recordsets Using Powershell

• Tom Powell-334692

  Old Hand

  Points: 366

  More actions

  July 13, 2012 at 12:05 am

  #264206

  Comments posted to this topic are about the item Comparing Two Recordsets Using Powershell

  [font="Comic Sans MS"]Tom Powell
  http://philergia.wordpress.com/[/font]

• SQLPhil

  SSCarpal Tunnel

  Points: 4204

  More actions

  July 13, 2012 at 12:46 am

  #1512390

  A very nice little bit of code. You could probably go to town on this one and set up SSIS packages to load the output file and then a nice SSRS report to clearly display discrepancies in data between two instances as I suspect the text file can get quite difficult to read if there are lots of differences to compare.

  But I think what this clearly demonstrates is the ease at which PowerShell can be used to help with otherwise mundane tasks, and is a very valuable tool in any DBA's toolkit.

  Thanks!