Ability to export a Confluence Database to a .BACPAC format using export Data-Tier Application for Microsoft SQL Server Database

Problem

With recently introduced changes in Confluence 7.11 and above version,
it is not possible to export the Confluence Microsoft SQL Server database to a .BACPAC format to restore elsewhere, whereas it was previously possible to do so.

Steps to reproduce:

• Install Confluence version 7.11+ configured with a Microsoft SQL Server Database server version 2017
• Access the Confluence Database from for instance from SQL Server Management Studio:
  Right-click on the Confluence database -> Tasks -> Export Data-tier application
  • Such an export was working prior to version 7.11 for Confluence
  • Such an export stopped working for Confluence version 7.11+ , Such errors will occur in the Microsoft SQL Server Management Studio logs:

    One or more unsupported elements were found in the schema used as part of a data package.
    Error SQL71561: Error validating element [dbo].[denormalised_content_trigger]: Trigger: [dbo].[denormalised_content_trigger] has an unresolved reference to object [ConfluenceDBName].[dbo].[CONTENT]. External references are not supported when creating a package from this platform.
    Error SQL71562: Error validating element [dbo].[denormalised_content_trigger]: Trigger: [dbo].[denormalised_content_trigger] has an unresolved reference to object [ConfluenceDBName].[dbo].[CONTENT].[CONTENTID]. External references are not supported when creating a package from this platform.
    Error SQL71562: Error validating element [dbo].[denormalised_content_trigger]: Trigger: [dbo].[denormalised_content_trigger] has an unresolved reference to object [ConfluenceDBName].[dbo].[CONTENT].[CONTENTTYPE]. External references are not supported when creating a package from this platform.
    Error SQL71562: Error validating element [dbo].[denormalised_content_trigger]: Trigger: [dbo].[denormalised_content_trigger] has an unresolved reference to object [ConfluenceDBName].[dbo].[CONTENT].[PREVVER]. External references are not supported when creating a package from this platform.
    [...]
    

Since the recent changes introduced in Confluence 7.11 with some Denormalised triggers, The BACPAC export feature has stopped functioning for the Confluence DB as they are some explicit references to the DB name (and potentially other causes as well).

Suggested Solution

• Support the BACPAC export for Confluence Microsoft SQL Server Database

Why This Is Important

This third-party export to BACPAC can be important to be able to get a backup of the Confluence database to work on in a different environment or to move to Azure SQL.

Workaround

See this comment for a suggested workaround (versions 7.11.x-7.19.x).