Can't export and Azure SQL database to a bacpac file. Error SQL71623: Model translation is not allowed
I have an Azure SQL database that I can successfully perform a restore from PITR or LTR. However, I have a need to export a copy of that database to a bacpac file to be consumed by another application.
When I attempt to export the database from the Azure portal I receive the following error:
One or more unsupported elements were found in the schema used as part of a data package. Error SQL71623: Model translation is not allowed because the model contains 1 errors.
When I attempt to export a data-tier application from SSMS I receive a similar error
===================================
One or more unsupported elements were found in the schema used as part of a data package.
Error SQL71623: Model translation is not allowed because the model contains 1 errors.
(Microsoft.SqlServer.Dac)
------------------------------
Program Location:
at Microsoft.SqlServer.Dac.DacServices.<>c__DisplayClass67_2.<ExportBacpac>b__2()
at Microsoft.Data.Tools.Schema.Sql.Dac.OperationLogger.Capture(Action action)
at Microsoft.SqlServer.Dac.DacServices.<>c__DisplayClass67_1.<ExportBacpac>b__0(Object operation, CancellationToken token)
at Microsoft.SqlServer.Dac.Operation.Microsoft.SqlServer.Dac.IOperation.Run(OperationContext context)
at Microsoft.SqlServer.Dac.OperationExtension.CompositeOperation.Microsoft.SqlServer.Dac.IOperation.Run(OperationContext context)
at Microsoft.SqlServer.Dac.OperationExtension.CompositeOperation.Microsoft.SqlServer.Dac.IOperation.Run(OperationContext context)
at Microsoft.SqlServer.Dac.OperationExtension.Execute(IOperation operation, DacLoggingContext loggingContext, CancellationToken cancellationToken)
at Microsoft.SqlServer.Dac.DacServices.ExportBacpac(Func`1 streamGetter, String databaseName, DacExportOptions exportOptions, IEnumerable`1 tables, CancellationToken cancellationToken)
at Microsoft.SqlServer.Dac.DacServices.ExportBacpac(String packageFileName, String databaseName, DacExportOptions options, IEnumerable`1 tables, Nullable`1 cancellationToken)
at Microsoft.SqlServer.Dac.DacServices.ExportBacpac(String packageFileName, String databaseName, DacSchemaModelStorageType modelStorageType, IEnumerable`1 tables, Nullable`1 cancellationToken)
at Microsoft.SqlServer.Management.Dac.DacWizard.ExportDatabase.DoWork()
at Microsoft.SqlServer.Management.TaskForms.SimpleWorkItem.Run()
I also attempted to run SQLPackage /Action:Extract /p:ExtractAllTableData=true.... which completed successfully, but when attempting to import the resulting file to a new database it fails with
=================================== Cannot create a BACPAC from a file that does not contain exported data. (Microsoft.SqlServer.Dac) ------------------------------ Program Location: at Microsoft.SqlServer.Dac.BacPackage..ctor(IPackageSource packageSource) at Microsoft.SqlServer.Dac.BacPackage.Load(String fileName, DacSchemaModelStorageType modelStorageType) at Microsoft.SqlServer.Management.Dac.DacWizard.ImportDatabase.DoWork() at Microsoft.SqlServer.Management.TaskForms.SimpleWorkItem.Run()
How can I find the unsupported element(s)?
Baring that what other option is available to me to create a bacpac file that can be imported to a new database?