Missed Team ’24? Catch up on announcements here.

×
Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Products
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

Extracting Confluence data from SQL server directly

Jason Yeung
Jason Yeung June 6, 2022

Hi,

I used to have an on prem Confluence server, but the machine has crashed. I was only able to recover the SQL server database. I couldn't recover the Confluence program.

I want to export the data from SQL server with SQL queries and store them in CSV files (the export file type could change). I was wondering whether there are sample SQL queries around (or documentation on Confluence's data structure) that could assist me in obtaining the information I need?

Sincerely,

 

Jason

 

Answer
Watch
Like Be the first to like this
396 views

1 answer

0 votes
Nic Brough -Adaptavist-
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Become a leader
June 6, 2022

That would be, frankly, a nightmare to work with.  It's going to take you a LOT of work to extract the data, convert to CSV, then import it, and you've going to loose a lot of the data.

If the database was not damaged, then your best option is to simply build a new Confluence server, point it at the database and kick off a re-index.

Reply

Suggest an answer

Log in or Sign up to answer
Confluence
Confluence
DEPLOYMENT TYPE
SERVER
VERSION
4.15
TAGS
AUG Leaders

Atlassian Community Events

    See all events