oracle

/Tag:oracle

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