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 doesn’t support Full‑Text indexing.

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

Is this an expected behavior?

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

5 Replies

  • 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

       

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

      Hi Aparnaa_MS,

       

      As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance.

       

      Thanks and regards,

      Anjan Kumar Chippa

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

        Hi @Aparnaa_MS,

         

        We wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance.

         

        Thanks and regards,

        Anjan Kumar Chippa

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

    Hi Aparnaa_MS,

     

    Thank you for the update. Thank you for reaching out to Microsoft Fabric Community.

     

    Thanks and regards,

    Anjan Kumar Chippa