Comparing Two Recordsets Using Powershell

  • Tom Powell-334692

    Old Hand

    Points: 366

    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

    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!

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply