Migrate to PostgreSQL with OpenSCG

Thinking about migrating to PostgreSQL?

Need to estimate how easy it will be and how long it will take?


If you are like many folks that are considering migrating to Postgres, you’ve wondered what the effort would be.  Not many of us have done migrations before so trying to estimate the effort without having that background is daunting.  This is where a migration assessment from OpenSCG can help.

We are migration experts who having been performing migrations to Postgres for over 20 years.  We’ve tackled database migrations from numerous sources including: Oracle, MySQL, SQL Server, Sybase, MongoDB and IBM DB2.  Over the years, we have developed an unique set of skills, tools, and processes that help customers identify what needs to be migrated, the effort required and the impact to the business so customers can make the right decision using the right data.

What’s in an OpenSCG Migration Assessment?

  • 2-Day to 2-Week engagement based on number of systems to be analyzed

  • Review business functionality, availability, and security requirements. Identify available extensions to meet functionality requirements.

  • Analyze number and complexity of tables, stored procedures, triggers

  • Analyze application code and database objects for syntax and functionality differences between source database and Postgres.

  • Identify testing strategies to validate data, code, and application correctness

  • Evaluate deployment options to meet business needs – on-premises vs. AWS cloud, high availability configuration, etc

  • Evaluate data conversion and synchronization process – considering size and complexity of data, available resources, parallel operation, and downtime tradeoffs

  • Identify skills and training needed for maintenance, monitoring, and operations after go-live


What do you get?

At the end of the engagement, you will receive a detailed report with findings, recommended approach, and estimated effort and cost to perform the migration. We will go through the details and answer any questions on a review call to ensure you have all the information you require to decide on the next step.

Why OpenSCG?

Our teams have migrated 100’s of databases to Postgres — more than anyone else in the world! Our migration assessment focuses on the complete system, not just one piece of the puzzle. Where most other vendors focus on only one part of the puzzle, i.e the database OR the application and only development, OpenSCG migration experts look at your entire stack and the entire migration lifecycle:

  • Database and application migration

  • Testing!

  • Performance considerations

  • Operations and high availability requirements

  • Training and on-going maintenance