Unable to migrate data from Sybase to SQL Server using SSMA RRS feed

  • Question

  • Hello, 

    SSMA for Sybase not migrating the data. Schema migration is working fine. 
    We validated the below points:

    i. SSMA extension pack installed in SQL Server machine.
    ii. OLEDB driver for Sybase installed in SQL Server machine.
    iii. Network and Firewall has been checked.
    iv. Able to connect the Sybase from SQL server machine.
    v. We are able to load the data from Sybase to SQL Server through SSIS package.\
    vi. We have chosen "Server side migration" in SSMA properties. 

    With all these we are unable to do the migration for a single small table which has 5 records using SSMA.
    There are no errors being popped by SSMA, it get hung. No progress, it shows 0%. 

    Any help would be greatly appreciated. 

    Please vote if you find this posting was helpful or Mark it as answered.

    Monday, June 27, 2016 2:45 PM