The Database Migration Tool is available through the BDB Server 6 Migration Tools application. This tool is used to migrate a database from BDB Server 5 into an installation of BDB Server 6. When open, the command can be run manually or scripts can be predefined and run from application prompt.
The following parameters can be specified for the Database Migration tool:
Parameter | Description |
|---|---|
--help | Display the help explaining the available options. |
--source-uri | A string specifying the URI to the BDB Server 5.x database containing the inputs to be migrated. This is specified as where, • username and password are the credentials for an administrator user, • hostname is the name of the computer on which the BDB Server 5 database is stored, and • database name is the name of the BDB Server 5 database to be migrated. |
--destination-uri | A string specifying the URI to the destination BDB Server 6.x instance. This is specified as where, • username and password are the credentials for an administrator user in BDB Server 6, • hostname is the name of the computer on which the Docker container is configured to store the database, and • port is the port number specified during installation to connect BDB Server to PostgreSQL. |
--database-name | The name of the destination database. If not provided, the name of the source database will be used. This parameter is optional. |
--log-folder | The name and location of the folder in which log files will be created. This parameter is optional. |
--environment | The location of the environment.xml file that contains configuration settings for BDB Server. If this parameter is not specified, the application will check for the file in a local BDB Server 5.x installation location. This parameter is optional. |
To run the Database Migration tool:
1. Launch the BDB 6 Migration Tools from the Windows Start menu.
A command prompt window will be displayed.
2. Run a command similar to the following, specifying the database to be migrated:
bdb6migration.exe --source-uri bdb://username:password@DatabaseComputerName/databasename --destination-uri http://username:password@DockerContainerComputerName:8080
Details about the progress are displayed as the migration is completed.
3. Repeat the process for each database to be migrated.
4. Type Exit and press the Enter key to close the Migration Tools.
The specified databases from BDB Server 5 are now available in BDB Server 6.