Geek Answers Handbook

Error exporting data level data

I try to export a fairly simple database using the Export Data-level application and save the following error:

One or more unsupported elements were found in the schema used as part of the data packet. Error SQL71564: Element Extended Property: [dbo]. [DailyResult]. [ScanTypeID]. [MS_Description] is not supported when used as part of a data package (.bacpac file).

I deleted the description for the specified column, but keep getting this error. Any ideas?

+4
source share
3 answers

Cannot delete Description manually. Instead, try this script:

GO
EXEC sp_dropextendedproperty 
    @name = N'MS_Description'

    ,@level0type = N'Schema', @level0name = dbo
    ,@level1type = N'Table',  @level1name = 'tableName'
    ,@level2type = N'Column', @level2name = 'fieldName';
GO
+1
source

, Amir978 , , Export, , SQL Server.

Microsoft Azure SQL (Azure V12) , DacFx , .

, , Azure, Extract dacpac. Dacpac , SQL Azure SQL.

,

+1

I had a link to the database in the intruder object. As soon as I delete it, it is exported without problems. I changed;   [MyDatabase].[Work].[Job] at   [Work].[Job]

0
source

More articles:


All Articles