Question
Andre Larsen Barbosa · Nov 5, 2020

Migration Oracle - Caché

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é?

 

50
5 4 111 1

Replies

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)) 

Hi,

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

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

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