I see that oracle support is included in 2.3. We are about to upgrade from 2.1 to 2.3, during or after which we'd like to migrate all of our mingle project data away from postrgres and into our existing oracle 10g environment.
Don't see any instructions to perform the migration, though.
How to migrate mingle from postgres to oracle?
Comments
4 comments
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
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.
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.
Okie doke - I await with baited breath ;-).
Please sign in to leave a comment.