SQL Server Collation vs Sybase ASE

Tahir Khalil 41 Reputation points
2022-11-02T18:40:49.917+00:00

Hi,

We are planning a test migration from Sybase ASE 16.0 to MS-SQL Server Microsoft SQL Server 2019 (Linux).

Our current Sybase is on Ubuntu Linux with following character set & sort order:

Character Set = 1, iso_1 ISO 8859-1 (Latin-1) - Western European 8-bit character set.
Sort Order = 50, bin_iso_1 Binary ordering, for the ISO 8859/1 or Latin-1 character set (iso_1).

What is the best match collation in SQL Server? I am confused between the existing collation & sort orders in SQL Server.

Can someone please suggest?

Thanks

Tahir

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
506 questions
0 comments No comments
{count} votes

Accepted answer
  1. YufeiShao-msft 7,076 Reputation points
    2022-11-03T03:07:49.193+00:00

    Hi @Tahir Khalil

    The Latin-1 code page with binary sort is collation Latin1_General_100_BIN, Set or change the database collation

    You can use SSMA to quickly migrate SAP ASE database to SQL Server: Migration guide: SAP ASE to SQL Server, use SSMA you can set project conversion, migration, and the type mapping options

    -------------

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

0 additional answers

Sort by: Most helpful