Part of the Avoca Data Migration Suite, the Transform tool will reduce the risk, cost and timescale of your data migration project. It has been proven in all of our NHS migration projects including the 13 projects now live. Transformer provides the user with total control over the migration without having to write any code. Simply map the source and target tables and allocate predefined rules and the tool will generate files for upload. The steps to create files are detailed here.

Using the Transformer instead of developing a bespoke solution will save your project time and money:

• Tailored versions for Cerner Millenium, i-soft Lorenzo and RiO are available that contain specific rules to deal with the most complex scenarios such as waiting lists and outpatients. If these scenarios are developed from scratch they will add months to the implementation plan.

• Improves quality with hundreds of template rules that have been tried and tested in complex data migrations. These cover 99% of the rules usually applied to any source data. If you have rules that fall in the last 1%, we can show you how or write it for you.

• Easy for information staff to understand

• Uses industry standards to migrate any type of source data which can be stored in SQL server

• You’re in control, if you don’t want to apply rules to all data items you can just migrate as is, and you can generate and change files as often as you wish