Table of Contents Previous Next


5 Building the toolkit.properties File : 5.2 Defining a PostgreSQL URL

Migration Toolkit reads connection specifications for the source and the target database from the toolkit.properties file. Connection information for each must include:
If you are using PostgreSQL, specify postgresql for the sub-protocol value.
{SRC_DB_USER|TARGET_DB_USER}must specify a user with privileges to CREATE each type of object migrated. If migrating data into a table, the specified user may also require INSERT, TRUNCATE and REFERENCES privileges for each target table.
{SRC_DB_PASSWORD|TARGET_DB_PASSWORD}is set to the password of the privileged PostgreSQL user.

5 Building the toolkit.properties File : 5.2 Defining a PostgreSQL URL

Table of Contents Previous Next