We have extensive experience of database migration including Oracle to Postgres, MySQL to MariaDB, Mysql/MariaDB to Postgres Postgres/MariaDB to Oracle, SQL Server to Postgres/MariaDB.
We are accustomed to typical migration challenges including data cleansing, datatype differences, character set/collation differences, SQL/application changes etc.
Our experience includes on premise to cloud migration
Business requirements analysis
Our business consultants focus on your business objectives – not just the technology. This important first step ensures that subsequent decisions are based on a solid understanding of the commercial benefits of the proposed migration
Having agreed to outcomes, we develop a project plan in conjunction with your staff to ensure that both parties have a good understanding of roles, tasks, timescales and responsibilities. We include contingency planning and risk assessment and mitigation in the process
If you are replacing an undocumented legacy system we can assist with developing a functional specification as the starting point for the replacement system
Database licensing, training and support
We offer suitable database platforms and discuss licensing models in conjunction with the server strategy with focus on functionality, performance and cost
Our database experts have considerable experience of data cleansing. We use Talend Data Quality or our own toolset for special cases
Using appropriate technologies (we use Talend Data Integration), a specialist application or our own toolset for special cases we transfer your data onto the new platform
Full system documentation
We fully document your new system ready for handover to your in house team
We develop a transition plan in conjunction with your staff to transition from the legacy to the new system with minimal disruption to users
Handover and training
We transfer operation responsibilities to your staff, with an accompanying support plan from EIT if required