Migration tools for DB2 migration to MySQL

Hi,

I am looking for migration tools for database migration from DB2 9.7 to MySQL 5.5. As DB2 is no longer supported for Confluence 5.x we decided to switch to MySQL. XML Backup is not an option as we have large datasets.

Has anybody experiences on this topic?

Thanks!

Nina

2 answers

Hey Nina,

One approach you can try is the following:

  1. Generate a Confluence XML Backup of production.
  2. Take note of all your third party add ons.
  3. In a test instance install a fresh confluence in the same version of prod.
  4. During the installation add your license.
  5. Point Confluence to your newly installed mysql database.
  6. After the database setup step you will be prompted with 3 options (example site, empty site, restore from backup).
  7. Choose restore from backup.
  8. Use the xml backup of step 1.
  9. Install all your third party add ons.
  10. Profit!

Once you do the procedure in test and works all you need to do is to repeat in a production server.

In case you have a medium to big instance (500 users or more), let me know so I can provide you a little different set of steps since the above might not work for a large instances with several attachmetns due to out of memory errors.

Thanks and Regards,
David|Confluence Support Engineer

Hi David,

thanks for the answer! We already tried the XML Backup but had to kill the process before even starting the export as CPU went up to 100% while rendering the pagetree. It is a large space with 88.233 pages.

Regards,

Nina

Sometimes we have to do some kind of such migrations for our customers and found the workaround: we make a copy of instance with database etc into amazone ec2 server - create that one much larger for memory and with set of CPU cores - then make the backup there - then restore on the new configuration there - and then clone to normal instance. Even for huge instances that will cost ~10-20 dollars if do that fast.

Hey Nina, Based on that that bellow procedure: 1 - Generate a xmlbackup without attachments. 2 - Install a fresh Confluence on the same version as production. 3 - Make sure to install this new confluence with the same <Confluence Home> directory structure as production (if the <Confluence Home> is in c:\atlassian\<confluence Home> the target server needs to be exact the same). 4 - Once you see the input license page, shutdown Confluence. 5 - Follow the below guide so you can increase confluence memory as much as you can in the new installation server: https://confluence.atlassian.com/display/CONFKB/How+to+Fix+Out+of+Memory+Errors+by+Increasing+Available+Memory#HowtoFixOutofMemoryErrorsbyIncreasingAvailableMemory-Step2:IncreaseAvailableMemory 6 - After you do that start Confluence again and try to import the xml backup without attachments. 7 - Once you are done shutdown confluence again. 8 - Copy the attachments folder from production and drop it into your new <Confluence Home> directory. # Start Confluence and check if your attachments are there. # Profit! Let me know if that works. Thanks and Regards, David|Confluence Support Engineer

Nina,

I heard about this product that promises what you're trying to achieve:
http://www.ispirer.com/products/db2-to-mysql-migration
You might want to have a look in their demo and free express version.

Cheers,
WZ

Hi WZ,

thanks for the link!

Regards,

Nina

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Posted Jul 10, 2018 in Confluence

We want to see the templates you've created in Confluence!

Hi Community, Jessica here from the Confluence Product Marketing team!  July’s community challenge is all about sharing pictures  — and as an extension of our first post on what ...

830 views 23 12
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you