Home

Chief Surveyor General

It is our mission to provide Quality Services that ensure the Integrity of Surveyed Real Rights and to supply, maintain and provide access to Spatially Related Information for the People of our Country.

Structure Functions Data Projects Client Profile Contact Us
Search Papers Press Office Legal Info Links Fees


Projects | CIS Projects


Project Tiptoe

Project Tiptoe was the migration of data from 4 non-year-2000-compliant Informix databases to Oracle.

The data was exported from the Informix databases as text files (image data). These text files were used to create temporary tables in Oracle. These temporary tables were exact copies of the tables in the Informix databases. Several stored procedures were then written to clean up the data, e.g. translating old region codes (e.g. C0700) to new region codes (C0070000). After this was done, the data from the different tables had to be translated to fit into the new table structures in Oracle.

The number of records which were migrated can be summarized as follows:



Back to CIS Projects