Table Data Comparison Between Sybase and SQL Server

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
atul9806
Participant
Posts: 96
Joined: Tue Mar 06, 2012 6:12 am
Location: Pune
Contact:

Table Data Comparison Between Sybase and SQL Server

Post by atul9806 »

Hi Guys
We are working on a migration project from V8.5 to V11.5 and Sybase to SQL Server. Currently facing the issue while comparing the data between Sybase and SQL Server tables and it is too much time consuming.

Is there a way by which we can develop a job which can compare the data between Sybase and SQL Server Table and get the difference.

This is what we have tried -
Src1 (SQL Server - RCP enabled) --->
Src2 (Sybase - RCP enabled)----------> Change Capture (All Keys, Explicit Values) --> Seq Stage

But job is aborting at reading the data from Sybase with below single fatal error -
Parallel job reports failure (code 139 error)

There are around 2000 tables that is why we want to automate the comparison. Manually this task is too difficult to complete :(
~Atul Singh
<a href=http://www.datagenx.net>DataGenX</a> | <a href=https://www.linkedin.com/in/atulsinghds>LinkedIn</a>
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Did you try putting something like "code 139" into an exact search here? Many others have dealt with that message before, hopefully something here helps.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply