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.
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...
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With