migration Archives - 2ndQuadrant

Posts

Generating and Managing PostgreSQL Database Migrations(Upgrades) with Spring Boot JPA

July 20, 2020/0 Comments/in 2ndQuadrant, Haroon's PlanetPostgreSQL /by Muhammad Haroon

If you are building a Spring Boot application for your next project, you would also be preparing and planning for the PostgreSQL database to store the data generated by your customers. In some previous posts on the topic of RESTful services in Spring Boot, we discussed how we can use JPA to automatically create and […]

Migration to PostgreSQL [Webinar]

July 8, 2020/1 Comment/in Liaqat's PlanetPostgreSQL, Webinars /by Liaqat Andrabi

Among the many reasons to Migrate to PostgreSQL, dedicated support and seamless transition are key drivers for a business considering migration. Being open-source software, PostgreSQL provides a highly reliable, stable, scalable, and secure database migration, keeping in mind the unique needs of every business. Migration to PostgreSQL, however, can still be an extensive process as […]

Oracle to PostgreSQL: Basic Architecture

June 17, 2020/4 Comments/in 2ndQuadrant, Kirk’s PlanetPostgreSQL, PostgreSQL /by Kirk Roybal

This article provides the Oracle database administrator with equivalent PostgreSQL architecture knowledge. The process is a bit loose, but it is sufficient to bootstrap the concepts that are transferable and identify the ones that are not.

Oracle to PostgreSQL: START WITH/CONNECT BY

June 8, 2020/3 Comments/in 2ndQuadrant, Kirk’s PlanetPostgreSQL, PostgreSQL /by Kirk Roybal

And now we arrive at the second article in our migration from Oracle to PostgreSQL series. This time we’ll be taking a look at the START WITH/CONNECT BY construct. In Oracle, START WITH/CONNECT BY is used to create a singly linked list structure starting at a given sentinel row. The linked list may take the form of a tree, and has no balancing […]

How to migrate from inheritance-based partitioning to declarative partitioning in PostgreSQL

April 30, 2020/1 Comment/in Caterina's PlanetPostgreSQL /by Caterina Magini

Partitioning is one of the coolest features in the latest PostgreSQL versions. PostgreSQL 10 introduced native partitioning and more recent versions have continued to improve upon this feature. This article provides a guide to move from inheritance based partitioning to declarative partitioning, using the native features found in PostgreSQL 11+.

Oracle to PostgreSQL: ANSI outer join syntax in PostgreSQL

April 29, 2020/4 Comments/in 2ndQuadrant, Kirk’s PlanetPostgreSQL, PostgreSQL /by Kirk Roybal

We find ourselves at the third article in the Oracle migration series. This time, we look at those strange operators that modify the WHERE clause criteria in Oracle (+). Like everything else, PostgreSQL has a solution for that.

Webinar: Application Schema Migration [Follow Up]

February 6, 2020/0 Comments/in Webinars /by Liaqat Andrabi

With applications evolving over time, there’s a need to enhance and evolve database schema as well. Sometimes this process involves some database tables and columns, creating new constraints and indexes, or even changing data types. In order to discuss Schema Migration in detail, 2ndQuadrant hosted the “Application Schema Migration” webinar, providing an in-depth overview of […]

Oracle High Availability concepts in PostgreSQL

October 26, 2017/13 Comments/in 2ndQuadrant, Barman, PostgreSQL, Simon's PlanetPostgreSQL /by Simon Riggs

Sometimes people ask about certain Oracle High Availability features and whether they exist in PostgreSQL. In most cases, very similar features exist. The reason for the similarity is that PostgreSQL and Oracle have very similar architectures and so the mechanisms to protect data have also developed along the same lines. For example, Oracle Data Guard […]

2ndQuadrant is now part of EDB

Posts

Generating and Managing PostgreSQL Database Migrations(Upgrades) with Spring Boot JPA

Migration to PostgreSQL [Webinar]

Oracle to PostgreSQL: Basic Architecture

Oracle to PostgreSQL: START WITH/CONNECT BY

How to migrate from inheritance-based partitioning to declarative partitioning in PostgreSQL

Oracle to PostgreSQL: ANSI outer join syntax in PostgreSQL

Webinar: Application Schema Migration [Follow Up]

Oracle High Availability concepts in PostgreSQL

Support & Services

Products

Postgres Learning Center

About Us