|
|
Data Migration Support
Portico Consulting has recently been working
with two London PCTs to support their
migration of data for child-health (including immunisations
and vaccinations), district nursing and therapy services.
This work built on our previous experience of many complex
data migrations, and we have now established both a detailed
understanding of the field, inter-field and inter-record
integrity tests which data must ‘pass’, and mechanisms for
transforming and cleansing the data to meet the LSP's requirements.
We are able to offer assistance in supporting
your data migration work. We recognise that the range
and availability of relevant skills varies from Trust to
Trust, and so we can work with you to provide the level and
type of support which would be most helpful.
For example, we could help by facilitating a
workshop where we could assist in the planning process,
drawing on our recent experience and providing advice on
what works well, and what doesn’t work so well.
Alternatively, we could, if you needed, provide some skilled
hands-on help in manipulating and preparing data; or
establish a SQL Server 2005-based technical environment at
your Trust, and possibly provide some focussed training in
aspects of the tools which are particularly relevant. Or we
could provide all technical aspects of the work, cleansing
and transforming the data into the required format in our
own technical environment.
|
