Migration Oracle - Caché

Question

Question

Andre Larsen Barbosa · Nov 5, 2020

Hello everyone,
First sorry for the ignorance, but, as I am new in the InterSystem world, I came to the following doubt:
Thinking about a database migration. Is it possible, in a non-traumatic way, to take an Oracle database and migrate it completely to Caché?

Discussion (4)1

Log in or sign up to continue

Robert Cemper · Nov 5, 2020

In general YES.
I did it myself with preIRIS Caché.
Data and Tables and Views and Triggers are not demanding.
Migrating Stored Procedures could take a little bit more effort.
But the ability to transform Stored Procedures to Class Methods should allow also to solve tricky situations.

(I'm personally proud that over more than a decade I never lost a benchmark against Oracle))

10 1

score 2 · Answer 1 · 2020-11-05T12:06:26-05:00

Lucas Weiler Garcia · Nov 5, 2020

Hi,

I'm new too but I think so it's possible.

2 0

score 0 · Answer 2 · 2020-11-11T13:21:43-05:00

Mariana Scopel · Nov 11, 2020

It's fantastic. I have this problem with Microsoft SQL.

0 0

score 2 · Answer 3 · 2020-11-11T13:28:00-05:00

Robert Cemper · Nov 11, 2020

With MS SQL it's even easier as you can directly run ClassMethods/Procedures written in TSQL

2 0