New answers tagged

0

We have done very large table migrations successfully with Sqoop. Yes, there will be a bunch of setup that is needed but it is tuneable to run in multiple threads for faster performance.


1

Method 1: You can create a Linked server at SQL server pointing to SYBASE and then create a SQL server agent job that does the task of refreshing the data from SYBASE to SQL with help of OPENQUERY. This is better explained in the article here. Method 2: If you are comfortable at creating SSIS package, then you can create one, in case method 1 cannot be ...



Top 50 recent answers are included