It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

database migration tools for Oracle -> MSSQL

I want to switch the database for my existing Confluence instance.

As I have large data, the XML backup & restore scenario does not work.

So first of all, can I just do the following:

  1. Prepare the new database
  2. Stop Confluence
  3. migrate database content from current DB (Oracle) to new DB (MSSQL)
  4. Change database connections string in my confluence.cfg.xml
  5. Start Confluence

My questions:

  • Is there something more I have to keep in mind?
  • What migration tool can you suggest for step #3 ?

0 answers

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Confluence

Lessons and Learnings: Six Months of Working Remote [Discussion]

Hey there, folks! For most of us, the past six months- yes, you read that right- have been a journey. More people than ever before have pivoted to working remotely, and navigating being on-scre...

8,196 views 6 6
Join discussion

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you