Sybase to SQL Server Migration 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.