Mapping Oracle to PostgreSQL data types

A common first question during a database migration is "How do Oracle datatypes compare to PostgreSQL?" The simple answer is that they are very compatible, and map easily. The table below shows an Oracle to PostgreSQL data type comparison and mapping for the most common Oracle types. These basic data types just scratch the surface [...]

By | August 10th, 2017|Categories: Dave PostgreSQL|Tags: , , , |0 Comments

Proliferation of NUMERIC

More and more I'm seeing people use a NUMERIC for their primary keys. This is a direct result of people leveraging automated tools for their Oracle to PostgreSQL migration. Oracle's NUMBER data type is frequently used as the primary key for a table so the tools just map to a PostgreSQL NUMERIC and calls it [...]

By | March 20th, 2017|Categories: Jim PostgreSQL|Tags: , , , |4 Comments

Why Migrate?

“Why migrate to Postgres?” is a question that we used to hear a lot in the past. There used to be a number of different reasons to migrate including, take advantage of new technology, a change of staff skills, vendor consolidation caused friction and of course, cost. Nowadays, the main reason we hear for migrating [...]

By | March 8th, 2017|Categories: Migration, OpenSCG, OpenSource, PostgreSQL, Uncategorized|Tags: , , , |0 Comments

Don’t move your Oracle database to the cloud

Why move your Oracle database to the cloud? It just doesn't make sense. You are moving to the cloud for flexibility, for cost savings, for ease of changing your infrastructure. Does doubling your Oracle license fee for AWS or Azure usage sound like Oracle wants to let you have flexibility or cost savings?? (Hint: NO!!) [...]

By | February 7th, 2017|Categories: OpenSource|Tags: , , , , |0 Comments