EDB Postgres Migration Assessment

Service Overview

The EDB Postgres Migration Assessment is designed to provide strategic clarity and eliminate the "unknowns" when modernizing legacy database estates. Before any data moves, this package delivers a structured, at-scale evaluation of your legacy databases to determine architectural compatibility, identify risk factors, and estimate the effort required to migrate to EDB Postgres. This engagement provides the data-driven foundation required to build your business case and sequence a predictable migration roadmap.

*Current Databases available for assessment include: Oracle, MySQL, MariaDB, DB2, Sybase, SQL Server

Scope of Service

An EDB consultant will perform an automated, bulk analysis of your database fleet, divided into two depths of analysis:

• High-Level Assessment: A broad analysis of the estate to determine: 
  • Overall complexity level
  • Potential high-risk items (such as XML or Java dependencies in Oracle, or specific unsupported features in non-Oracle platforms)
• Detailed Assessment: A targeted, deep-dive evaluation of specific databases, including:
  • application code assessment (based on SQL history exports or sample application code), 
  • Data migration estimations

  • Thorough review against EDB Postgres compatibility

Deliverables

At the conclusion of the engagement, EDB provides the following:

• Complexity Report: A comprehensive portfolio report categorizing the assessed databases by complexity and migration readiness.
• High-Level Findings Presentation: An executive readout of the estate's overall migration viability.

• Detailed LoE Presentations: Specific, end-to-end migration assessment reports tailored for the application teams managing the deep-dive databases.

   

Roles and Responsibilities

EDB Project Manager:  Responsible for initial planning, task alignment, and project closeout.

EDB Senior Consultant: Technical Lead, responsible for analysis, documentation, and presentation of results to end customer teams

Customer Team: Responsible for providing the main point of contact for requirements and prerequisites gathering. . Resources and Roles (or similar Technical Stakeholders) where input may be needed for the engagement include:

• Database Administrator
• System Architect
• Application Owner(s)

Assumptions

• A project kickoff will be conducted to review the service scope and confirm the schedule
• This service is delivered remotely unless otherwise agreed
• EDB will provide a secure fileshare for customer to share prerequisites for analysis.
• Customer will provide the names, title, email, phone number, and area of responsibility of those participating. One person will be designated as the main contact, and will be able to provide access to the people most knowledgeable about the topics to be discussed or examined. 
• Customer will make appropriate personnel available to assist EDB in the performance of the services as needed and requested by EDB in a timely manner so as not to disrupt the project schedule. 
• Customer will not provide Personal Data (as defined in applicable law). Customer agrees that it will work with EnterpriseDB to ensure that all such data is not provided.  
• Customer will ensure timely access to all systems through screen sharing and experts including third parties as required. 
• Customer will assign the appropriate resources with the appropriate privileges for the task being planned for any screen sharing sessions as needed throughout the engagement.
• Customer will provide timely feedback on all deliverables. Deliverables without commentary within 5 business days will be deemed as delivered.
• Current Databases available for assessment include: 
  • Oracle
  • MySQL
  • MariaDB
  • DB2
  • Sybase
  • SQL Server

Prerequisites

• Customer will provide resource availability for workshop planning and a point of contact for coordination. 
• Customer is responsible for gathering all data for analysis including:
  • DDL extracts 
  • Migration Questionnaires
  • SQL extracts or example application code
• Customer is responsible for providing all necessary internal design and project related documentation and requirements where EDB is required to analyze, operate, or modify customer implemented systems.

• Customer will coordinate availability of Application teams for detailed assessment presentation.

Data To be Collected 

Customer Should provide DDL extracts via the MigratioN Assessment Prerequisites, which can be shared by your account manager. 

EDB will provide a High Level Questionnaire to be filled per application

Customer will provide the following for SQL extracts to determine application complexity:

The customer will provide sample application code extracts to determine the application level complexity (such as embedded PL/SQL, dynamic SQLs, other database related calls).