You are here:Home1/Services2/PostgreSQL Migration Assessment
PostgreSQL Migration Assessment
Mitigate Risk. Evaluate Before You Migrate.
Evaluating your database prior to migration is critical to have an upfront, accurate idea of what will be required to ensure a smooth switch without loss of data, unplanned downtime, or unexpected expenses.
In addition to anticipating time requirements, a migration assessment can save your business money by allowing you to plan your time and resources in advance.
Good Reasons to get a Migration Assessment
Mitigate Migration Risk. Have a clear view of what the successful migration process for your database will entail at an early stage of the project; helping prevent a potential incomplete migration.
Identify Potential Blockers. Identify and plan for potential issues and/or dependencies that can be experienced during migration.
Estimate the Effort. Know the amount of work that is required before beginning the migration.
Estimate Costs. Financially plan for labor, any necessary hardware additions, and post migration training to avoid unexpected expenses.
Determine Appropriate Architecture. Ensure understanding of database mechanics, including how PostgreSQL handles data so the database can be designed accordingly.
Migrating from Oracle?
Contrary to popular belief, migrating from Oracle to PostgreSQL is only about as expensive as upgrading from one Oracle major version to the next. Reduce cost by converting to PostgreSQL, an open source solution that is free forever with unlimited usage. It is developed and maintained by a large global community focused on making it more and more powerful with every release.
Detailed Estimation of Effort Report. Details of the current system architecture and quantified estimation of the effort needed for migration including cost and time, and ROI.
Definition of best practices and guidelines. As an advantage of working with the world’s leading PostgreSQL experts your customized assessment includes suggestions based on first hand experience and knowledge.
Migration Plan. We work with you to provide a customized multi-phase migration plan based on our analysis of your database that includes a timeline and cost estimation. As leading contributors to the PostgreSQL project, 2ndQuadrant knows what is planned for the future of PostgreSQL and can customize your migration to accommodate these updates.
Identify Open Source Extensions. Either contrib or third party extensions that can help during the migration process.
Training Plan. We provide a customized training plan for all stages of the migration process (before, during, and after). This also allows our team to work better with the team that knows the application domain intimately.
Who better to assess your database for migration than people who regularly perform successful migrations on high-volume enterprise databases across all industry verticals around the globe?
This article provides the Oracle database administrator with equivalent PostgreSQL architecture knowledge. The process is a bit loose, but it is sufficient to bootstrap the concepts that are transferable and identify the ones that are not.
And now we arrive at the second article in our migration from Oracle to PostgreSQL series. This time we’ll be taking a look at the START WITH/CONNECT BY construct. In Oracle, START WITH/CONNECT BY is used to create a singly linked list structure starting at a given sentinel row. The linked list may take the form of a tree, and has no balancing […]
Partitioning is one of the coolest features in the latest PostgreSQL versions. PostgreSQL 10 introduced native partitioning and more recent versions have continued to improve upon this feature. This article provides a guide to move from inheritance based partitioning to declarative partitioning, using the native features found in PostgreSQL 11+.