Asisa: How to migrate over 100 databases with no interruption of service
With more than 7.5M visits per year, almost 19,000 users and 2.3M medical records, Asisa found it very difficult to work in an agile, flexible and secure way with their more than 100 databases (with a size of 3TB) hosted in a physical Data Server.
The lack of agility, scalability and especially the potential security failures threatened the management and confidentiality of more than 2M clinical records. And this risk had to be urgently addressed in view of the increasing flow of data generating by the company’s international expansion process.
A window that required five months of planning and operational measures, including an intermediate migration to ensure a successful migration process that would not have an impact on the day-to-day operation of the group and its systems.
its SQL Servers 2007 have been optimized and they can now save over 50 % of their resources.
As a result, Asisa has placed itself in a favorable technological scenario for incorporating new technologies such as VR, AR, Machine Learning, Big Data or Blockchain. Furthermore, patient service has been optimized in all its phases since they now have access to structured information in real-time.
Finally, data homogenization has simplified the management and collaboration among employees, medical centres and hospitals.