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

There is a utility called rs_subcmp which comes with the Replication Server that will allow you to do this. It will even reconcile the two tables.

Regards,
Tarlock

Francis Stanisci wrote:

> BCP the two tables out and use FC (file compare), comes with NT and I
> believe WIN9x. See syntax below....
>
> FC [/A] [/C] [/L] [/LBn] [/N] [/T] [/U] [/W] [/nnnn]
> [drive1:][path1]filename1
> [drive2:][path2]filename2
> FC /B [drive1:][path1]filename1 [drive2:][path2]filename2
>
> /A Displays only first and last lines for each set of
> differences.
> /B Performs a binary comparison.
> /C Disregards the case of letters.
> /L Compares files as ASCII text.
> /LBn Sets the maximum consecutive mismatches to the specified
> number of
> lines.
> /N Displays the line numbers on an ASCII comparison.
> /T Does not expand tabs to spaces.
> /U Compare files as UNICODE text files.
> /W Compresses white space (tabs and spaces) for comparison.
> /nnnn Specifies the number of consecutive lines that must match
> after a
> mismatch.
>
> Francis
>
> mravichandran_at_hotmail.com wrote:
>
>> 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 Thu Oct 29 1998 - 00:00:00 CST