Post reply

Compare data in a database

  • October 30, 2013 at 7:04 pm

    #279531

    Hi,

    I have an application (that I didn't write and do not have the source of) that uses a small SQL Server 2008 R2 database. There are a couple of tasks in the application (e.g., changing security) that certainly insert/update records in the underlying tables. However, I'm trying to track down exactly what changed in which tables.

    I know there are several SQL Server database comparison tools available but many that I've seen compare two different databases and then report on their schema differences. What I'm looking to do is compare data in the same database--so in quick succession get a snapshot of the data, perform the task in the application, then compare its database to the snapshot--a before and after comparison to get the delta and see exactly what changed.

    Does anyone know of any tools in existence that would help with this (without having to make a copy of the database)?

    Thanks,

    Mike

    Mike Scalise, PMP
    https://www.michaelscalise.com

  • October 30, 2013 at 7:09 pm

    #1662897

    What edition are you using?

    You could use snapshots or CDC(Change Data Capture) on Enterprise edition.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • October 30, 2013 at 7:29 pm

    #1662899

    Standard :-/

    Mike Scalise, PMP
    https://www.michaelscalise.com

  • October 30, 2013 at 7:37 pm

    #1662901

    I use Red Gate SQL Data Compare (10.0) which allows you to compare a snapshot to a database. So you could create a snapshot of the database prior to the changes and then run the compare afterwards with the production database.


    Microsoft Certified Master - SQL Server 2008
    Follow me on twitter: @keith_tate

    Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • October 30, 2013 at 7:47 pm

    #1662902

    Thanks, Keith! That's just what I was looking for.

    Mike

    Mike Scalise, PMP
    https://www.michaelscalise.com

Viewing 5 posts - 1 through 4 (of 4 total)

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