web stats
How to migrate complete data/logs from Derby database to SQL Server in Mirth Connect - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 09-17-2018, 04:52 AM
inaam inaam is offline
What's HL7?
 
Join Date: Sep 2018
Posts: 1
inaam is on a distinguished road
Default How to migrate complete data/logs from Derby database to SQL Server in Mirth Connect

Hi,

I hope everyone is fine here.

We have to change database type from "Derby" to "Sql Server" due to large volume in production environment.

Although there is a "Backup Config" link under the Server Tasks heading. But clicking it exports all configuration and channels not complete logs.

Please let us know way forward if anyone has any idea.

Thanks!!
Reply With Quote
  #2  
Old 09-19-2018, 01:51 PM
agermano agermano is offline
Mirth Guru
 
Join Date: Apr 2017
Location: Indiana, USA
Posts: 894
agermano is on a distinguished road
Default

You can export/import messages from individual channels through the GUI or the API.


If you need more than that, maybe try http://squirrel-sql.sourceforge.net/ or https://dbeaver.io/. Shut down your mirth server, and you should be able to open the derby database in one of these other programs and export or migrate it.
Reply With Quote
Reply

Tags
backup data, backup logs, mirth, moving mirth data

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -8. The time now is 11:14 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Mirth Corporation