SQL Server Collation vs Sybase ASE

Question

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

Answer 1

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.