Migrating NoSQL data store license from one Mango instance to another
We would like to transfer the nosql data store module license from a mango instance running on machine (A) to mango running on machine (B) . Machine (A) is does not require speedy statistics and point value results, unlike machine (B) which incorporates the dashboard module and needs faster API query response times. We need to restore data already in the nosql store on (A) back into a sql data store on (A) - so historic data can still be referenced in Mango (and DGLux).
Machine (A) is using mango core 2.5.2
Machine (B) is running mango core 2.7.10
read data out of nosql db on (A) and load into PointValues table on (A)
count the rows in the h2 embedded pointvalues table on (A). If the row count is the same as the nosql store, disable the nosql module on (A)
enable the nosql module on (B)
go to portal and associate nosql license with (B) instead of (A), so regular shutdown no longer triggers
import data from PointValues table in (B) into new nosql backend structure on (B)
Q1. Is there a simpler process?
Q2. For Step 1 above, Is there a guide for migrating from data in nosql back into the embedded H2 pointvalues table?
Have reviewed the database conversion doc here, but it doesn't mention how to move from point values stored in the NoSQL module back into H2 (or another db):
Q3. For Step 2 above, if we disable the nosql module first, can we still read the data out to migrate into the h2 embedded? This would allow data arriving in the meantime to flow into the pointvalues table. Alternately we could disable the publishers while the migration is taking place, and re-enable and sync when the migration is complete.
JoelHaggar last edited by
You can transfer the license but there is currently no way to convert a NoSQL database back to a SQL database. This would be a pretty easy feature for us to add so we'll consider that for the future.