❔ 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:
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
1 Reply
Looks like nothing has happened here. I will mark this as stale and this post will be archived until there is new activity.