What is the fastest/best approach to load data from SYBASE to SQL server DB. I have tables with 500 million records. I tried using SSMA and BCP, both are taking over 24hrs. I tried using datastage (etl) methods but not of much help. Thanks.
2
-
3SSMA does have a batch size that you can fiddle with. I would say use SSMA latest version and change the default batch size. This is your best option.– Kin ShahOct 25, 2018 at 19:08
-
What is your data load waiting for? IO on the target? CPU? You need to narrow this question down a lot.– Tom VOct 26, 2018 at 8:26
Add a comment
|
1 Answer
Create Linked server which fetches data from Sybase to SQL. Source Creating Linked server to SYBASE from SQL Server
Use ODBC connections to create an SSIS package which will fetch the data from SYBASE database onto SQL server. Check this Extracting data from Sybase SQL Anywhere using SSIS through ODBC. Then Schedule the above created package via SQL agent job to update data on SQL server as per schedule which meets the requirement.
