How do I migrate my operational database from MySQL to PostgreSQL?
Last Updated: | Applicable Hub Versions: 24.2 and later
Answer
Note: This migration process is supported for Planview Hub version 24.2 and later. If you wish to migrate before upgrading to 24.2, or to another database other than PostgreSQL, please follow these instructions.
- Download any supported version of Postgresql and create the database and user as instructed here
- Download the JDBC JAR file, according to the Java version Hub is using, from this page
- Rename the JAR file to target-database-driver.jar
- Place the JAR file in the /jdbc-drivers folder
- Create a JSON file with the name tasktop-target-db.json, then input the below after adding appropriate information from the Postgres database:
{
“url”:”jdbc:postgresql://{host}:{port}/{databaseName}”,
“username”: “{user}”,
“password”: “{password}”
}
6. Save this file in the same location as tasktop-db.json ,which will be located within the /db folder
7. Restart Hub
On Windows, the /jdbc-drivers and /db folders are available inside the data directory of Hub (the default data directory location is C:\ProgramData\Tasktop unless modified by the user). On Linux, both folders will be available in the installation directory.
Enterprise Data Stream migration
For EDS data migration, we recommend using the AWS Database migration service to migrate from MySQL to PostgreSQL as it supports version specific functionalities.