• tomcoffing

Oracle to Postgres: Migrate, Federate, and Search

Are you considering migrating from Oracle to Postgres? Smart move! Converting the table structures and data types from Oracle to Postgres takes seconds. Building the load scripts for each table takes seconds.

Large Oracle systems can take time because many companies want to gradually migrate the data to Postgres. Another smart move!

So, customers also need to join data from Oracle and Postgres in a single query, which refers to a federated query.

The ability to search both systems simultaneously for specific column names is icing on the cake, especially when you can use the search to move or join data.

The video below shows you everything you need to migrate from Oracle to Postgres. By the way, you can also migrate 19 other systems to Postgres in the same way.

Today's users need a query tool that works brilliantly on all systems.

Today's users need to be able to join data across two systems seamlessly.

Today's users need to move data from one system to another in a point-and-click fashion with no technical knowledge required.

Today's users need to write the SQL or have the SQL built automatically. Today's users need search capabilities to look where a column resides in all their systems. Today's users need to take answer sets and join them with other answer sets, share them with peers, graph, chart them, pivot, and slice and dice them a hundred different analytics.

Today's users need to have dark mode when looking at their screen all day and be able to adjust the colors they see in the background completely.

All database vendors provide tools to access their systems, but none of them have any of the above features, so they are diminishing the power and purpose of their databases. In addition, the database vendors have never learned that the database and end-user access go hand in hand.

After writing 85 books on all database platforms and teaching over 1,000 classes worldwide for 20 years, I knew that software would one day overtake the importance of any single database.

I spent the last 20 years building the Nexus corporate software, which migrates one or thousands of tables across all database systems.

Last week I did a ten-table join across ten different systems using the Nexus Super Join Builder, and Nexus wrote the SQL automatically. I also searched on the column customer_number and found where it resides in 20 different systems, and I did it all in dark mode while joining and performing analytics on all answer sets I received that day.

Let the database vendors fight it out, but in the end, it is inevitable that everyone will access data across dozens, if not hundreds, of database platforms.

Here is the video of ten tables joining across ten database systems in a single query. Warning: This video contains what many experts thought was impossible.

Tom Coffing has also led a team of developers for almost 20 years to create the Nexus, which queries, migrates, and joins data across all systems. Amazingly, Nexus migrates between all the databases below with the click of the mouse.


• Excel

• Microsoft Access

• Snowflake

• Redshift

• Synapse

• BigQuery

• Teradata

• Oracle

• SQL Server

• DB2

• Hadoop

• MapR

• Greenplum

• Postgres

• Vertica

• Netezza


• Yellowbrick

• SQLite

It is never too early to dream about the future of data.

44 views0 comments