Solved

How to identify difference between two databases' data changes?

Posted on 2013-01-23
6
362 Views
Last Modified: 2013-02-06
I've existing DB called A. I created another DB called B from the backup of A.

I do modification in both databases. Say for example, in database A, in tableA some rows has been inserted. In database B, in tableA some rows has been deleted/modified.

I would like to know the data changes between the two databases. How to identify them? Is there any FREE tool existing for that? Or any other way existing to identify this? Or If I want to implement new tool what approach I've to follow?

Please do guide me.

Note: I'm using SQL SERVER 2008 R2.
0
Comment
Question by:Easwaran Paramasivam
  • 3
  • 2
6 Comments
 
LVL 9

Assisted Solution

by:selva_kongu
selva_kongu earned 333 total points
ID: 38813135
0
 
LVL 12

Assisted Solution

by:mwochnick
mwochnick earned 167 total points
ID: 38813138
without more detail about the number of tables, the structure of the tables its hard to give direction - but assuming 1 table in each database you could
1. write sql script to dump the data from each table in the same format to a csv file (if the columns allow it) and then use a tool like winmerge to compare the two output files for differences note that your export sql should both set column order and sort the data
2. you could write a SQL script to find all of the rows in table A that are not in table B and vice versa and then for the remaining rows process each column that could've changed in a loop where the key fields match
0
 
LVL 16

Author Comment

by:Easwaran Paramasivam
ID: 38813164
Found sqldelta is useful. It is commercial one. Any such kind of free tool available?
0
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 
LVL 16

Author Comment

by:Easwaran Paramasivam
ID: 38813176
If no free tool available, I would like to create my own tool. Please guide me how to achieve that?
0
 
LVL 9

Accepted Solution

by:
selva_kongu earned 333 total points
ID: 38813179
0
 
LVL 16

Author Closing Comment

by:Easwaran Paramasivam
ID: 38858899
Thanks.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how the fundamental information of how to create a table.

791 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question