Migrating To Windows

How WellData transferred Devon Council’s IT systems to a newer, more reliable infrastructure

The Issue

Devon County Council has relied on WellData for the management of their database estate for over 8 years. At the very beginning of the project talks were held about the opportunity to change their servers and migrate their Oracle Databases running on AIX servers to up-to-date Windows Servers as well as the daily Business-as-Usual database management that the current estate required.

Often migrations appear to be very complex projects. This is not surprising, considering that a migration frequently involves changing the operating system, storage and database version all at the same time, whilst keeping the downtime to a minimum.

This is why migrations tend to be postponed indefinitely.

Devon County Council’s database estate was getting to the stage where risk was starting to get too high: in June 2021 the operating systems were nearing end of support, the servers were at a point where the cost of maintenance was becoming too expensive, and the Oracle version needed upgrading.

When the request for a migration to newer and better performing servers and databases came through from the Devon County Council’s IT department, the WellData team was ready.

The Solution

Being well acquainted with the Council’s database estate, the team knew that there were currently five databases hosted on only two servers. This situation had developed over time and was not ideal as it complicates the daily management of the databases and prevents database replication should that be necessary.

For this reason, the very first recommendation was to build five servers, one for each database. These five servers had to be identical, built to the same specification, so that if a server failed it would be possible to replicate a database on to another server; this also allowed for an easier and more effective database management regime.

The Results

The migration process was completed in less than five months with no disruption to Devon County Council’s operations: the servers were built, Oracle 19c installed, daily maintenance plans established, each database was cut over, testing carried out and the migration completed.

In the words of Graham May, Application Analyst, of Devon County Council(DCC):

“[…] WellData managed the process from cradle to grave ensuring that we stayed within ourOracle licensing agreements.

WellData were on hand to perform the migration of the Production Environment outside of our core corporate support hours”

 

<< Back to case studies

Here's what other people think

Google Rating
5.0
High standard, professional service. I've worked with Welldata for a number of years and always found their DBA's to be knowledgeable and proactive. Throw any question at them and it will be resolved, it gives real peace of mind knowing you have a partner you can rely on from emergencies to general questions. They also like a challenge and we do throw a few curved balls at them.read more
Paul Miller
Paul Miller
12:34 27 Aug 21
The support I receive from Well Data is extremely responsive. Richard Parsons is my contact and keeps me informed daily on the health of our SQL Databases. Whenever I ask for assistance from Well Data it is quick and professional.read more
Kay Riley
Kay Riley
13:41 19 Aug 21
Really know their stuff and their response times are very good. They provide us with a vital service.
Andy Cole
Andy Cole
13:36 19 Aug 21
The guys at WellData really know their stuff. We wanted a quick route to doing something complex and they sorted it for us very quickly and to a high standard. Very professional, no ego, just excellent and to the point consultancy.read more
Steve Goacher
Steve Goacher
11:31 14 Nov 19
I have worked with the WellData team for many years now and they have always delivered.I would highly recommend them to any business looking for best-value outsourced Expert DBA’s.Being able to offer a rolling contract on the basis that if they don’t deliver you can leave shows their confidence and commitment.Their professionalism and knowledge is second to none.read more
Petro Bartoszyk
Petro Bartoszyk
08:51 18 Oct 19
A very dedicated team of extremely professional and knowledgeable experts
Giulia Iannucci
Giulia Iannucci
14:08 16 Nov 18
We use Welldata for SQL support and are very happy with their service.
David Sadler
David Sadler
09:40 15 Nov 18
Really know their stuff and their response times are very good.
Andy Cole
Andy Cole
11:45 06 Nov 18
Our partnership with WellData has enabled us to resolve critical database problems. Their attitude and service makes them a natural extension to our own technology team, which extends our capability in a critical area of our business.read more
Steve Fenton
Steve Fenton
10:56 05 Nov 18
Having worked with the team at Welldata for approaching 17 years, my company and I have always found them professional, reliable and generally a great firm to work with.read more
John Lynes
John Lynes
14:00 04 Oct 17
WellData provide an excellent level of support and their team are very knowledgeable and always go the extra mile. I would wholeheartedly recommend them.read more
Stefan Parrott
Stefan Parrott
13:12 19 Sep 17