I have a sybase database of 7 GB. I want to connect to that database from SQL server DTS package and transfer data from Sybase to Sql server. Can anyone suggest a better way to connect and approx. time frame to transfer data from sybase.
I heard from my friends that Microsoft will not support accessing Sybase from Sql server for using it as linked server. So they suggested to use DTS package instead. Please advice