Azure SQL Database
An Azure relational database service.
6,338 questions
Can't export and Azure SQL database to a bacpac file. Error SQL71623: Model translation is not allowed
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(160, 7.000000000000001%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMW%3C/text%3E%3C/svg%3E)
Mike Welborn
56
Reputation points
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
-
Oury Ba-MSFT 20,926 Reputation points Microsoft Employee Moderator2024-03-01T23:55:38.3333333+00:00 Thank you for reaching out and sorry about the issue you are facing.
I know that you are trying to export a bacpac file to an Azure SQL Database and all the methods that you are tried so far gave you an 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.Did you had the chance to check the limitations in this doc https://learn.microsoft.com/en-us/azure/azure-sql/database/database-export?view=azuresql.
Ensure that your schema doesn’t include unsupported elements (e.g., CLR assemblies, extended properties, or specific data types). Trying to examine the Database schema.
BACPAC exports have limitations. Some features might not be supported.
Regards,
Oury
-
Mike Welborn 56 Reputation points
2024-03-04T14:37:28.15+00:00 Thank you. I read the article in its entirety, but I didn't see where it detailed elements that are unsupported. You gave the example of "CLR assemblies, extended properties, or specific data types", but I don't see any reference to any of those. As such I don't know what to look for in the schema to see if it might be an offending element.
As a side note/comment this is what is frustrating with the error message. It knows it found a problem and presumably it knows where, but it doesn't display the element it failed on.
Do you know if there is any way to get more detail or log of the error?
-
Mike Welborn 56 Reputation points
2024-03-04T15:53:45.12+00:00 Thank you Oury.
I did read through the article referenced, but I am not finding any reference to schema limitations. You made reference to "(e.g., CLR assemblies, extended properties, or specific data types)". I don't know where you found that information.
Additionally, if anyone knows a way to get log information from the export that might provide more detail, I would love to try that.
-
Oury Ba-MSFT 20,926 Reputation points Microsoft Employee Moderator
2024-03-07T23:35:05.7033333+00:00 Sorry about the misunderstanding, what version of sql package are you using.?
You can use sqlpackage export command: SqlPackage - SQL Server | Microsoft Learn
It will create a bacpac instead of a dacpac
If you use dacpac extracted, you have to use publish
Regards,
Oury
-
Mike Welborn 56 Reputation points
2024-03-08T15:11:50.56+00:00 Thank you - let me try that option.
-
Oury Ba-MSFT 20,926 Reputation points Microsoft Employee Moderator
2024-03-08T22:14:07.5733333+00:00 -
Oury Ba-MSFT 20,926 Reputation points Microsoft Employee Moderator
2024-03-12T20:23:08.9533333+00:00 -
Mike Welborn 56 Reputation points
2024-03-19T21:35:14.79+00:00 Apologies for the delay.
I wasn't able to create the bacpac file. As a work around I ran a script to drop all non-data elements (views, functions, procedures, etc.) on the database from which I wanted to create the bacpac file.
That was successful. I was able to restore the database, but of course had to apply the dacpac file against it to recreate the non-data elements.
Somewhere embedded in one of those elements was the offending code. Too much to go through.
Thank you for following up.
Sign in to comment
Sign in to answer