Migrate database from Sybase ASE to Azure SQL managed instance

Yuva Raj 31 Reputation points
2022-07-11T11:26:47.013+00:00

Hi,

We planned to migrate Sybase ASE database to Azure SQL managed instance. Our source Sybase database collation is Binary as like below

"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).
"

But there are 9 types of collation in SQL like below
Latin1_General_BIN
Latin1_General_BIN2
Latin1_General_100_BIN
Latin1_General_100_BIN2
Latin1_General_100_BIN2_UTF8
SQL_Latin1_General_CP437_BIN
SQL_Latin1_General_CP437_BIN2
SQL_Latin1_General_CP850_BIN
SQL_Latin1_General_CP850_BIN2

Any one please assist , which SQL collation suitable for above source Sybase collation.

Azure SQL Database
SAP HANA on Azure Large Instances
SAP HANA on Azure Large Instances
Microsoft branding terminology for an Azure offer to run HANA instances on SAP HANA hardware deployed in Large Instance stamps in different Azure regions.
120 questions
Azure Migrate
Azure Migrate
A central hub of Azure cloud migration services and tools to discover, assess, and migrate workloads to the cloud.
745 questions
0 comments
Accepted answer
  1. Alberto Morillo 33,341 Reputation points MVP
    2022-07-11T13:43:04.553+00:00

    You can use Latin1_General_BIN2 as the default collation but take in consideration the following about sorts (ORDER BY).

    "There are two types of binary collations in SQL Server; the older BIN collations and the newer BIN2 collations. In a BIN2 collation all characters are sorted according to their code points. In a BIN collation only the first character is sorted according to the code point, and remaining characters are sorted according to their byte values."

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest