Forum Discussion

Aparnaa_MS's avatar
Aparnaa_MS
Advocate III
5 months ago
Solved

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

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 ...
SQL database
  • v-achippa's avatar
    v-achippa
    5 months ago

    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

v-achippa's avatar
v-achippa
Community Support
5 months ago

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

Aparnaa_MS's avatar
Aparnaa_MS
Advocate III
5 months ago

Hi, 
yes thank you for the response, it cleared up some topics