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