From proprietary software to open source, without losing data.
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.
Migrated the corporate Oracle Spatial geodatabase containing multiple schemas, tables, and records to PostgreSQL + PostGIS.
Prepared the PostgreSQL environment: created the target database, enabled PostGIS, uuid-ossp, and oracle-fdw extensions, and configured spatial reference systems.
Created the target database schema and performed the initial configuration of the data structure.
Established connectivity to the Oracle database and migrated tables and data from the source schema to PostgreSQL.
Migrated and adapted stored procedures, functions, views, triggers, and sequences to PostgreSQL.
Implemented primary keys, indexes (including spatial indexes), and constraints to ensure data integrity and performance.
Adjusted the schema structure and geometry column types using dedicated migration scripts.
Configured user role
Updated and adapted the GeoServer configuration to work with PostgreSQL/PostGIS.
Migrated additional schemas and functional modules including their tables, procedures, views, and indexes.
Verified system functionality after migration, including web client integration, GeoServer services, and spatial layer availability.s and access privileges for the new PostgreSQL database.
