I am using Copy job to copy data from Azure SQL DB to Fabric SQL DB, since Fabric SQL DB doesn't support geography data type, copy job maps geography data type to varbinary, which will cause error:
Failure happened on 'destination' side. ErrorCode=UserErrorInvalidDataValue,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Column 'DeliveryLocation' contains an invalid value 'POINT (-86.261937 39.9508733)'.,Source=Microsoft.DataTransfer.DataContracts,''Type=System.ArgumentException,Message=Type of value has a mismatch with column typeCouldn't store <POINT (-86.261937 39.9508733)> in DeliveryLocation Column. Expected type is Byte[].,Source=System.Data,''Type=System.ArgumentException,Message=Type of value has a mismatch with column type,Source=System.Data,'
But if it default map is varchar, it will successful run. So suggest to map to varchar if destination is Fabric SQL db, not varbinary. Thanks.
