OnDemand User Group
Support Forums => MP Server => Topic started by: jsquizz on September 23, 2021, 08:23:46 AM
-
We are looking at moving from our onprem RHEL boxes that run CMOD 10.5 in a db2 environment, to an Azure environment running oracle.
We don't want to do arsdoc/arsload, because we have so much data. So, I guess our approach will be-
Export the db2 tables to oracle.
Move the mounts to oracle
Make sure all the mounts are "lined up"
I once saw a post on here, that had some high level steps, but I cant seem to find it now. does anyone have advice on doing this? or any tips.
Thanks!
-
I think that post was by Alessandro. The only snag is, he was a prolific poster, so going through his history would take some time, and the instructions would be dated as he left the forums a few years ago. :)
-JD.
-
I think that post was by Alessandro. The only snag is, he was a prolific poster, so going through his history would take some time, and the instructions would be dated as he left the forums a few years ago. :)
-JD.
yeah, i sent him an email earlier in the year when this was a hot topic.
It has since came up again with urgency..and the client thinks its 100% straightforward.
My opinion? extract/reload.
-
It should be possible to migrate the database tables directly and keep everything else... I know that date format fields will be a problem since they're different between DB2 and Oracle.
-JD.
-
We are actually looking at using"Heterogenous Links" within oracle.
I'm not much into oracle, 95% of my implementations have been DB2. My colleague who's an oracle/db2 dba thinks this is our best approach currently.
Will report back! This could be interesting.
-
@jsquizz - Did you manage to find a solution for this? If so, please pots here the approach. Thanks.
-
@jsquizz - Did you manage to find a solution for this? If so, please pots here the approach. Thanks.
I have since left the project - however the plan was to use oracle's "heterogenous link" functionality. I am not an oracle guru at all - but my colleague who was - said it should work.
https://oracle-base.com/articles/misc/heterogeneous-services-generic-connectivity#:~:text=Oracle%20supports%20heterogeneous%20services%20to%20allow%20data%20in,uses%20ODBC%20or%20OLEDB%20to%20make%20the%20connections.
After the link is setup, migrate all the cache from onprem to azure.