Question Migration

We build a tool that helps to migrate questions & answers from a Confluence server to another server. Please download this tool here

Open

 and follow these steps to migrate questions & answers:

1. After downloading, extract the QuestionMigration.zip file to QuestionMigration folder, open Confluence.config file in this folder with Notepad

Open

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:

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

Open

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.