Geek asks and answers

Cannot create bacpac anymore: SQL70015: deprecated String literals as column aliases not supported by SQL Azure

Today we are faced with a critical error - we can no longer create bacpac files for our Azure databases. Everything worked so far, and suddenly we began to encounter the following error:

Error during service operation. Failed to retrieve package from specified database. Error SQL70015: The legacy String Literals as Column Aliases feature is not supported in SQL Azure.

We have a complex database schema that has been deployed live to Azure for over a year now. We rely on daily baccarats - our only backup strategy - need help finding out how to resume building bacpacs.

+5
source share
2 answers

Well, I fell in your pain ... the answer is here: Replace your circuit ... There is no other way ...
Instead 'Column Name'use [Column Name]... instead Select CryptColumnA 'Column A' from myTableuse Select CryptColumnA as [Column A] from myTableetc ...

+5
source

We applied for support with Microsoft, and the problem was recognized as a bug. We had a problem with bacpac export, not import - and, apparently, this was due to a change in SQL Azure, which simplified some export checks.

To make the long story short, the problem was fixed by Microsoft, and we no longer experience the problem - and this is without any circuit changes at our end.

0
source

More articles:


All Articles