Source and target database configuration

With Unicode migration you can move the data from one database to another. The databases must be from the same vendor. For example, from an Oracle server database to another Oracle Server database. You can migrate one (BSE) environment and also from multiple (BSE) environments.

Single (BSE) environment

Basically the procedure of the migration with a source and a target database equals the in-place conversion.

Preparation

Run all preparation steps within the source database linked to the (BSE) environment as described in Preparation.

Conversion

Follow the conversion process up to step 2 in Conversion. After this step you must complete these steps:

  1. Create the new (target) database.

    Note the database configuration as mentioned in step 3 in Preparation.

    Grant the same database privileges to the user which was used during the preparation part.

    For configuration information see the latest version of these guides

    • Infor Enterprise Server Technical Reference Guide for Oracle Database Driver
    • Infor Enterprise Server Technical Reference Guide for Microsoft SQL Server Database Driver
  2. Link the new database to the (BSE) environment. Modify the name of the service in the <BSE>\lib\tabledef6.2 file.

    For Oracle: <service_name> / SID ID <oracle_sid>

    For Microsoft SQL Server name of the server: <server>

    See Database connection strings

  3. Continue with step 4 up to the last step of the process in Conversion.
  4. After the conversion of all companies is successfully completed, complete these steps:
    1. Update the database configuration (parameter) in the Database definitions (ttaad4110s000) sesion. It must match the processed runtime change mentioned earlier in the <BSE>\lib\tabledef6.2
    2. Grant all LN users the appropriate access to the new database.