Using Migration Portal in HM Innovation Release

Migration Portal manages the schema migration project created for every database registered with Hybrid Manager (HM), Oracle or Postgres. For Oracle sources, it also assesses, analyzes, and converts schemas to be compatible with EDB Postgres Advanced Server.

Migration Portal is available as an EDB-hosted service or as an application in HM.

Use Migration Portal in HM to create, delete, and share projects, control access modes, and manage permissions. For the schema migration workflow itself, see Migrating Oracle schemas or Migrating Postgres schemas.

Comparing Migration Portal in HM with the EDB-hosted version

Some features in the HM deployment of Migration Portal are unique or function differently from the EDB-hosted version.

AI Copilot

AI Copilot is an AI-driven chatbot tool that assists you with issues that can occur during the schema assessment and conversion in Migration Portal. It uses third-party AI services and is trained on both EDB's product documentation and support knowledge base to deliver use-case-specific solutions.

The AI Copilot isn't enabled by default in HM.

• To use the AI Copilot for Migration Portal queries, ask the HM administrator to enable and configure it with the AI/LLM of your organization.

• See AI Copilot for more information.

Project collaboration

Migration Portal supports collaborative DDL editing, enabling multiple users in the same HM project to work on the same schema file simultaneously. If another user modifies a DDL you're also editing, your changes will trigger a conflict resolution view. This view displays the other user's update in an Update view and your own edit in a Target view. You can then select Use Updated to adopt the other user's fix or Reassess to apply and save your own changes, overwriting the previous update. This approach ensures efficient, concurrent schema compatibility adjustments.

Portal access

Accessing the Migration Portal interface differs based on the version you're using.

• Access the EDB-hosted Migration Portal through the EDB portal.

• Access the Migration Portal built into HM from the HM console.

• Use project-scoped access to migrate schemas loaded by the EDB Postgres AI agent.

• Use the user's workspace access to migrate externally provided schemas.

User permissions and role-based access

• The EDB-hosted Migration Portal provides each EDB account with a dedicated workspace, meaning you can't share projects with other users.

• Migration Portal built into HM offers project-scoped, collaborative access. Users with access to a specific HM project gain access to its associated Migration Portal project.

• In HM, Migration Portal user permissions are managed directly through HM. For instance, a user with Viewer permissions can't migrate schemas or reassess DDL.