Menu
I am trying to export a rather simple database using the Export Data-tier application and keep getting the following error:
One or more unsupported elements were found in the schema used as part of a data package. Error SQL71564: The element Extended Property: [dbo].[DailyResult].[ScanTypeID].[MS_Description] is not supported when used as part of a data package (.bacpac file).
I have removed the description for the indicated column, but continue to receive this error. Any ideas?
977
Exporting a deployed data-tier application (DAC) or database creates an export file that includes both the definitions of the objects in the database and all of the data contained in the tables. The export file can then be imported to another instance of the Database Engine, or to Azure SQL Database.
A data-tier application (DAC) is a logical database entity that defines all of the SQL Server objects - such as tables, views, and instance objects, including logins - associated with a user's database.
You can do as Amir978 suggested to remove the extended property, however, if you want to keep the extended property in your database and use Export, you can do this using the latest version of SQL Server Data Tools.
The latest update to Microsoft Azure SQL Database (Azure V12) added support for Extended Properties, and the DacFx Export operation has been updated to allow extended properties.
Alternatively, if you are targeting more than just Azure, you can use the Extract functionality to produce a dacpac. A dacpac is not limited to just the set of features supported on Microsoft Azure SQL Databases.
I hope this helps
Lonny
135
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
