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

 

70
1 11 4 180
Log in or sign up to continue

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

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