Data migration

Data migration is one of the key activities of Asset Management Data Standard (AMDS) implementation.

The data migration process includes the following steps:

1. Create a copy of your asset management system database.
2. Waka Kotahi NZ Transport Agency has developed standard migration scripts. Undertake an initial data analysis and update these scripts to work for your organisation.
3. Run migration scripts, this will bring across asset data into your copy database.
4. Waka Kotahi will provide you with a triage report which assesses your data against AMDS.
5. Review and triage your data.
6. Record your triage decisions.
7. Run migration scripts to refresh your copy database.
8. Complete UAT.
9. Migrate data to your production asset management system - your asset management system will be updated to be AMDS compliant. This changes the structure of some table and enforces the AMDS business rules.

View larger image [JPG, 164 KB]

The creation of a copy database means that you can still add and update asset data in your production database. Once you have completed the data mapping and triage in the copy database this will be migrated to production.

The triage process allows you to decide whether data needs to be retained or updated. If a value does not conform to AMDS you can choose to retain it, but once AMDS in implemented this value becomes inactive so can no longer be selected.

Road Controlling Authorities (RCAs) are provided:

• Data migration scripts: Waka Kotahi will provide you will generic data migration scripts. These will be updated based on information from each AMDS implementation.
• Triage reports: identify fields in the RCA database that are not required by AMDS and if these fields are populated with data.
• Data quality assurance (DQA) reports: show data that does not conform with AMDS.

To be AMDS compliant your organisation needs to have undertaken a data migration and triage exercise to migrate your data to the AMDS complaint tables in your asset management system. Once complete Waka Kotahi will undertake a quality check and confirm that you are now AMDS compliant.

User defined tables (UDTs) can still be created within your asset management system for data that is not part of AMDS.

AMDS compliant tables within your asset management system can only be edited by the vendor. However, individual RCAs can change the obligation level from Optional to Mandatory to suit their needs. This is on a User Interface (UI) basis. The obligation level for Mandatory and Conditional Mandatory cannot be adjusted.