{"id":12128,"date":"2024-07-10T16:28:14","date_gmt":"2024-07-10T14:28:14","guid":{"rendered":"https:\/\/hopla.tech\/?post_type=caso-de-exito&p=12128"},"modified":"2024-08-05T11:44:15","modified_gmt":"2024-08-05T09:44:15","slug":"migracion-de-oracle-a-postgresql","status":"publish","type":"caso-de-exito","link":"https:\/\/hopla.tech\/en\/caso-de-exito\/migracion-de-oracle-a-postgresql\/","title":{"rendered":"Migrating from Oracle to PostgreSQL"},"content":{"rendered":"

In the healthcare sector, one of Italy's largest hospitals needed a migration project from Oracle to PostgreSQL to reduce total cost of ownership (TCO). Hopla! supported them during the migration phase of the database structures. For the data migration phase, we designed a tailored solution to successfully migrate several terabytes of information within a few hours, minimizing downtime for the hospital management system and thereby reducing risk to patients.<\/p>","protected":false},"author":3,"featured_media":12125,"parent":0,"template":"","meta":{"_acf_changed":false},"categoria-exito":[291],"class_list":["post-12128","caso-de-exito","type-caso-de-exito","status-publish","has-post-thumbnail","hentry","categoria-exito-postgresql"],"acf":[],"yoast_head":"\nMigraci\u00f3n de Oracle a PostgreSQL | Hopla! Tech<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/hopla.tech\/en\/caso-de-exito\/migracion-de-oracle-a-postgresql\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Migraci\u00f3n de Oracle a PostgreSQL\" \/>\n<meta property=\"og:description\" content=\"En el sector de la sanidad, uno de los mayores hospitales de Italia requer\u00eda un proyecto de migraci\u00f3n de Oracle a PostgreSQL con el objetivo de reducir costes de TCO. Hopla! les apoy\u00f3 en la fase de migraci\u00f3n de las estructuras y para la fase de migraci\u00f3n de datos dise\u00f1amos una soluci\u00f3n adhoc para lograr […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hopla.tech\/en\/caso-de-exito\/migracion-de-oracle-a-postgresql\/\" \/>\n<meta property=\"og:site_name\" content=\"Hopla! Tech\" \/>\n<meta property=\"article:modified_time\" content=\"2024-08-05T09:44:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hopla.tech\/wp-content\/uploads\/2024\/07\/cover-postgreSQL2.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"423\" \/>\n\t<meta property=\"og:image:height\" content=\"273\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@HoplaSoftware\" \/>\n<meta name=\"twitter:label1\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/hopla.tech\\\/caso-de-exito\\\/migracion-de-oracle-a-postgresql\\\/\",\"url\":\"https:\\\/\\\/hopla.tech\\\/caso-de-exito\\\/migracion-de-oracle-a-postgresql\\\/\",\"name\":\"Migraci\u00f3n de Oracle a PostgreSQL | Hopla! Tech\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/hopla.tech\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/hopla.tech\\\/caso-de-exito\\\/migracion-de-oracle-a-postgresql\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/hopla.tech\\\/caso-de-exito\\\/migracion-de-oracle-a-postgresql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/hopla.tech\\\/wp-content\\\/uploads\\\/2024\\\/07\\\/cover-postgreSQL2.webp\",\"datePublished\":\"2024-07-10T14:28:14+00:00\",\"dateModified\":\"2024-08-05T09:44:15+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/hopla.tech\\\/caso-de-exito\\\/migracion-de-oracle-a-postgresql\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/hopla.tech\\\/caso-de-exito\\\/migracion-de-oracle-a-postgresql\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/hopla.tech\\\/caso-de-exito\\\/migracion-de-oracle-a-postgresql\\\/#primaryimage\",\"url\":\"https:\\\/\\\/hopla.tech\\\/wp-content\\\/uploads\\\/2024\\\/07\\\/cover-postgreSQL2.webp\",\"contentUrl\":\"https:\\\/\\\/hopla.tech\\\/wp-content\\\/uploads\\\/2024\\\/07\\\/cover-postgreSQL2.webp\",\"width\":423,\"height\":273},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/hopla.tech\\\/caso-de-exito\\\/migracion-de-oracle-a-postgresql\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/hopla.tech\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Casos de exito\",\"item\":\"https:\\\/\\\/hopla.tech\\\/casos-de-exito\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Migraci\u00f3n de Oracle a PostgreSQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/hopla.tech\\\/#website\",\"url\":\"https:\\\/\\\/hopla.tech\\\/\",\"name\":\"Hopla! Tech\",\"description\":\"The enterprise software and consultancy company\",\"publisher\":{\"@id\":\"https:\\\/\\\/hopla.tech\\\/#organization\"},\"alternateName\":\"Hopla!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/hopla.tech\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/hopla.tech\\\/#organization\",\"name\":\"Hopla! Tech\",\"alternateName\":\"Hopla!\",\"url\":\"https:\\\/\\\/hopla.tech\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/hopla.tech\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/hopla.tech\\\/wp-content\\\/uploads\\\/2025\\\/12\\\/Hopla-by-BTW-b-3.webp\",\"contentUrl\":\"https:\\\/\\\/hopla.tech\\\/wp-content\\\/uploads\\\/2025\\\/12\\\/Hopla-by-BTW-b-3.webp\",\"width\":274,\"height\":115,\"caption\":\"Hopla! Tech\"},\"image\":{\"@id\":\"https:\\\/\\\/hopla.tech\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/x.com\\\/HoplaSoftware\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/hopla-software\\\/\",\"https:\\\/\\\/www.youtube.com\\\/@hoplasoftware7485\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Migraci\u00f3n de Oracle a PostgreSQL | Hopla! Tech","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/hopla.tech\/en\/caso-de-exito\/migracion-de-oracle-a-postgresql\/","og_locale":"en_GB","og_type":"article","og_title":"Migraci\u00f3n de Oracle a PostgreSQL","og_description":"En el sector de la sanidad, uno de los mayores hospitales de Italia requer\u00eda un proyecto de migraci\u00f3n de Oracle a PostgreSQL con el objetivo de reducir costes de TCO. Hopla! les apoy\u00f3 en la fase de migraci\u00f3n de las estructuras y para la fase de migraci\u00f3n de datos dise\u00f1amos una soluci\u00f3n adhoc para lograr […]","og_url":"https:\/\/hopla.tech\/en\/caso-de-exito\/migracion-de-oracle-a-postgresql\/","og_site_name":"Hopla! Tech","article_modified_time":"2024-08-05T09:44:15+00:00","og_image":[{"width":423,"height":273,"url":"https:\/\/hopla.tech\/wp-content\/uploads\/2024\/07\/cover-postgreSQL2.webp","type":"image\/webp"}],"twitter_card":"summary_large_image","twitter_site":"@HoplaSoftware","twitter_misc":{"Estimated reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/hopla.tech\/caso-de-exito\/migracion-de-oracle-a-postgresql\/","url":"https:\/\/hopla.tech\/caso-de-exito\/migracion-de-oracle-a-postgresql\/","name":"Migraci\u00f3n de Oracle a PostgreSQL | Hopla! Tech","isPartOf":{"@id":"https:\/\/hopla.tech\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hopla.tech\/caso-de-exito\/migracion-de-oracle-a-postgresql\/#primaryimage"},"image":{"@id":"https:\/\/hopla.tech\/caso-de-exito\/migracion-de-oracle-a-postgresql\/#primaryimage"},"thumbnailUrl":"https:\/\/hopla.tech\/wp-content\/uploads\/2024\/07\/cover-postgreSQL2.webp","datePublished":"2024-07-10T14:28:14+00:00","dateModified":"2024-08-05T09:44:15+00:00","breadcrumb":{"@id":"https:\/\/hopla.tech\/caso-de-exito\/migracion-de-oracle-a-postgresql\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hopla.tech\/caso-de-exito\/migracion-de-oracle-a-postgresql\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/hopla.tech\/caso-de-exito\/migracion-de-oracle-a-postgresql\/#primaryimage","url":"https:\/\/hopla.tech\/wp-content\/uploads\/2024\/07\/cover-postgreSQL2.webp","contentUrl":"https:\/\/hopla.tech\/wp-content\/uploads\/2024\/07\/cover-postgreSQL2.webp","width":423,"height":273},{"@type":"BreadcrumbList","@id":"https:\/\/hopla.tech\/caso-de-exito\/migracion-de-oracle-a-postgresql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/hopla.tech\/"},{"@type":"ListItem","position":2,"name":"Casos de exito","item":"https:\/\/hopla.tech\/casos-de-exito\/"},{"@type":"ListItem","position":3,"name":"Migraci\u00f3n de Oracle a PostgreSQL"}]},{"@type":"WebSite","@id":"https:\/\/hopla.tech\/#website","url":"https:\/\/hopla.tech\/","name":"Hopla! Tech","description":"The enterprise software and consultancy company","publisher":{"@id":"https:\/\/hopla.tech\/#organization"},"alternateName":"Hopla!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/hopla.tech\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/hopla.tech\/#organization","name":"Hopla! Tech","alternateName":"Hopla!","url":"https:\/\/hopla.tech\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/hopla.tech\/#\/schema\/logo\/image\/","url":"https:\/\/hopla.tech\/wp-content\/uploads\/2025\/12\/Hopla-by-BTW-b-3.webp","contentUrl":"https:\/\/hopla.tech\/wp-content\/uploads\/2025\/12\/Hopla-by-BTW-b-3.webp","width":274,"height":115,"caption":"Hopla! Tech"},"image":{"@id":"https:\/\/hopla.tech\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/HoplaSoftware","https:\/\/www.linkedin.com\/company\/hopla-software\/","https:\/\/www.youtube.com\/@hoplasoftware7485"]}]}},"_links":{"self":[{"href":"https:\/\/hopla.tech\/en\/wp-json\/wp\/v2\/caso-de-exito\/12128","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hopla.tech\/en\/wp-json\/wp\/v2\/caso-de-exito"}],"about":[{"href":"https:\/\/hopla.tech\/en\/wp-json\/wp\/v2\/types\/caso-de-exito"}],"author":[{"embeddable":true,"href":"https:\/\/hopla.tech\/en\/wp-json\/wp\/v2\/users\/3"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hopla.tech\/en\/wp-json\/wp\/v2\/media\/12125"}],"wp:attachment":[{"href":"https:\/\/hopla.tech\/en\/wp-json\/wp\/v2\/media?parent=12128"}],"wp:term":[{"taxonomy":"categoria-exito","embeddable":true,"href":"https:\/\/hopla.tech\/en\/wp-json\/wp\/v2\/categoria-exito?post=12128"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}