Mapping of column names should be case-insensitive in SQL Azure Connector of ADF
Automatic mapping of field names should be case-insensitive in SQL Azure connector.
In Azure SQL Datawarehouse connector fields with identical names but different case (upper-/lowercase) characters are mapped smoothly.
Not so in Azure SQL connector. Everything must be done manually. Every refresh will void the mappings, which is rather painful.
Also in Copy Data Activity set the option to to make the Mapping case insensitive
Ed Pearson commented
Agreed, and this should apply to any SQL Server, including Managed Instance and On Prem.
Should have a toggle that allows to disregard case at least.
This is so silly to have this kind of issue in this age of Technology. Please, fix this ASAP. It should not have happened in the first place.
Please fix this Microsoft....
Rakshith Shetty commented
Same issue is there in Azure PostGreSql as well
If not case-insensitive, at least give us access to set the case-sensitivity!