Thursday, March 26, 2009

Comparing two different Databases

This is a tiny tool which would come handy in case you need to compare two different tables/ databases on same or different servers. I came across this unique requirement when we had to come up with a small code which would return TRUE or FALSE based on equal or unequal tables. I googled a bit and cam eup with the following code.

The code takes input from xml file. stored at disk. The code also compares SQL table with Oracle Table which is normally not provided by most DB compare tools available for free.

Mail me in case you have any issues using the tool.
Following is the snippet of xml file:

No comments: