Error '... is not supported when used as part of a data package (bacpac).' when exporting bacpac from SQL Database

(0) Share

Report

Posted on by Mai.S

370

I'm now in the middle of upgrating data from AX2012 R2 (with SQL Server 2012) to Dynamics 365.

Everything went well during preparation of database "bacpac" file, which will be made in AX2012 and transfer into Dynamics 365 (Tier2 with SQL Azure)

Reference;

https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/migration-upgrade/upgrade-data-sandbox

However, when I run the export command from command prompt, many errors occured as below and the bacpac was not created.

Error SQL71564: The element Full-text Index on [dbo].[VENDTABLE] is not supported when used as part of a data package (bacpac).
Error SQL71564: The element Full-text Index on [dbo].[ECORESCATEGORYTRANSLATION] is not supported when used as part of a data package (bacpac).
Error SQL71564: The element Full-text Index on [dbo].[CATEXTERNALCATALOG] is not supported when used as part of a data package (bacpac).
Error SQL71564: Element Table: [dbo].[BUDGETMODEL] has an unsupported property IsChangeTrackingOn set and is not supported when used as part of a data
package.....

In this forum, I saw many post regarding import error of bacpac file, but not for exporting.

Have anyone faced and handle the related issue before?

Any reference or comment would be appreciated.

Best regards,
Mai

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

Hassan_rulz 3,801 on at

Like (0)

Report

It seems like issue with the table indexing.. have you tried disabling the index?

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

Hi Mai.S,

As this link shows:https://docs.microsoft.com/en-us/sql/relational-databases/system-functions/full-text-search-and-semantic-search-functions-transact-sql?view=sql-server-2017

Full-text search can be used in the sql-server but not in the azure database.So you should disable the index.

Besides according to the link:https://docs.microsoft.com/en-gb/azure/sql-database/sql-database-transact-sql-information

,there is many other T-SQL features and statements you should eliminate when you do the database migration.

Best Regards

Tom Cai

Was this reply helpful? Yes No
Mai.S 370 on at

Like (0)

Report

Hi Hassan and Tom,

Thank you both for your suggestions.

As Full-text search is no longer available in Azure SQL database,

I had to delete all Full-text Index in SQL Server 2012 database to create bacpac file. (disabling was not enough)

Thank you for your support.

Was this reply helpful? Yes No