Skip to Content.
Sympa Menu

grouper-dev - [grouper-dev] RE: migrating from MYSQL to Oracle

Subject: Grouper Developers Forum

List archive

[grouper-dev] RE: migrating from MYSQL to Oracle


Chronological Thread 
  • From: "Hyzer, Chris" <>
  • To: "Black, Carey M." <>, "" <>
  • Subject: [grouper-dev] RE: migrating from MYSQL to Oracle
  • Date: Tue, 22 May 2018 17:52:26 +0000
  • Accept-language: en-US
  • Authentication-results: spf=none (sender IP is ) ;
  • Ironport-phdr: 9a23:B2VTbRwksJxPJYLXCy+O+j09IxM/srCxBDY+r6Qd2u0UIJqq85mqBkHD//Il1AaPAd2Araocw8Pt8InYEVQa5piAtH1QOLdtbDQizfssogo7HcSeAlf6JvO5JwYzHcBFSUM3tyrjaRsdF8nxfUDdrWOv5jAOBBr/KRB1JuPoEYLOksi7ze+/94HdbglSmDaxfa55IQmrownWqsQYm5ZpJLwryhvOrHtIeuBWyn1tKFmOgRvy5dq+8YB6/ShItP0v68BPUaPhf6QlVrNYFygpM3o05MLwqxbOSxaE62YGXWUXlhpIBBXF7A3/U5zsvCb2qvZx1S+HNsDtU7s6RSqt4LtqSB/wiScIKTg58H3MisdtiK5XuQ+tqwBjz4LRZoyeKfhwcb7Hfd4CRWRPQNtfVzBPDI2/YYsADesBMvpXoYbyvFYOsQK+CRWwCO/z1jNEmHn71rA63eQ7FgHG2RQtE9wMvnXUrdT6Kr0SXfiox6TWzTXDdfJW2Szz5IPVdR0hpO2DXbJwcMvQ10YvDRjIjlSLqYP5JT+Vy/wNvHad7+pmT+6glXMoqxxorzWp28wiiZHJi5oLxlzY9yh12ok4KNyiREJmYNOpHoFcui6ZOoduX88vTX1ktDw+x7Ebo5K3YjUGxZA9yxLCafGKcpCE4hz9W+uSPTt1gXdodba7ihu87Eetz/PwWtS60FtIqydKicTAum0M2hHW8MeKSedy8lqn1D2SzQ7c8PtELloxlafDK54u3Lowlp0LvErbAiL4n1n6gLGPekg6+Oek9v3rYrL9qZCCLYN0jRz+Mrg1lcy4HOQ4NBUBU3KD+eSm073j4VP2T6lWjv03lanZtorWJcMGpq6lBw9V1YEj6xWlAzi619QYmGELLFNDeB2Zk4jkI0/CLOz6APuljFmhkS1ny+3HM7DvGJnAIXvOnK/kfbln6k5czAQzzcpY55JRErwBJe78Wk/xtd3ZEBA5KRe5w+f8CNphzI8eRHqPDbGfMKPUq1OH+P8gI/SUaI8PpDn9M+Ql5+LpjXIhll8dZ66p3YYPaH+mBPRqOliWbmTygtoaFWcKvxE+TPDxiFGcSzJTZnCyX74i6TEhDoKpE5vDSp63jLOfwSi7A84eWmcTQHqIGHzrM82vUu0BeWq3ZIUpxjYAXLOiDdZ7jjmprxK8xrZ6eK6csCICso/72cIw6+DNvRA06TFuCcmBiSeAQ3w+1jcHXTgrxK1l5EBw1H+C17R1mfpVCYYV6v9UBFQUL5nZmqZaGsL/QEaJVdeTSU3sCoGjCjEgXN8r694VaABgA9ikiFbO0zf8UOxdrKCCGJFhqvGU5HP2Pcsoji+ejKQ=
  • Spamdiagnosticmetadata: NSPM
  • Spamdiagnosticoutput: 1:99
DB structures are the same. Do you have a DB migration tool? Get the DDL in
destination. Turn off writing from source. Turn off constraints of
destination. Migrate data. Turn on constraints of destination. Change
configs. Turn on grouper for writing. Try in test env first

If you cant do that, then try with export/import?

Thanks
Chris


-----Original Message-----
From:


[mailto:]
On Behalf Of Black, Carey M.
Sent: Tuesday, May 22, 2018 12:48 PM
To:

Subject: [grouper-dev] migrating from MYSQL to Oracle

Hello,

I am likely going to be asked to move from MySQL to Oracle soon. ( And
expected to move quickly.)
Basically the MySQL admins are "concerned" about their ability to
provide a stable environment and are "kicking me out". :(

Are there any advice/strategy's for a "minimal down time" approach to such a
"conversion"?

How possible will it be to "take the audit data" with me to Oracle?
( Are the DB structures in Oracle/MySQL/Other different? )

Thanks in advance.

--
Carey Matthew



Archive powered by MHonArc 2.6.19.

Top of Page