Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.

Radix IoT Website Mango 3 Documentation Website Mango 4 Documentation Website

Conversion from NoSQL to MySQL


  • Hi,
    which is the best way to convert a NoSQL database to MySQL avoiding data loss?

    Thanks.

    Stefano


  • Stefano,

    There is no tool built into the NoSQL module to export the data to an SQL database. Depending on your level of technical skill you could extract the data from the REST api and then import it into an SQL database using many 3rd party tools.

    If we are talking about converting data from a Mango instance running on NoSQL to a Mango instance running on MySQL:

    1. You could try to export and import the data using export and import as CSV functionality.
    2. You could publish all the data to a new instance running on MySQL using the Persistent TCP module
    3. There would also be ways to write Meta Data source scripts and Scripting data source scripts to do this, this again is quite technical so I won't go into it here.