Migration from server/Data Center to cloud

This page explains the migration support details for the SQL for Confluence app data from the server/Data Center to the cloud.

Before migrating your SQL for Confluence app content from server/Data Center to the cloud, we recommend reading the Cloud migration guide to plan your migration.

Pre-requisites

Install the latest version of the SQL for Confluence app on your cloud instance.
Ensure you have Confluence Cloud Migration Assistant installed on the Data Center instance.

Administrators must ensure that the following feature flag is enabled in the server/Data Center instance as a part of the pre-migration setup:

migration-assistant.app-migration.feature: <Confluence_URL>/admin/darkfeatures.action

Refer to the Getting started Atlassian page for more information about the prerequisites for the migration.

Migration process

Before you begin, ensure you have all the required applications installed on the Data Center and the cloud. Refer to Prerequisites.
Confluence instance migration -
- Use the Confluence Cloud Migration Assistant app to migrate everything you need from Confluence Server/Data Center to Atlassian Cloud.
- The Confluence Cloud Migration Assistant provides a detailed step-by-step procedure to migrate the required content. Atlassian does this job for you in most cases.

All global configuration data in the Configuration page is transferred from the server/DC instance to the cloud instance.
Profile configuration data migration is not supported. Administrators are required to manually create profiles as required to avoid issues rendering SQL content on Confluence pages.
If multiple migrations are performed on the same cloud instance, the latest migration takes precedence.
Any subsequent migrations performed on the same cloud instance only adds or merges the data, but does not delete any existing data.

Important information:

The migration of data from server/DC to cloud is an independent process from app installation or configuration in your cloud instance. We recommend that administrators verify that all your data (configuration as well as your Confluence pages) are displayed properly after the migration process is completed. To report any issues, open a support ticket.

Differences between server/Data Center and cloud versions

Out of the macros available in the server/DC version, only the SQL Query macro is supported in the cloud version for this release.

The following table lists the macro parameters and features that work differently in server/Data Center and cloud:

Last updated Nov 20, 2025

Configuration type (Global, Profile, or Macro)	Parameter/Feature	Server/Data Center	Cloud	Notes

Configuration type (Global, Profile, or Macro)	Parameter/Feature	Cloud	Notes
Global	Rows per page
Profile	Driver class/Driver JAR location
	Limit max active
	Connection string
	Show SQL option
	Execution of multiple SQL statements (Initial SQL/Before SQL/After SQL)		Due to technical limitations, the app currently does not support handling of multiple SQL statements in the cloud version.
	AWS IAM user authentication method (AWS IAM/ AWS region/ Key ID/Secret Access Key)
	Application server based data source profiles	Not applicable
Macro	Default profile option
	Parameters/Auto commit SQL statements
	Options for showing SQL code		In the cloud version, the macro displays SQL statements or scripts in the SQL format. Thus, the parameter is not required in the cloud version.
	Output format
	Show results as a table
	Show number of rows updated
	Wiki markup related fields (Render wiki markup macros in body/Show generated wiki markup/Escape special wiki characters)	Not applicable	This feature is not supported in Confluence Cloud.
	Expand array fields
	Table styles related fields (Table id/Table class/Table style/Table width/Border width)
	Enable download and export as an attachment/File delimiter...
	Column type/Column attributes/Apply column attributes to header rows
	Total type
	Auto number column styles
	Sorting related fields (Enable sorting on auto number column/Enable column sorting/Automatically sort in descending order/Display sort icon/Sort tip text)
	Auto total numeric columns
	Apply Column styles to column cells/Apply Row styles to row cells/Retain row style order after re-sorting	Not applicable	In the cloud version, the table in the Preview pane itself supports styling of specific row(s) and column(s). Thus, the specified parameters are not applicable for use in the cloud version.
	Number of header rows/Header row styles
	Enable row highlighting on mouse over
	Highlight colour	Not applicable	In the cloud version, the table in the Preview pane itself supports highlighting of rows and columns. Thus, the specified parameter is not applicable for use in the cloud version.
	Number of rows to be displayed on one page

All the other parameters function the same in both versions of the app.

Problem reporting

If you experience any unexpected problems or behavior changes, do not hesitate to open a support ticket. This helps us identify and prioritize fixes and improvements.