Editing the configuration file for the migration

Last Updated : Feb 10, 2025 |
Prolog information
Metadata
Keywords:
Use this procedure to edit the config.properties file extracted using the migration script. You can edit the file in a text editor to suit your migration requirements.
In this procedure, the source database refers to an Oracle or a PostgreSQL server, and destination refers to the MS SQL server.
Note:
This procedure describes a worked example using Notepad. You can use any text editor.
Before you begin
Extract the script and its configuration file to a new folder on your Windows server.
  1. Open the Windows start menu and type notepad into the search bar.
  2. Click the Notepad icon.
  3. Click FileOpen and navigate to the location of the configuration file.
  4. Select the file from the list of files and click Open.
    STEP RESULT:
    The file you select opens in Notepad and is ready for you to edit.
  5. Depending on your requirements, set the sourceDbType attribute to oracle, postgres, or mssql.
  6. Enter the details in the following fields for the source database:
    ADDITIONAL INFORMATION:
    • In sourceServer, enter the IP address of the source server.
    • In sourcePort, enter the port for Oracle, PostgreSQL, or MS SQL.
    • In sourceDatabase, enter the source server database name.
    • In sourceSchema, enter the source server database schema name.
      Enter the value in this field only for Oracle servers.
    • In sourceUser, enter the source server username.
  7. Enter the details in the following fields for the destination database:
    ADDITIONAL INFORMATION:
    • In sqlServer, enter the MS SQL server IP address.
    • In sqlPort, enter the MS SQL server port.
    • In sqlDatabase, enter the MS SQL server database name.
    • In sqlUser, enter the MS SQL server username.
  8. Enter the details in the following fields for the source and destination databases:
    ADDITIONAL INFORMATION:
    • In sourcePassword, enter the password of the source server.
    • In sqlPassword, enter the password of the MS SQL server.
    Note:
    If you do not enter the details during pre-migration, provide the passwords when running the migration script.
  9. When you are ready to save the configuration file, click FileSave.