Post reply

Comparing Two Recordsets Using Powershell

  • 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]

  • 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!

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

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