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: "Black, Carey M." <>
  • To: "Hyzer, Chris" <>, "" <>
  • Subject: [grouper-dev] RE: migrating from MYSQL to Oracle
  • Date: Fri, 25 May 2018 19:12:01 +0000
  • Accept-language: en-US
  • Authentication-results: spf=pass (sender IP is 128.146.163.16) smtp.mailfrom=osu.edu; internet2.edu; dkim=pass (signature was verified) header.d=osu.edu;internet2.edu; dmarc=pass action=none header.from=osu.edu;
  • Authentication-results-original: spf=none (sender IP is ) ;
  • Ironport-phdr: 9a23:KMAf2h+/iS4pz/9uRHKM819IXTAuvvDOBiVQ1KB20ukcTK2v8tzYMVDF4r011RmVBd6ds6oMotGVmpioYXYH75eFvSJKW713fDhBt/8rmRc9CtWOE0zxIa2iRSU7GMNfSA0tpCnjYgBaF8nkelLdvGC54yIMFRXjLwp1Ifn+FpLPg8it2O2+55Pebx9UiDahfLh/MAi4oQLNu8cMnIBsMLwxyhzHontJf+RZ22ZlLk+Nkhj/+8m94odt/zxftPw9+cFAV776f7kjQrxDEDsmKWE169b1uhTFUACC+2ETUmQSkhpPHgjF8BT3VYr/vyfmquZw3jSRMMvrRr42RDui9b9mRh/2hikaKz43/mLZisJyg6JavB2vqBNwzpXIYIGMKPZyYr/Rcc8ESWdHQ81fVzZBAoS5b4YXAeYMIOJYoJPhqFsNtRe1GBehC/n1yjBWhn79wKo03/4vHQrb2wEvBNYOv27Io9X2LqseTP65wafTwDXEdPNWxC3x55bVfRA8uPyBW697f8nJyUQ3Cg/JklqdpZbqMj6XzOgAvWqW4/BkWO+vk2IqqQ58riKyysojloXFnIwYxk7e+Sh93oo5PdO4R1B4bNK4FZZdsj+VOJdyT8w8RmxlvDg1xqAJtJO+fyUF04ooyhDaZvGDaIeF5g/sWeCMKjlinn1lYqiwhxOq/Eig1OL8Us603U5SoCdZldfAqm4B2wXN58eFV/dx50Ch1i2R2AzJ7eFEPFw0mrHcK548xL4/i4AfsVzZHi/xhEX5krOZdlkl+uiv7eTreLLmpoKAN49wjQH+NacultajDuQ/NwgCR2mb+eKi273/5UD1XalGg/IsnqTWsp3WP8oWq6yjDwJR0osv8xO/AC2n0NQck3kHNlVFeBefgofyP1HBOuz3DfSlj1ixjjtmyevLPrr6ApXQNHTMjqrufatl505G1AUz1cxf545TCrwZL/LzQEjxtMHADhAnKQy42vvoB8tj1o4FXWKPA7SZML/JsVOW/O4vIu+MZJMLtzbnLfgq+eLugWEjlVADYKapwMhfVHftVNR3MUiDJTLHgs0ACi1C6g81TP34hUeqUCVYIWuqUqQ6oDw3FdTiRc3MXIewmLGbmSu2ALVXYHxLEFaBDS2ueomZEb9YZziVP9dsiHkIWKaJSok92AuouROgjbdrM7yH1DcfsMep/tx87O6X3To77zFlR+HbmSnZRWV9lWBOHmVt9KdkvApwxkrVgvswuOBRCdEGv6ABaQw9L5OJl+E=
  • Spamdiagnosticmetadata: NSPM
  • Spamdiagnosticoutput: 1:99
Chris,

RE: " DB structures are the same. "
That is good to hear. :)
I was thinking about just doing a "clean install" (from the
installer) in Oracle and working out a mapping. But if the structure is the
same, then that should be a "one to one" ( maybe with: case issues ? data
type issues? )

I think I have tried to use the GSH export features (past the conversion to
Groovy) and found the export and/or import broken in some way. But I have not
run it to ground enough to try to report it. ( AKA: Maybe a PEBKAC issue.) So
I hope it does not come down to that feature.

--
Carey Matthew



-----Original Message-----
From: Hyzer, Chris
<>

Sent: Tuesday, May 22, 2018 1:52 PM
To: Black, Carey M.
<>;


Subject: RE: migrating from MYSQL to Oracle

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