We no longer are able to do the Schema Compare operation in Visual Studio 2017 with SQL Azure as it throws the error 'The element KEY_ASY_HR_SAL' is not suported...'. We are connecting with the database with 'Active Directory Integrated Authentication'. And this worked fine when the solution was setup.
The current version of SQL Azure database is 'Microsoft SQL Azure (RTM) - 12.0.2000.8 Apr 3 2019 13:27:00 Copyright (C) 2019 Microsoft Corporation '
Below are some things whats been tried:
- Tried with Visual Studio 2019
- Tried connecting with a SQL User with 'ddladmin' permission.