Migration from server/Data Center to cloud
Description
Before migrating your SQL for Confluence app content from server to cloud, we recommend reading this Atlassian article to plan your migration.
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 page from Atlassian for more information about the prerequisites for the migration.
This page explains:
Migration process
Differences between the server/DC and cloud version of the app
Migration process
Confluence instance migration - Use the Confluence Cloud Migration Assistant app to migrate everything you need from Confluence Server/Data Center to Atlassian Cloud. Confluence Cloud Migration Assistant explains in detail the step-by-step procedure to migrate the required content. As mentioned in the previous section, Atlassian does this job for you in most cases.
App installation - Install the app from the Marketplace.
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/DC and cloud:
Configuration type (Global, Profile, or Macro) | Parameter/Feature | Server/DC | Cloud | Notes |
|---|---|---|---|---|
Global | Rows per page | Not supported | Supported | |
Profile | Driver class/Driver JAR location | Supported | Not supported | |
Limit max active | Supported | Not supported | ||
Connection string | Supported | Not supported | ||
Show SQL option | Supported | Not supported | ||
Execution of multiple SQL statements (Initial SQL/Before SQL/After SQL) | Supported | Not supported | 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) | Not supported | Supported | ||
Application server based data source profiles | Supported | Not applicable | ||
Macro | Default profile option | Supported | Not supported | |
Parameters/Auto commit SQL statements | Supported | Not supported | ||
Options for showing SQL code | Supported | Not applicable | 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 | Supported | Not supported | ||
Show results as a table | Supported | Not supported | ||
Show number of rows updated | Supported | Not supported | ||
Wiki markup related fields (Render wiki markup macros in body/Show generated wiki markup/Escape special wiki characters) | Supported | Not applicable | This feature is not supported in Confluence cloud. | |
Expand array fields | Supported | Not supported | ||
Table styles related fields (Table id/Table class/Table style/Table width/Border width) | Supported | Not supported | ||
Enable download and export as an attachment/File delimiter... | Supported | Not supported | ||
Column type/Column attributes/Apply column attributes to header rows | Supported | Not supported | ||
Total type | Supported | Not supported | ||
Auto number column styles | Supported | Not supported | ||
Sorting related fields (Enable sorting on auto number column/Enable column sorting/Automatically sort in descending order/Display sort icon/Sort tip text) | Supported | Not supported | ||
Auto total numeric columns | Supported | Not supported | ||
Apply Column styles to column cells/Apply Row styles to row cells/Retain row style order after re-sorting | Supported | 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 | Supported | Not supported | ||
Enable row highlighting on mouse over | Supported | Not supported | ||
Highlight colour | Supported | 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 | Not supported | Supported |
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.
Need support? Create a request with our support team.