Google has enhanced its Database Migration Service with AI-assisted code conversion for PostgreSQL migrations from commercial databases. This feature addresses the challenge of converting stored procedures, triggers, and custom functions written in proprietary languages. The new workflow allows users to view original source code alongside suggested PostgreSQL PL/pgSQL output, enabling inline explanations, code editing, and validation before deployment.
The service analyzes schema context across the migration project, considering table relationships and data types. It combines rule-based conversion with AI-generated suggestions and includes PostgreSQL syntax validation. The conversion process remains within the customer's Google Cloud project, adhering to security protocols.
This feature aims to reduce the time for code conversion from months to days, allowing database specialists to focus on verification and application modifications. Once validated, the converted code can be applied to staging systems for testing before live migration.