SQLTeam.com | Weblogs | Forums

Database migration from Sybase ASE to Azure SQL managed instance

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 as 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.