Exporting database data

Exporting data from the database into a zip file can be useful when, for example, transferring information from a test environment to a production environment.

Use this procedure to export database data to a file.

  1. Right-click an environment and select Database > Export Database Data.

    You can also open the task by clicking Database > Export Database Data on the dashboard.

  2. Perform either of these options depending on the status of the environment:

    • If the environment is running, the message "Set M3 BE in maintenance mode" is displayed. Click Next.

    • If the environment is stopped, the environment will be started in maintenance mode.

      Note: The environment is in maintenance mode until the application is stopped, started, or set online.
  3. Specify the user ID and password of the database administrator.
  4. Click Next. The Select Configuration Option window is displayed.
  5. Select from these options:
    Export Database Data

    Select this option if you want to export specific data.

    Export database data using saved configuration

    Select this option if you want to export specific data using a saved configuration.

    Note: It is recommended to save the settings or configuration related to certain data, such as tables, that you use frequently to prevent you from providing the same data over and over again.
    Delete configuration

    Select this option if you want to remove a saved configuration.

    When the second and third options are selected, the Configuration field is enabled. It allows you to use or delete a saved configuration.

  6. Click Next. The Table Selection window is displayed.
  7. Specify this information:
    Component

    Select a component in the list. By default, MVX is selected.

    Database schema

    Depending on your selection of component, the correct schema is displayed in this field. This field is read-only and cannot be changed.

    Options

    Select one of these options for Table selection:

    • Export all tables - Exports all the tables.

    • Enter table name - Exports one specific table. Specify the name of the table.

    • Select tables - Displays a selection of tables.

  8. Click Next. The Target ZIP File window is displayed.
  9. Specify a unique file name to identify the exported data. This zip file will be saved in the file structure where M3 BE is installed, for example, in M3BE\_db_data\exported_data\tables.zip.
  10. Click Next. The Export Company and Division window is displayed.
  11. You can use predefined or advanced settings for selecting company and division:

    • To use predefined settings, specify this information:

      Include tables

      Select one of these filters:

      • All selected tables

      • All selected tables whose records contain company field

      Filter company

      Select this option if you want to export a specific company and division to a target company.

      Note: If you do not select this option, all fields except for the Include tables are disabled.
      Division filter

      Select one of these options:

      • All divisions - Export all divisions (includes records with no division).

      • Selected division - Specified division is exported (includes records with no division)

      Source Company

      Specify the source company number and division

      Target Company

      Specify the target company number and division

    • To use the advanced settings, specify the source selection and target values.

      See Manual selection of database data for copying.

  12. Click Next. The Advanced Copy Configuration window is displayed.
  13. Select the number of threads to be used for this export.
  14. Click Next. The Export data format window is displayed.
  15. Select one of these options:

    • Compressed LCM Data

    • XML

  16. Click Next. The Save Configuration window is displayed.
  17. Specify a unique name for the configuration. The configurations for Export Database Data are saved in the M3BE file structure in M3BE\_db_data\configuration\export\.
  18. Click Next. The Summary window is displayed.
  19. Verify the values provided and click Finish.
  20. When the task is finished, a window is displayed. Click OK or click View log. You can also go to the Logs tab to view the log file.