Database Migration Service helps you convert Oracle schema to PostgreSQL. You accomplish this using conversion workspaces and Gemini-assisted conversion. Conversion workspaces provide tools to convert and validate schema and data. Gemini assistance uses the power of AI to reduce migration time and complexity.
Conversion workspaces
Use conversion workspaces to expedite and improve the migration process of heterogeneous databases. The workspaces handle schema and data conversion, simplifying the transition to a destination database. They also offer tools for validating the converted schema and data.
In the conversion editor, you can manipulate schema conversion in real time by converting supported objects automatically and resolving conversion issues.
Gemini-assisted conversion
Gemini-assisted conversion features in Database Migration Service help you apply the power of AI to reduce the time and complexity of your migrations.
Use the following complimentary approaches for a complete end-to-end Gemini-assisted code object conversion experience:
Conversion assistant
Conversion assistant is a set of dedicated prompts that can help you better understand the conversion logic, propose fixes for conversion issues, or optimize converted code. For example, if certain Oracle functions don't have direct equivalents in PostgreSQL, you can use the Help me fix object conversion issues prompt to get a proposal of code changes that can fix the conversion issue.
The following image shows how to access Gemini prompts for code and schema conversion explainability in conversion workspaces:
Conversion suggestions
When you fix conversion issues in your workspace, Gemini models can learn the pattern from your fixes and suggest changes to other faulty objects in the workspace. For example, after you've fixed object conversion issues manually or with the conversion assistant prompt, and when Gemini models have analyzed enough of your fixes, you can review AI-generated suggestions to further refine your code.
The following image shows the Gemini suggestions fix issues in conversion workspaces:
Supported scenarios
Database Migration Service supports Gemini-assisted conversion in the following heterogeneous scenarios:
- Convert Oracle code and schema to Cloud SQL for PostgreSQL with Gemini assistance
- Convert Oracle code and schema to AlloyDB for PostgreSQL with Gemini assistance