Migrate Oracle to PostgreSQL
Specially developed by Splendid Data, Cortex delivers the effortless migration of any Oracle database to native PostgreSQL without any vendor lock-in. Freedom here we come.
How to reduce the Oracle footprint?
Every company knows the impact of Oracle when it comes to costs, license constraints and cloud deployment.
A great dependence arises, and you want to get rid of that. But how?
In our latest white paper you will learn:
- How to effortlessly migrate any Oracle database to native PostgreSQL
- How it works
- The benefits of using Cortex
Features & Benefits
Cortex uses semantic translations
Cortex takes a highly advanced approach to migration. Rather than a syntactic line-by-line translation, Cortex performs a cutting-edge context semantic translation and takes care of all dependencies between Data Objects (DDL) and Code Objects (DML – PL/SQL). This delivers the sharpest, cleanest and most correct translation of Oracle (PL/SQL) into PostgreSQL (PL/pgSQL).
Cortex is repeatable and consistent
Cortex is a container-based solution. When any assessment and/or migration is run, a separate runtime container is created. Inside this will be all the necessary processes needed, standardising every single assessment or migration. Whether that’s for one database, or thousands, Cortex is repeatable and reliable.
Cortex leaves no Oracle footprint
When Cortex is finished, Oracle isn’t just gone – it’s entirely gone. The end result of a migration using Cortex is 100% native PostgreSQL without any constraints or the use of a proprietary compatibility layer. This makes it possible for you to run it on the community version of PostgreSQL.
Cortex feature spotlight
As a Command Line Interface, Cortex delivers higher precision, uses fewer resources and is more efficient overall.
Cortex can be run in different locations with different teams giving you the ability to easily scale up migrations.
Safe new home
All results and migrated DDL and DML arrive in a PostgreSQL DTAP-environment via GIT and Jira.
Context semantic translation
All dependencies are taken into account and everything is migrated to native PL/pgSQL without a proprietary compatibility layer.
Cortex takes into account both Oracle 10 and above, and PostgreSQL 10 and above and works seamlessly with them all.
On average, over 80% of the Code Objects, and in most cases all of the Data Objects are migrated automatically.
What makes Cortex unique?
Choose database freedom
It’s time to unplug from Oracle and enjoy total deployment freedom, agility and control. Cortex is our unique and powerful software product that makes it easy to migrate any size Oracle database to PostgreSQL. Leave all the license, maintenance and audit headaches of Oracle behind you. Go Cortex and start PostgreSQL.
Whatever the size, Cortex is ready
If your database has a just a few tables and a low amount of Lines of Code PL/SQL (Code Objects) – it can be migrated. Of course, if your Oracle database has over 10,000 tables and over 1,000,000 lines of code PL/SQL – it can be migrated too. Whatever the size of your database, Cortex has it covered.
Scalability made easy
Depending on your technology stack, Cortex gives you the freedom to employ a seamless factory-style approach to migration. You can run it at different locations, with different teams and create a high throughput of migrations – you’re in a control. Makes a nice change from Oracle.
On average, we’re able to migrate over 80% of the DML Code Objects. This is only possible because Cortex semantically translates each object within its context (including dependencies) to native PostgreSQL. It’s all thanks to our advanced software development and decades of Oracle and PostgreSQL expertise. And DDL Data Objects? 100% entirely automated.
Who’s it for?
Organisations with many Oracle databases
You can either buy a yearly Cortex license to assess and migrate an unlimited number of databases, or a yearly license for a limited number of databases. Whatever works best for you.
Global, regional or local System Integrators
You can license Cortex on a yearly basis for performing an unlimited amount of assessments and migrations for a specific end-user organisation. Or you can choose a yearly license for a limited number of databases. Again, it’s what works best for you.
We’ve helped companies like yours
“Splendid Data has been of great service to us to migrate our extensive and complex Oracle database part of our standard Coswin Asset Management solution, to native PostgreSQL using Cortex. Coswin is used at more than 1,700 customer sites and tens of thousands of users in different industries worldwide.”
Research and Development Manager, Siveco Group
“Splendid Data has done us a great service by migrating our Oracle database, part of our online hotel distribution solution, to PostgreSQL using Cortex including all data with zero downtime at cutover and a data synch back to Oracle assuring us a fallback for a defined period of time. From that moment on, we were relieved of Oracle’s high prices and licensing restrictions regarding deployment in a cloud environment like Microsoft Azure.”
CEO, Reconline AG
(Inter)national clients and partners
We work with clients all over the world, helping them to successfully migrate their Oracle database environments with Cortex to PostgreSQL.
Selection of clients and partners
FAQs about Cortex migrations
Can I deploy my PostgreSQL migrated database in the Cloud?
The simple answer is, yes, you can. There are no restrictions about how you deploy PostgreSQL, this is the core benefit of Open Source. There are many cloud providers who offer the community version of PostgreSQL.
Can every Oracle database be migrated to PostgreSQL?
Cortex can only be used on Oracle databases where your organisation owns the intellectual property. With this in mind, it’s safe to say that 98% of Oracle databases around the world can easily be migrated to PostgreSQL using Cortex.
What expertise do I need to perform a migration?
Cortex makes everything very simple, performing almost all the migration automatically. However, after the migration, there will always be things that need to be adjusted manually and you’ll need the necessary expertise to achieve this.
Is Cortex free?
Cortex is a licensed product that allows you to perform Oracle to PostgreSQL migrations yourself. The license price will be based on the number of Oracle databases you are going to migrate – but as a rough guide, based on that number the average price per database migration is less than €2,000 – regardless of complexity. Comparatively small when you consider Oracle license/maintenance costs and Oracle audits.
Is Cortex easy to use?
Yes, very easy. However, Cortex is specialist software, so you will need knowledge of both Oracle and PostgreSQL. In addition to this, you’ll be able to attend a one-day Splendid Data workshop that will give you the base knowledge you need to start using Cortex. As well as access to our specialized consultants, there is also a Cortex user manual and a cookbook for any manual adjustments you might need to make.
Ready to start migrating?
Please fill in the contact form and we’ll get back to you.