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
Table Data Comparison Between Sybase and SQL Server
Moderators: chulett, rschirm, roy
Table Data Comparison Between Sybase and SQL Server
~Atul Singh
<a href=http://www.datagenx.net>DataGenX</a> | <a href=https://www.linkedin.com/in/atulsinghds>LinkedIn</a>
<a href=http://www.datagenx.net>DataGenX</a> | <a href=https://www.linkedin.com/in/atulsinghds>LinkedIn</a>