Migrating NSW Spatial Services Government Data to Open Source
NSW Spatial Services (DFSI), Department of Customer Service · Government
EnterprisemigrationExperience Digital migrated 600 tables and millions of records from three legacy IBM Db2 and Informix databases into open source PostgreSQL for NSW Spatial Services (DFSI), part of the state's Open Data Initiative. Using a Python and SQLAlchemy toolkit spanning schema reflection, convert-and-clone, and database convergence phases, the team achieved perfect 1-1 schema mapping and generated thousands of triggers for fully automatic temporal version control. The project, completed on time and within budget, delivers repeatable, licensing-free tooling that underpins geospatial systems used by emergency services.