--- title: Accelerate PostgreSQL Migrations with Gemini in DMS description: Migrating stored procedures from commercial databases like Oracle or SQL Server to PostgreSQL is often the hardest part of database modernization — requiring... canonical: https://daily.dev/posts/accelerate-postgresql-migrations-with-gemini-in-dms-v7jiyexlu twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: Accelerate PostgreSQL Migrations with Gemini in DMS | daily.dev og:description: Migrating stored procedures from commercial databases like Oracle or SQL Server to PostgreSQL is often the hardest part of database modernization — requiring... og:url: https://daily.dev/posts/accelerate-postgresql-migrations-with-gemini-in-dms-v7jiyexlu og:image: https://api.daily.dev/og/posts/V7JiYEXlU.png og:image:alt: Accelerate PostgreSQL Migrations with Gemini in DMS og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # Accelerate PostgreSQL Migrations with Gemini in DMS **[Google Cloud](https://daily.dev/sources/gcp)** · 6 min read · 1 upvotes · 0 comments ## Summary Migrating stored procedures from commercial databases like Oracle or SQL Server to PostgreSQL is often the hardest part of database modernization — requiring specialized expertise and months of manual rewriting. Google Cloud's Database Migration Service (DMS) now integrates Gemini AI to automate this conversion. It analyzes full schema context (not just snippets), converts PL/SQL and T-SQL constructs like NVL, DECODE, and exception blocks into native PL/pgSQL equivalents, and provides side-by-side diffs with inline explanations. The workflow includes automated syntax validation, dependency checking, and staged deployment to Cloud SQL or AlloyDB before production cutover. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Questions this post answers ### How does Gemini in Google Cloud Database Migration Service convert Oracle PL/SQL stored procedures to PostgreSQL PL/pgSQL? Gemini in Database Migration Service analyzes the full schema context of a source database, including table relationships, data types, and cross-procedure references, then generates PL/pgSQL code alongside the original for side-by-side review. For example, it automatically maps Oracle's NVL function to PostgreSQL's COALESCE and rewrites DECODE statements as CASE expressions, providing inline explanations for each conversion decision. _Teams migrating Oracle or SQL Server logic to PostgreSQL can follow conversion approaches like this one shared on daily.dev._ ### What makes AI-assisted database migration tools different from using a generic AI chatbot to convert SQL code? Purpose-built migration tools like Database Migration Service analyze the entire database context, including dependent views, foreign key constraints, and cross-procedure references, rather than evaluating isolated code snippets like a generic chat tool would. They also pair deterministic compiler rules for standard conversions with AI synthesis only for complex procedural logic, run code within existing cloud security boundaries, and validate syntax with status indicators before deployment. _Anyone weighing AI coding assistants against dedicated migration tooling can compare approaches shared on daily.dev._ ## Similar posts on daily.dev - [Automating Postgres translations with Database Migration Service](https://daily.dev/posts/automating-postgres-translations-with-database-migration-service-dpri0snjk) · Google Cloud · 0 upvotes · 0 comments - [AWS DMS Schema Conversion adds SAP \(Sybase\) ASE to PostgreSQL support with generative AI](https://daily.dev/posts/aws-dms-schema-conversion-adds-sap-sybase-ase-to-postgresql-support-with-generative-ai-6kkcht1lf) · AWS · 1 upvotes · 0 comments - [How to get Gemini to deeply understand your database](https://daily.dev/posts/how-to-get-gemini-to-deeply-understand-your-database-mxlda52o3) · Google Cloud · 1 upvotes · 0 comments --- Tags: [#database](https://daily.dev/tags/database), [#postgresql](https://daily.dev/tags/postgresql), [#gcp](https://daily.dev/tags/gcp), [#google-gemini](https://daily.dev/tags/google-gemini) [View this post on daily.dev](https://daily.dev/posts/accelerate-postgresql-migrations-with-gemini-in-dms-v7jiyexlu) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"Accelerate PostgreSQL Migrations with Gemini in DMS","url":"https://daily.dev/posts/accelerate-postgresql-migrations-with-gemini-in-dms-v7jiyexlu","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/accelerate-postgresql-migrations-with-gemini-in-dms-v7jiyexlu"},"datePublished":"2026-08-11T16:12:35.190Z","dateModified":"2026-09-14T07:30:28.254Z","description":"Migrating stored procedures from commercial databases like Oracle or SQL Server to PostgreSQL is often the hardest part of database modernization — requiring...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/8c2d27142d5d692612e4684bba33579f?_a=AQAEuop","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/8c2d27142d5d692612e4684bba33579f?_a=AQAEuop","isAccessibleForFree":true,"articleSection":"Google Cloud","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"Google Cloud","logo":"https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/gcp","url":"https://daily.dev/sources/gcp"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/accelerate-postgresql-migrations-with-gemini-in-dms-v7jiyexlu","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":1},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"database,postgresql,gcp,google-gemini","timeRequired":"PT6M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Google Cloud","item":"https://daily.dev/sources/gcp"},{"@type":"ListItem","position":3,"name":"Accelerate PostgreSQL Migrations with Gemini in DMS"}]} {"@context":"https://schema.org","@type":"FAQPage","@id":"https://daily.dev/posts/accelerate-postgresql-migrations-with-gemini-in-dms-v7jiyexlu#faq","mainEntity":[{"@type":"Question","name":"How does Gemini in Google Cloud Database Migration Service convert Oracle PL/SQL stored procedures to PostgreSQL PL/pgSQL?","acceptedAnswer":{"@type":"Answer","text":"Gemini in Database Migration Service analyzes the full schema context of a source database, including table relationships, data types, and cross-procedure references, then generates PL/pgSQL code alongside the original for side-by-side review. For example, it automatically maps Oracle's NVL function to PostgreSQL's COALESCE and rewrites DECODE statements as CASE expressions, providing inline explanations for each conversion decision. Teams migrating Oracle or SQL Server logic to PostgreSQL can follow conversion approaches like this one shared on daily.dev."}},{"@type":"Question","name":"What makes AI-assisted database migration tools different from using a generic AI chatbot to convert SQL code?","acceptedAnswer":{"@type":"Answer","text":"Purpose-built migration tools like Database Migration Service analyze the entire database context, including dependent views, foreign key constraints, and cross-procedure references, rather than evaluating isolated code snippets like a generic chat tool would. They also pair deterministic compiler rules for standard conversions with AI synthesis only for complex procedural logic, run code within existing cloud security boundaries, and validate syntax with status indicators before deployment. Anyone weighing AI coding assistants against dedicated migration tooling can compare approaches shared on daily.dev."}}]} ```