Importing from an M3 BE environment database

Use this procedure to import database tables from another M3 BE environment database that can be used instead of exporting and importing database data from file.

  1. Right-click your target environment and select Database > Import from M3BE Environment Database.
    Note:  You can also open the task by clicking Database > Import from M3BE Environment Database 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 started or set online.
  3. On the M3 Business Engine copy window, specify this information:
    Source M3 BE

    Select the source M3 BE environment in the list.

    Source database administrator login

    Specify the user ID and password of the source database administrator.

    Target database administrator login

    Specify the user ID and password of the target database administrator.

  4. Click Next. The Select Configuration Option window is displayed. Select one of these options for importing data:
    Import from database

    Select this option to import specific data.

    Import from database using saved configuration

    Select this option to import specific data using saved configuration.

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

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

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

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

    Select the source component. For an additional component, select the component specified in the Environment Configurator Components pane (MNS104). For standard M3 BE without any modification, select the MVX component.

    Source database schema

    Depending on your selection of component, the applicable schema is displayed in this field.

    Options

    Select one of these options for Table selection:

    • Import all tables Imports all the tables.

    • Enter table name - Imports one specific table. Type the name of the table.

    • Select tables - Displays all tables in a list. Select the tables to import data from.

  7. Click Next. The Target Database window is displayed.
  8. Specify this information:
    Target Component

    Select the target component. For an additional component, select the component specified in the Environment Configurator Components pane (MNS104). For standard M3 BE without any modification, select the MVX component.

    Target database schema

    Depending on your selection of component, the correct schema is displayed.

  9. Click Next. The Import Company and Division window is displayed.
  10. 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 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.

  11. Click Next. The Advanced Copy Configuration window is displayed.
  12. Select the number of threads to be used and click Next.
  13. The Import Strategy window is displayed. Specify this information:
    Replace existing records

    The records in target that have a duplicate in the source are replaced by the ones imported.

    Keep existing records

    The existing records in both source and target are left unchanged in the target.

    Copy tables without checking for duplicate keys

    All records will be inserted without checking for duplicate keys. This can cause an exception if records already exists.

    Note: This option is recommended when the target database is empty and in other situations when there is no risk of duplicate keys. This option increases the copy data performance significantly.
    Clear target tables before import

    For tables that exist in both source and target, data are cleared in target tables before import.

    Allow data mismatch

    Select this option to allow the format of the existing table and the imported tables to differ without causing any errors.

  14. Click Next. The Save Configuration window is displayed.
  15. Specify a unique name for the configuration.

    The configurations for Import from M3BE Environment Database are saved in the M3BE file structure in M3BE\_db_data\configuration\import\.

  16. The Summary window is displayed.
  17. Verify the values provided and click Finish.
  18. 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.