How to migrate mingle from postgres to oracle?




  • Avatar
    Adam Monago

    Hi James,

    The 2.3.1 release due out within the next two weeks will contain a migration tool to help you move your project data from mysql or postgres to oracle.  In the short term, you may want to review the configuration settings for oracle that we have tested for Mingle here.  Please note that these docs are in progress until the actual release, but feel free to post questions here.

    In the short term, you may want to upgrade to 2.3 on postgres so you can start reaping the benefits of the numerous performance enhancements, features and bug fixes, while you test an oracle install in your environment.


  • Avatar
    James Weaver

    Thanks Adam, I'm working on install of 2.3 while keeping postgres in place now.  I was mainly hoping to get a DDL so I can get our database admins preparing the database for us in advance.  That may be in the 2.3 directory somewhere (since a new installation would have to create the oracle data tables); haven't poked around in there yet.

  • Avatar
    Badri Janakiraman

    James - Mingle creates and manages its own schema, primarily because the Mingle schema is dynamic. Thus Mingle does not ship with a static raw SQL DDL that you can use to prep your database. We will have recommenedations for how to set up an Oracle database to work with Mingle up along with the 2.3.1 release.

  • Avatar
    James Weaver

    Okie doke - I await with baited breath ;-).

Please sign in to leave a comment.