I am trying to connect 2 database (Sybase & Oracle) and then compare the tables in sybase & Oracle which will have similar formats. The objective is to compare 2 tables one from sybase and the other from oracle. if there is differences I would like to send those differences in the txt file.
Where can I find a similar script ?
Thank you
A L Abraham
===========================
Hi,
I can think of following steps.
1. Connect to both databases .
2. Fire the sql query on both tables
3. Write the output to two different text files
4. put each text file in an array
5. Comapre both array element by element using if loops
or
compare both text files using diff command on unix using system function of perl and redirect the output to a third text file.
then extract the contents of the file and display it on screen in tabular format.
for this you need to understand the diff command and then try to reformat the output in a way so that peopel can understand that.
i have stuck with the same situation.
i have to comapre the output of two stored procedures and report difference if any.
si i have fired diff command on both output and then dispalyed the diff in the html file.