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.
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.