Finedb (built-in Hsql database) migrating data to MySQL

Finedb (built-in Hsql database) migrating data to MySQL

1. Preface

In Finebi, the data of the decision platform (user, role, organization, authority, and so on) is stored in the Finedb database, and Finedb is a built-in Hsql database by default. The Hsql database has some drawbacks: general performance, poor stability, difficulties in detecting real error messages, inability to support distributed deployments, and to address the limitations of the Hsql database, we have introduced a plugin that can help users migrate data from previously stored hsql to MySQL or Oracle or SQL Server.

2. Precautions

The plug-in used here is: FS Platform migration plugin, FINEBI data transfer plug-in, can be downloaded to local. Two plug-ins are installed, the plug-in installation is visible finedb the third part of the migration data.

3. Steps to use

After installing the plug-in, restart the server as an administrator to open the decision platform, we can see the Management menu under a "Platform data Migration" menu, click on this menu, you can see a "platform Configuration" interface:

Finedb (built-in Hsql database) migrating data to MySQL