Skip to main content
Language Selector

  1. Other Languages

    (machine translation)

Planview Customer Success Center

Deprecated Database Migration

  1. Last updated
  2. Save as PDF

How to migrate operational database from MySQL to PostgreSQL

  1. Download any supported version of Postgresql and create the database and user as instructed here
  2. Download the JDBC JAR file, according to the Java version Hub is using, from this page
  3. Rename the JAR file to target-database-driver.jar
  4. Place the JAR file in the /jdbc-drivers folder 
  5. 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.