Oracle-to-Postgres Migrations

Postgres Professional (Postgres Pro) is specializing in database development, 24x7 support, and expert consulting services for PostgreSQL, the world's most advanced open-source database. The company develops PostgreSQL and Postgres Pro (own PostgreSQL based DBMS), assists with data migrations, conducts PostgreSQL trainings, and helps developers and DBAs get certified for pursuing PostgreSQL careers. The team's most well-known upstream PostgreSQL contributions are support for multiple languages, JSON, full-text search, and new indexing techniques, including spatial and semistructured data indexing. Founded in 2015 by PostgreSQL major contributors Oleg Bartunov and Teodor Sigaev, Postgres Pro currently employs 100+ staff members including a number of PostgreSQL major contributors, committers and contributors.

Stacy from Postgres Pro

Our free virtual event is for DBAs who need to ensure a seamless migration from Oracle to PostgreSQL and seek best practices from experts.

WEBINAR ACCESS LINK:<a href="https://youtu.be/w3ke0K21bYw" target="_blank" data-msys-clicktrack="0" rel="nofollow noopener noreferrer"> </a><a href="https://youtu.be/w3ke0K21bYw?t=2281" target="_blank" data-msys-clicktrack="0" rel="nofollow noopener noreferrer">https://youtu.be/w3ke0K21bYw?t=2281</a><a href="https://youtu.be/w3ke0K21bYw" target="_blank" data-msys-clicktrack="0" rel="nofollow noopener noreferrer"></a>To ensure smooth data migration from Oracle databases to PostgreSQL, you might need some tips and tricks from experts who have done it many times. At this event, we share our expertise in Oracle-to-Postgres migrations for large businesses with multi-terabyte databases.Application systems migrations techniques from Oracle to PostgreSQL Due to a significant increase in Oracle license prices, many enterprise businesses migrate or consider migrating to open source databases. Why is PostgreSQL seen as a database of choice for enterprise customers? From the technical viewpoint, enterprises choose PostgreSQL as it provides the following features: 1) Extensive PL/pgSQL for functions and stored procedures creation. 2) Various modules for monitoring the entire RDBMS state. 3) Various tools for creating backups and restoring data from them. 4) Additions to SQL dialect for creating complex queries. 5) Built-in replication. 6) Exclusion constraints, partitioning. 7) Pl/Python for communication with various external services and many more. However, there may be some challenges related to data and code migration. In this presentation, we&#x27;ll go through migration stages and the required steps for their completion. Then data migration tools will be covered, with their pros and cons explained. Then we&#x27;ll look into code migration tools and possible problems and discuss how to solve them. Also, we&#x27;ll list and explain several approaches to system downtime minimization. In short, we&#x27;ll tackle all migration steps so you could understand what you need to do to make your system work on a different RDBMS.Speaker bio (Peter Petrov)Peter Petrov works for Postgres Professional as a Database Engineer since 2017.He has been working with Oracle RDBMS and PostgreSQL for 8 years and is now involved in consulting customers on correct business logic design and development using PL/pgSQL programming language, migrating data from Oracle to PostgreSQL, and optimizing database queries.Peter also participates in investigating various situations that occurred during PostgreSQL maintenance.Prior to Postgres Professional Peter worked in various software companies which implemented business logic by using PL/SQL and Java programming languages.

Oracle-to-Postgres Migrations

More events from Stacy from Postgres Pro

Discover more events from Stacy from Postgres Pro, from Science & Tech to other experiences you might love.

Still looking for the right event?

Explore all online events to browse and filter by date, category, and more.

Oracle-to-Postgres Migrations

More events from Stacy from Postgres Pro

Discover more events from Stacy from Postgres Pro, from Science & Tech to other experiences you might love.

You might also like...

Browse more events with different dates, prices, and formats to find your next great experience.

Still looking for the right event?

Explore all online events to browse and filter by date, category, and more.