No longer able to create a bacpac: SQL70015: Deprecated feature 'String literals as column aliases' is not supported on SQL Azure

azure, azure-sql-database

Solution

well I fell your pain... the answer here is: Replace your schema...There's no other way... Instead of `'Column Name'` use `[Column Name]`... instead of `Select CryptColumnA 'Column A' from myTable` use `Select CryptColumnA as [Column A] from myTable` and so forth...

Problem

We have encountered a critical error today - we are no longer able to create bacpac files of our live Azure production databases. Everything was working up until now, and suddenly we've started encountering the following error: Error encountered during the service operation. Could not extract package from specified database. Error SQL70015: Deprecated feature 'String literals as column aliases' is not supported on SQL Azure. We have a complex database schema which has been deployed live to Azure for over a year. We are relying on daily bacpacs are our only backup strategy - need help to figure out how to resume making bacpacs.

Original source