Blog

:PostgreSQL Tutorials

This article discusses tools for migrating schema online from Oracle to PostgreSQL and EDB Postgres Advanced Server. EDB Postgres Advanced Server and PostgreSQL Challenges of converting database schemas online Why migrate to PostgreSQL from Oracle? Why migrate to EDB Postgres Advanced Server from Oracle? Online tools to convert Oracle databases How to convert database schemas using Ora2Pg How to convert schemas using Migration Portal and EDB Postgres Advanced Server How to migrate from Oracle to PostgreSQL using ora_migrator

This article shows how to create a dblink connection from Oracle to EDB Postgres Advanced Server or PostgreSQL, Installation Connection Testing connectivity    There are several reasons where we might need to use both Orac ...

This article discusses the possible complications that can arise when migrating databases from Oracle to PostgreSQL. The steps for migration are covered and issues and their fixes are identified: Approach to migration Schema migration Code ...

<p>This article looks at the UNPIVOT function in Oracle and how to reproduce its result using PostgreSQL.</p>

<p>This article discusses binary large objects (Blobs) in Oracle and how to convert them into formats that PostgreSQL is able to use.</p>

<p>This article gives five examples of converting procedures from Oracle’s PL/SQL procedural language into PostgreSQL’s PL/pgSQL language.</p>

<p>This article provides three methods for importing data from an Oracle database into PostgreSQL.</p>

This article highlights differences in table partitioning between Oracle and PostgreSQL and provides key points to consider before migration partitioned data between them.

<p>This article discusses heterogeneous connections and how to set&nbsp; up a connection from Oracle to PostgreSQL using one.</p>

<p>This article provides information about the types and benefits of table partitioning and using the table partitioning syntax compatible with Oracle databases supported by EDB’s Advanced Server (EDB’s Postgres database).&nbsp;</p>

<p>This article demonstrates how to use the PostgreSQL client interface psqlODBC driver in Oracle to access PostgreSQL data.&nbsp;</p>

This article discusses the differences between how Oracle and PostgreSQL evaluate NULL characters and empty strings. Oracle reads empty strings as NULLs, while PostgreSQL treats them as empty. Concatenating NULL values with non-NULL characters results in that character in Oracle, but NULL in PostgreSQL.

This article discusses the advantages of the Oracle compatibility features in EDB Postgres Advanced Server and gives instructions for setting up compatibility during installation and for checking its availability in an existing cluster.

<p>This article explains how to use Foreign Data Wrappers to access data in remote PostgreSQL and Oracle databases.</p>

<p>This article introduces hierarchical queries and shows the differences in their usage between Oracle and PostgreSQL.</p>

<p>I have already covered switchover and failover. In the case of failover, the old primary is offline so there are no options for migrating clients from the old primary to the new primary. If there is a switchover, there are options for client migration. Assuming you are using streaming replication, only one server can accept writes</p>

<p>This is the final episode of this short series of blog posts on some of my drivers for moving to Postgres from Oracle. Please do read Part I and Part II of the series if you have not done so. It discussed the topics “History”, “More recently”, “The switch to Postgres”, “Realization”, “Pricing”, “Support” and “Extensibility”.</p>

<p>I have started with databases quite early on in my career. RMS by Datapoint… was it really a database? Well, at least sort of. It held data in a central storage, but it was a typical serial “database”. Interestingly enough, some of this stuff is maintained up to today. (Talk about longevity!)</p>

<p>Continuing this short series of blog posts on some of my drivers for moving to Postgres from Oracle. Please read Part I of the series if you have not done so. It discussed the topics “History”, “More recently” and “The switch to Postgres”.</p>