• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 396
  • Last Modified:

How to identify difference between two databases' data changes?

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
Easwaran Paramasivam
Asked:
Easwaran Paramasivam
  • 3
  • 2
3 Solutions
 
selva_konguCommented:
0
 
mwochnickCommented:
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
 
Easwaran ParamasivamAuthor Commented:
Found sqldelta is useful. It is commercial one. Any such kind of free tool available?
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
Easwaran ParamasivamAuthor Commented:
If no free tool available, I would like to create my own tool. Please guide me how to achieve that?
0
 
selva_konguCommented:
0
 
Easwaran ParamasivamAuthor Commented:
Thanks.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now