Export Data-tier application error

sql-server ssms bacpac ssms-2014
physics90 picture physics90 · Aug 21, 2014 · Viewed 10.7k times · Source

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?

Answer

Lonny Bastien picture Lonny Bastien · Mar 23, 2015

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

Related questions

How do I set a column value to NULL in SQL Server Management Studio?

How do I clear the value from a cell and make it NULL?

Read More
Insert Data Into Temp Table with Query

I have an existing query that outputs current data, and I would like to insert it into a Temp table, but am having some issues doing so. Would anybody have some insight on how to do this? Here is an …

Read More
How to see query history in SQL Server Management Studio

Is the query history stored in some log files? If yes, can you tell me how to find their location? If not, can you give me any advice on how to see it?

Read More