Re: Looking for a table difference (compare) utility.

I don't know of any tool that does this for databases. If it were me, I would
probably proceed this way:

1. Export all the records both tables to ASCII files. You can use a 3rd party product to do this or you can devise your own using ISQL. This will work if the table isn't too big.
2. Use a unix diff utility to diff the files. PVCS has a good one called VDIFF. You will also find a port of the famous unix product for Win32 on the Net someplace. Last but not least, there's WinDiff from MSFT. It comes with their resource kits and development products for free.

David L. Cherin
White Sands Technology, Inc.

mravichandran_at_hotmail.com wrote in message <70ljri$t4o$1_at_nnrp1.dejanews.com>...
>Dear Netters,
>
>I know that a utility exists to compare the difference in 2 ASCII files (or
 2
>copies of the same file, one of which is modified). I am looking for a
>utility to do the same for tables in a relational database.
>
>I will be making changes to an existing table.. modifying records not the
>table structure. i want to know whether any utility will compare the
 records
>of 2 tables and point out the one that are different.
>
>I searched the internet and was lead to unrelated sites. also let me know
 if
>there are any keywords that i have to use.
>
>with regards
>Ravi.
>
>please reply to ravimahalingam_at_pmsc.com.
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Wed Oct 21 1998 - 00:00:00 CDT