Menu

Migrate Old MySQL database to PostgreSQL

Help
2015-11-03
2018-10-09
  • Gaston Arango Acosta

    Hi, Folks I have an old Runawfe Server running version 3.6.0 with MySQL 5.5.17 as database server under Windows S.O (Working Perfect). Now I have to implement a new server with RunaWFE Server 4.2.0 and PostgreSQL 9.2.10 as database server with RHEL Linux 7.1 as S.O.

    Now the biggest problem is that i must maintain all the history data related to 5 years from the workflows running on the MySQL Database, and also all the executors structure, permissions, swinlanes initializers etc, I Have resolved to install the workflows modeled for version 3 in version 4 with the V3 Backward Compatibility Option But I don´t know if exist a procedure to migrate all the data to the new Postgresql database and shotdown the old mysql Server ?

    Is this possible, I Really need help with this. Thanks in advance

    Grettings

     
  • Dofs

    Dofs - 2015-11-05

    Hi.
    There was MSSQL server patch which ports DB structure from v3.6 to v4.0: ru.runa.wfe.commons.dbpatch.impl.JbpmRefactoringPatch.
    You can use it as first approximation.

     
  • Gilberto Castillo

    Hi,
    Folks, I need migrate of version 3.6 to 4.x all data, because the tables there are different.
    ¿What are you recommend me?

     
  • Andrei Mikheev

    Andrei Mikheev - 2018-10-09

    Hello Gilberto,

    Why not to use two systems (3.6 and 4.3) simultaneously?
    3.6 - for old instances
    4.3 - for new instances

    Regards,
    Andrei

     

Log in to post a comment.