Database migrator

Flex.bi stores all data in a separate database. You can use the flex.bi database migration to migrate either all flex.bi data from one server to another or you can use it to migrate just couple flex.bi accounts from, for example, a production server to a test server.

If you would like to migrate an existing flex.bi database to a new server then, at first, set up a new flex.bi database and start flex.bi Enterprise using this new database. After the initial setup, go to System Administration / Settings and in the top navigation click System Administration and then from System administration tasks select Database migrator.

Source flex.bi database

In the first step specify the database connection parameters to the existing flex.bi database from which you would like to migrate data.

Click Continue and if there will be any problems with the database connection then the errors will be displayed. If the database connection is successful then the next page will be shown.

Select data for migration

The list of flex.bi accounts will be displayed which are available for import. If some of these accounts are disabled then it means that either they are already imported or there are existing accounts with the same name in the current flex.bi database.

Select all or some accounts that you would like to migrate and click the Migrate button.

The migration will copy the following data from the source database to the current database:

• Accounts
• Account users
• Source application definitions (without imported data)
• Source file definitions (without uploaded files)
• Cube definitions (with no data)
• Cube report definitions
• Calculated member formulas
• Dashboard definitions

After successful import, you will be redirected to the home tab.

Re-import source data

Only source application (like REST API or SQL) definitions will be migrated but no source data are migrated. After the migration, you need to go to the Source Data tab in each account and start the data import from all source applications. After the data import, you can go to the Analyze tab and open your existing reports.

Since only the database content is migrated, if you were using text files as your source data, you will have to manually move all of the source data from flexbi_private/data to your new server and place it in the same flexbi_private/data folder adhering to the same directory structure that was on the previous server.

If you had any uploaded source files then please re-upload them in the Source Data tab and re-import data from all source files.