Migrate from TestDB to productive DB

Connect to the embedded H2 database using DB Visualizer

DBVisualizer is just one database administration tool. You can use any administration tool that supports embedded H2 databases. The steps will be similar.

    Shut down Confluence.
    Back up your <confluence-home>/database directory.
    Launch DBVisualizer.
    Choose Create new database connection and follow the prompts to set up the connection. 
    The information you'll need is:
        Database driver: H2 embedded 
        Database Userid: sa
        Database password: leave this field blank
        Database filename:<confluence-home>/database/h2db
        (Warnung) leave off the .h2.db file extension.
    Connect to the database.

Al this i made but the message:

"Confluence is using the H2 embedded database. You should migrate to a supported database to ensure your data is safe."

is still coming.


How to migrate now?

1 answer

0 votes

There appears to be two totally unrelated things here.

  1. Some stuff about connecting to the database with a tool for direct reading, but with no actual question about it
  2. Migrating to a supported database for production - see https://confluence.atlassian.com/doc/migrating-to-another-database-148867.html

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Mar 12, 2019 in Confluence

Confluence Admin Certification now $150 for Community Members

More and more people are building their careers with Atlassian, and we want you to be at the front of this wave! Important Dates Start the Certification Prep Course by 2 April 2019 Take your e...

1,496 views 4 13
Read article

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