BACPAC import fails in Fabric SQL DB when Full‑Text objects exist – is it expected?

[Aparnaa_MS]

Hi, when I'm trying to importing a .bacpac file into SQL DB it succeeds when there are no Full‑Text objects present, but fails when the source contains Full‑Text indexes/, mostly since Fabric SQL DB doesn’t support Full‑Text indexing.

If I remove the Full‑Text objects before export, the import succeeds.

Is this an expected behavior?

[v-achippa]

Hi @Aparnaa_MS,

Thank you for reaching out to Microsoft Fabric Community.

Yes, this is expected behaviour. Fabric sql database does not currently support Full-Text indexing. When a BACPAC contains Full-Text objects, the import fails because unsupported schema elements cannot be created.

The recommended approach is to remove Full-Text indexes prior to exporting the BACPAC. After removing them, then the import into fabric sql db should succeed.

Please refer below document:

https://learn.microsoft.com/en-us/fabric/database/sql/limitations

Thanks and regards,

Anjan Kumar Chippa