❔ Column names in each table must be unique. Column name x in table y
There is an Azure SQL db with 10 DTUs and migrations are broken with the following message:
I renamed 'OrphanedBalance' to something else and I still keep getting the same error message which is really weird. I believe that might be due to some schema caching. Then I exported that database from Azure as a .bacpac file using Azure Data Studio (Data-Tier Application) and imported it locally and it worked fine locally. Any idea what's going on? (edited)
June 22, 2023
Column names in each table must be unique. Column name 'OrphanedBalance' in table 'Transactions.MarketTransaction' is specified more than once.
I renamed 'OrphanedBalance' to something else and I still keep getting the same error message which is really weird. I believe that might be due to some schema caching. Then I exported that database from Azure as a .bacpac file using Azure Data Studio (Data-Tier Application) and imported it locally and it worked fine locally. Any idea what's going on? (edited)
June 22, 2023
