{"id":511,"date":"2026-06-04T09:16:06","date_gmt":"2026-06-04T09:16:06","guid":{"rendered":"https:\/\/sologeotech.com\/?page_id=511"},"modified":"2026-07-03T11:07:56","modified_gmt":"2026-07-03T11:07:56","slug":"migracion-de-oracle-spatial-a-postgresql-postgis","status":"publish","type":"page","link":"https:\/\/sologeotech.com\/en\/migracion-de-oracle-spatial-a-postgresql-postgis\/","title":{"rendered":"Oracle Spatial to PostgreSQL\/PostGIS Migration"},"content":{"rendered":"<h1>Oracle Spatial to PostgreSQL\/PostGIS Migration<\/h1>\n<ul>\n<li>\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/sologeotech.com\/en\/\"><br \/>\n\t\t\t\t\t\t\t\t\t\t\tHome<br \/>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n<\/ul>\n<h2>From proprietary software to open source, without losing data.<\/h2>\n<p>End-to-end migration of enterprise geospatial databases from Oracle Spatial to PostgreSQL\/PostGIS, establishing a more flexible, scalable, and open-source foundation for spatial data management.<\/p>\n<ul>\n<li>Migrated the corporate Oracle Spatial geodatabase containing multiple schemas, tables, and records to PostgreSQL + PostGIS.<\/li>\n<li>Prepared the PostgreSQL environment: created the target database, enabled PostGIS, uuid-ossp, and oracle-fdw extensions, and configured spatial reference systems.<\/li>\n<li>Created the target database schema and performed the initial configuration of the data structure.<\/li>\n<li>Established connectivity to the Oracle database and migrated tables and data from the source schema to PostgreSQL.<\/li>\n<li>Migrated and adapted stored procedures, functions, views, triggers, and sequences to PostgreSQL.<\/li>\n<li>Implemented primary keys, indexes (including spatial indexes), and constraints to ensure data integrity and performance.<\/li>\n<li>Adjusted the schema structure and geometry column types using dedicated migration scripts.<\/li>\n<li>Configured user role<\/li>\n<li>Updated and adapted the GeoServer configuration to work with PostgreSQL\/PostGIS.<\/li>\n<li>Migrated additional schemas and functional modules including their tables, procedures, views, and indexes.<\/li>\n<li style=\"text-align: left;\">Verified system functionality after migration, including web client integration, GeoServer services, and spatial layer availability.s and access privileges for the new PostgreSQL database.<\/li>\n<\/ul>\n<figure class='gallery-item'>\n\t\t\t\t<a data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-slideshow=\"8e70a00\" data-elementor-lightbox-title=\"1\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTEwMiwidXJsIjoiaHR0cHM6XC9cL3NvbG9nZW90ZWNoLmNvbVwvd3AtY29udGVudFwvdXBsb2Fkc1wvMjAyNlwvMDdcL2ltYWdlLTItMS5wbmciLCJzbGlkZXNob3ciOiI4ZTcwYTAwIn0%3D\" href='https:\/\/sologeotech.com\/wp-content\/uploads\/2026\/07\/image-2-1.png'><img fetchpriority=\"high\" width=\"800\" height=\"533\" src=\"https:\/\/sologeotech.com\/wp-content\/uploads\/2026\/07\/image-2-1.png\" alt=\"\" decoding=\"async\" srcset=\"https:\/\/sologeotech.com\/wp-content\/uploads\/2026\/07\/image-2-1.png 800w, https:\/\/sologeotech.com\/wp-content\/uploads\/2026\/07\/image-2-1-300x200.png 300w, https:\/\/sologeotech.com\/wp-content\/uploads\/2026\/07\/image-2-1-768x512.png 768w, https:\/\/sologeotech.com\/wp-content\/uploads\/2026\/07\/image-2-1-18x12.png 18w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/a><br \/>\n\t\t\t<\/figure>\n<figure class='gallery-item'>\n\t\t\t\t<a data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-slideshow=\"8e70a00\" data-elementor-lightbox-title=\"2\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTEwMSwidXJsIjoiaHR0cHM6XC9cL3NvbG9nZW90ZWNoLmNvbVwvd3AtY29udGVudFwvdXBsb2Fkc1wvMjAyNlwvMDdcL2ltYWdlLTEtMS5wbmciLCJzbGlkZXNob3ciOiI4ZTcwYTAwIn0%3D\" href='https:\/\/sologeotech.com\/wp-content\/uploads\/2026\/07\/image-1-1.png'><img width=\"800\" height=\"533\" src=\"https:\/\/sologeotech.com\/wp-content\/uploads\/2026\/07\/image-1-1.png\" alt=\"\" decoding=\"async\" srcset=\"https:\/\/sologeotech.com\/wp-content\/uploads\/2026\/07\/image-1-1.png 800w, https:\/\/sologeotech.com\/wp-content\/uploads\/2026\/07\/image-1-1-300x200.png 300w, https:\/\/sologeotech.com\/wp-content\/uploads\/2026\/07\/image-1-1-768x512.png 768w, https:\/\/sologeotech.com\/wp-content\/uploads\/2026\/07\/image-1-1-18x12.png 18w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/a><br \/>\n\t\t\t<\/figure>\n<figure class='gallery-item'>\n\t\t\t\t<a data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-slideshow=\"8e70a00\" data-elementor-lightbox-title=\"3\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTEwMCwidXJsIjoiaHR0cHM6XC9cL3NvbG9nZW90ZWNoLmNvbVwvd3AtY29udGVudFwvdXBsb2Fkc1wvMjAyNlwvMDdcL2ltYWdlLTYucG5nIiwic2xpZGVzaG93IjoiOGU3MGEwMCJ9\" href='https:\/\/sologeotech.com\/wp-content\/uploads\/2026\/07\/image-6.png'><img width=\"800\" height=\"533\" src=\"https:\/\/sologeotech.com\/wp-content\/uploads\/2026\/07\/image-6.png\" alt=\"\" decoding=\"async\" srcset=\"https:\/\/sologeotech.com\/wp-content\/uploads\/2026\/07\/image-6.png 800w, https:\/\/sologeotech.com\/wp-content\/uploads\/2026\/07\/image-6-300x200.png 300w, https:\/\/sologeotech.com\/wp-content\/uploads\/2026\/07\/image-6-768x512.png 768w, https:\/\/sologeotech.com\/wp-content\/uploads\/2026\/07\/image-6-18x12.png 18w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/a><br \/>\n\t\t\t<\/figure>\n\n\n<p class=\"wp-block-paragraph\"><\/p>","protected":false},"excerpt":{"rendered":"<p>Migraci\u00f3n de Oracle Spatial a PostgreSQL\/PostGIS Inicio De software propietario a c\u00f3digo abierto, sin perder datos. Migraci\u00f3n integral de bases de datos geoespaciales empresariales desde Oracle Spatial a PostgreSQL\/PostGIS, creando una base open source m\u00e1s flexible, escalable y preparada para la gesti\u00f3n avanzada de datos espaciales. La geobase corporativa Oracle Spatial con m\u00faltiples esquemas, tablas [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"elementor_header_footer","meta":{"footnotes":""},"class_list":["post-511","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Migraci\u00f3n de Oracle Spatial a PostgreSQL\/PostGIS - sologeotech.com<\/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:\/\/sologeotech.com\/en\/migracion-de-oracle-spatial-a-postgresql-postgis\/\" \/>\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 Spatial a PostgreSQL\/PostGIS - sologeotech.com\" \/>\n<meta property=\"og:description\" content=\"Migraci\u00f3n de Oracle Spatial a PostgreSQL\/PostGIS Inicio De software propietario a c\u00f3digo abierto, sin perder datos. Migraci\u00f3n integral de bases de datos geoespaciales empresariales desde Oracle Spatial a PostgreSQL\/PostGIS, creando una base open source m\u00e1s flexible, escalable y preparada para la gesti\u00f3n avanzada de datos espaciales. La geobase corporativa Oracle Spatial con m\u00faltiples esquemas, tablas [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sologeotech.com\/en\/migracion-de-oracle-spatial-a-postgresql-postgis\/\" \/>\n<meta property=\"og:site_name\" content=\"sologeotech.com\" \/>\n<meta property=\"article:modified_time\" content=\"2026-07-03T11:07:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sologeotech.com\/wp-content\/uploads\/2026\/07\/image-2-1.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sologeotech.com\\\/migracion-de-oracle-spatial-a-postgresql-postgis\\\/\",\"url\":\"https:\\\/\\\/sologeotech.com\\\/migracion-de-oracle-spatial-a-postgresql-postgis\\\/\",\"name\":\"Migraci\u00f3n de Oracle Spatial a PostgreSQL\\\/PostGIS - sologeotech.com\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sologeotech.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/sologeotech.com\\\/migracion-de-oracle-spatial-a-postgresql-postgis\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/sologeotech.com\\\/migracion-de-oracle-spatial-a-postgresql-postgis\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sologeotech.com\\\/wp-content\\\/uploads\\\/2026\\\/07\\\/image-2-1.png\",\"datePublished\":\"2026-06-04T09:16:06+00:00\",\"dateModified\":\"2026-07-03T11:07:56+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sologeotech.com\\\/migracion-de-oracle-spatial-a-postgresql-postgis\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sologeotech.com\\\/migracion-de-oracle-spatial-a-postgresql-postgis\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/sologeotech.com\\\/migracion-de-oracle-spatial-a-postgresql-postgis\\\/#primaryimage\",\"url\":\"https:\\\/\\\/sologeotech.com\\\/wp-content\\\/uploads\\\/2026\\\/07\\\/image-2-1.png\",\"contentUrl\":\"https:\\\/\\\/sologeotech.com\\\/wp-content\\\/uploads\\\/2026\\\/07\\\/image-2-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sologeotech.com\\\/migracion-de-oracle-spatial-a-postgresql-postgis\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/sologeotech.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Migraci\u00f3n de Oracle Spatial a PostgreSQL\\\/PostGIS\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/sologeotech.com\\\/#website\",\"url\":\"https:\\\/\\\/sologeotech.com\\\/\",\"name\":\"sologeotech.com\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/sologeotech.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Migraci\u00f3n de Oracle Spatial a PostgreSQL\/PostGIS - sologeotech.com","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:\/\/sologeotech.com\/en\/migracion-de-oracle-spatial-a-postgresql-postgis\/","og_locale":"en_GB","og_type":"article","og_title":"Migraci\u00f3n de Oracle Spatial a PostgreSQL\/PostGIS - sologeotech.com","og_description":"Migraci\u00f3n de Oracle Spatial a PostgreSQL\/PostGIS Inicio De software propietario a c\u00f3digo abierto, sin perder datos. Migraci\u00f3n integral de bases de datos geoespaciales empresariales desde Oracle Spatial a PostgreSQL\/PostGIS, creando una base open source m\u00e1s flexible, escalable y preparada para la gesti\u00f3n avanzada de datos espaciales. La geobase corporativa Oracle Spatial con m\u00faltiples esquemas, tablas [&hellip;]","og_url":"https:\/\/sologeotech.com\/en\/migracion-de-oracle-spatial-a-postgresql-postgis\/","og_site_name":"sologeotech.com","article_modified_time":"2026-07-03T11:07:56+00:00","og_image":[{"url":"https:\/\/sologeotech.com\/wp-content\/uploads\/2026\/07\/image-2-1.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimated reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/sologeotech.com\/migracion-de-oracle-spatial-a-postgresql-postgis\/","url":"https:\/\/sologeotech.com\/migracion-de-oracle-spatial-a-postgresql-postgis\/","name":"Migraci\u00f3n de Oracle Spatial a PostgreSQL\/PostGIS - sologeotech.com","isPartOf":{"@id":"https:\/\/sologeotech.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sologeotech.com\/migracion-de-oracle-spatial-a-postgresql-postgis\/#primaryimage"},"image":{"@id":"https:\/\/sologeotech.com\/migracion-de-oracle-spatial-a-postgresql-postgis\/#primaryimage"},"thumbnailUrl":"https:\/\/sologeotech.com\/wp-content\/uploads\/2026\/07\/image-2-1.png","datePublished":"2026-06-04T09:16:06+00:00","dateModified":"2026-07-03T11:07:56+00:00","breadcrumb":{"@id":"https:\/\/sologeotech.com\/migracion-de-oracle-spatial-a-postgresql-postgis\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sologeotech.com\/migracion-de-oracle-spatial-a-postgresql-postgis\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/sologeotech.com\/migracion-de-oracle-spatial-a-postgresql-postgis\/#primaryimage","url":"https:\/\/sologeotech.com\/wp-content\/uploads\/2026\/07\/image-2-1.png","contentUrl":"https:\/\/sologeotech.com\/wp-content\/uploads\/2026\/07\/image-2-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/sologeotech.com\/migracion-de-oracle-spatial-a-postgresql-postgis\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/sologeotech.com\/"},{"@type":"ListItem","position":2,"name":"Migraci\u00f3n de Oracle Spatial a PostgreSQL\/PostGIS"}]},{"@type":"WebSite","@id":"https:\/\/sologeotech.com\/#website","url":"https:\/\/sologeotech.com\/","name":"sologeotech.com","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/sologeotech.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"}]}},"_links":{"self":[{"href":"https:\/\/sologeotech.com\/en\/wp-json\/wp\/v2\/pages\/511","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sologeotech.com\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/sologeotech.com\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/sologeotech.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sologeotech.com\/en\/wp-json\/wp\/v2\/comments?post=511"}],"version-history":[{"count":71,"href":"https:\/\/sologeotech.com\/en\/wp-json\/wp\/v2\/pages\/511\/revisions"}],"predecessor-version":[{"id":1114,"href":"https:\/\/sologeotech.com\/en\/wp-json\/wp\/v2\/pages\/511\/revisions\/1114"}],"wp:attachment":[{"href":"https:\/\/sologeotech.com\/en\/wp-json\/wp\/v2\/media?parent=511"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}