SSMA for Sybase - Server side data migration failed

Question

I am doing sybase ASE to SQL server 2017 data migration. I have converted schema and did synchronize. Now tables are created in SQL server. Then I have to load data from sybase for that I have changed the project settings to use server side data migration for better performance. I am getting message as Data migration failed. It does not throws any error messages.
I have verified below.

1. Extension pack installed in the machine where sql server is installed.
2. SQL server agent is running,
3. CLR enabled

Note: I am doing data migration client machine. Client side data migration works fine.

Answer 1

Hello,

Did you install Sybase client components on the SQL Server machine? When running server-side data migration it will create a SQL Agent job that runs on the SQL Server machine and reads data directly from Sybase server, thus it needs to be able to connect to Sybase from that machine. Also make sure that client components you install there are of the same architecture as the server-side data migration engine you are using (by default it's 64-bit, but can be changed in project settings).

You may also be able to see more information in the log file, just make sure to switch all log levels to debug (Tools -> Global Settings -> Logging). Although if there is something happening on the server side, we may not log it in the client-side log.

Check Event Viewer on the SQL Server machine to see if there is anything being logged there.

Ultimately, if client-side migration works - I don't see any reason to invest in setting up server-side.

Regards,
Alex.