Question Migration
We build a tool that helps to migrate questions & answers from a Confluence server to another server. Please download this tool here
and follow these steps to migrate questions & answers:
After downloading, extract the QuestionMigration.zip file to QuestionMigration folder, open Confluence.config file in this folder with Notepad
The first line is the database type and the connection string to your Confluence database which has the questions & answers that you want to migrate from (SOURCE)
The second line is the database type and the connection string to your Confluence database which you want to migrate questions ans answer to (DESTINATION)
[MSSQL] ;# Data Source=.;Initial Catalog=confluence_source_database;Integrated Security=False;User ID=user;Password=password;
Server=10.2.32.218;Port=5432;Database=confluence_destination_database;User Id=userId;Password=password
+ Database types and connection string:
Database types: Here are some values for some database types:
Database | Type |
|---|---|
Microsoft SQL | [MSSQL] |
MySQL | [MYSQL] |
PostgreSQL | [PGSQL] |
Oracle | [ORSQL] |
Connection string: use correct connection string of your database to migrate questions
Example:
+ Oracle: [ORSQL] ;# Data Source=192.168.1.11:1521/orcl;User ID=confluenceuser;Password=mypasword;
+ PostgreSQL: [PGSQL] ;# Server=10.2.32.218;Port=5432;Database=confluence;User Id=userId;Password=PASSWORD
+ SQL Server: [MSSQL] ;# Data Source=.;Initial Catalog=confluence;Integrated Security=False;User ID=user;Password=password;
Save the Confluence.config file after editing.
2. Click on the QuestionMigration.exe file to migrate questions & answers
3. After migrating successfully, go to the Rebuild Search Index page in Confluence administration and click rebuild
You have finished migrating questions & answers to Questions & Answers and ready to use!
Limitation: This tool cannot migrate attachment files in questions.