How to migrate mingle from postgres to oracle?

Follow

Comments

4 comments

  • 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.



    Cheers,
    Adam

    0
    Comment actions Permalink
  • 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.

    0
    Comment actions Permalink
  • 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.



    0
    Comment actions Permalink
  • Avatar
    James Weaver

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

    0
    Comment actions Permalink

Please sign in to leave a comment.