Share via

SSMA Tester Report Shows 0 Equivalent Tables in Migration from Sybase to MS SQL

Anonymous
2025-02-10T04:08:44+00:00

The SSMA Tester results for migrating Sybase to MS SQL indicate "equivalent tables" as 0. SSMA Tester results shows success. What could be the reason for this outcome?

The table comparison was set to "Full" in SSMA Tester, but the result remains unchanged.

A simple "Students" table was tested, containing 5 records: StudentId (Primary Key), StudentName, but the message indicating equivalent tables remains at 0.

Verification steps taken:

  • The database character sets are equivalent: Sybase uses ISO-8859-1 Binary Sorting, while MS SQL uses Latin_General1_100_BIN2.
  • Data types match in both MS SQL and Sybase.
  • The database names were made the same.
  • The latest SSMA version, along with the Extension pack, was installed.

Any insights on why this issue persists would be appreciated

Windows Server Performance and maintenance Application technologies and compatibility

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question. To protect privacy, user profiles for migrated questions are anonymized.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2025-02-10T06:19:35+00:00

    Hello

    Thank you for posting in Microsoft Community forum.

    Based on the description, I understand your question is related to the SQL.

    Since there are no engineers dedicated to SQL Server in this forum. in order to be able to get a quick and effective handling of your issue, I recommend that you repost your question in the Q&A forum, where there will be a dedicated engineer to give you a professional and effective reply.

    Here is the link for Q&A forum.

    Questions - Microsoft Q&A

    Click the "Ask a Question" button in the upper right corner to post your question and select "SQL Server" tag.

    Thank you for your understanding and support. If you have any question or concern, please feel free to let us know.

    Have a nice day.

    Best Regards,

    Molly

    0 comments
  2. Anonymous
    2025-02-10T09:47:14+00:00

    Hi,

    Thank you for the quick response. I previously posted this question but haven’t received any responses yet in the Q&A Forum.

    https://learn.microsoft.com/en-us/answers/questions/2148297/ssma-tester-report-shows-0-equivalent-tables-in-mi

    I’d really appreciate any guidance. Could you suggest another way to reach the SQL & SSMA team?

    Regards,

    Rajeskumar S L

    0 comments
  3. Anonymous
    2025-02-17T01:14:40+00:00

    Hello,

    I'm afraid there is no more resources form current forum about SQL server, but you can try add more tags under your post in Q&A.

    Best regards,

    Molly

    0 comments