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.

  • 3
    SSMA 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 Shah
    Oct 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 V
    Oct 26, 2018 at 8:26

1 Answer 1


Not the answer you're looking for? Browse other questions tagged or ask your own question.