I need to export a database to set up a Rock Instance on a local/on premises server for a client. The production database is held in Azure Sql Server, but the new one won't be. I need to export a data-tier application from SSMS, but when I attempt it, I get the following error message:
TITLE: Microsoft SQL Server Management Studio
------------------------------
One or more unsupported elements were found in the schema used as part of a data package.
Error SQL71501: Error validating element [dss]: Schema: [dss] has an unresolved reference to object [##MS_SyncAccount##].
Error SQL71501: Error validating element [TaskHosting]: Schema: [TaskHosting] has an unresolved reference to object [##MS_SyncAccount##].
Error SQL71626: The element Certificate: [DataSyncEncryptionCertificate_2ebb488920384fde952a837f970c1f54] is not supported in Microsoft Azure SQL Database v12.
Error SQL71626: The element Symmetric Key: [DataSyncEncryptionKey_2ebb488920384fde952a837f970c1f54] is not supported in Microsoft Azure SQL Database v12.
(Microsoft.SqlServer.Dac)
------------------------------
BUTTONS:
OK
------------------------------