Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

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.

like image 713
David Airapetyan Avatar asked Apr 29 '13 16:04

David Airapetyan


1 Answers

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...

like image 74
Leonardo Avatar answered Nov 24 '22 01:11

Leonardo