Fortune 50 finserv companies, fortune 100 SaaS companies, and fortune 300 logistics companies have migrated workloads from Oracle to CockroachDB. There are dozens of reasons why this is happening but over the years we’ve seen a pattern that narrows the primary motivations down to the following:
What’s not mentioned in that list, and what bears mentioning, is the unique pressure on IT operations right now, in this challenging economic moment, to get more efficient without compromising on innovation. What are the tools and practices that will allow companies to reduce costs and accelerate innovation at the same time? Many companies are arriving at a similar conclusion: Switch to data management tools that offer more automation and flexibility.
Regardless of your reasons for the migration (and the lush green grass on the other side) every database migration conversation should begin with an acknowledgment of the challenge that migration represents.
No ‘migration guide’ is a magic carpet to carry your data and applications from a traditional database to a cloud-native database. That being said, the challenge of a migration is less daunting with a comprehensive guide to steer you.
If you’re using Oracle and you’re reading this blog, chances are you’ve experienced the limitations of legacy database technology and are planning to move a workload over to a cloud-native database that will operate more seamlessly in the public cloud.
At Cockroach Labs we have years of experience helping customers migrate workloads from Oracle over to CockroachDB. We’ve used that experience to polish this guide that’s intended to help you scope out and execute a migration from Oracle to CockroachDB. We hope that you find it to be a helpful tool. If you read the guide and find that you need additional support please don’t hesitate to contact us via https://support.cockroachlabs.com.
Tables, views, sequences, indexes, constraints
Users, privileges, groups and roles
Refactor the Schema to CockroachDB dialect with Schema Conversion Tool
Evaluate database-embedded code
The reduction of an Oracle database migration into four steps is a comic oversimplification. We know that the process is challenging. And we’re here to help. We have engineers that have worked with both companies and understand all the nuances involved in a migration.
If you’re ready to get started just download the Oracle to CockroachDB migration guide today. If you’re still in the process of measuring the value of a migration then join the webinar with ex-Oracle engineers to gain their perspective after living on both sides of the competition. They will discuss real-world examples of companies that moved Tier-0 workloads from Oracle to CockroachDB.
Recently, we’ve added more functionality to our migration tool suite and we produced this short video tutorial to demonstrate how to use MOLT (our migration tool suite):
Moving is challenging. I recently moved into a new house. Boxes are everywhere. Little pieces of styrofoam surprise me …Read more
What’s the best way to do a database migration?
It’s a challenging question. No single approach is going to be the best …Read more