Can't export and Azure SQL database to a bacpac file. Error SQL71623: Model translation is not allowed

Mike Welborn 56 Reputation points
2024-03-01T20:07:20.9033333+00:00

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?

Azure SQL Database
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.