A customer of ours came to us needing their data moved to a new database. This can be quite a complicated process so we were more than happy to help. We have over 15 years of experience in the field, this is why we were the perfect choice for this job. We mapped the columns between the two databases to move all of their data from their non-standard database to the new Government standard database.
How We Did It
We started by organising a meeting with our customer to discuss what exactly they desired to achieve from our service. After a lot of discussions, we decided that the best course of action was to move their data from one database to another.
We used data integration to help to combine the data via extracting, transforming and loading it to the data warehouse. Businesses can use data that has been moved to provide insights and improve efficiency.
Once the mapping is completed a button can be pressed that will effectively move all the data content from a non-standard database to a Government standard database.
The new database is built using the Government standard that cannot be changed. The old database is built as an ‘open’ specification meaning that it can be changed. The main part of the job was mapping between the two databases to make sure that the schema and data in the new database was accurate. This means that when the user interface is created for the new database all the data will be in the correct places.
In short, we mapped the columns between the two different databases using Entity Framework Core. Entity Framework Core is a tool used to help map data and eliminates the need for a large amount of coding.
This process involved extracting data fields from one or more sources and matching them to the corresponding target fields in the destination database.
The Tools We Used
Azure Function as a REST API:
- REST (Representational State Transfer) API.
- They are the front end of a data source.
- Sits between the User Interface and the database.
- Provides access functions such as create, retrieve, update and delete for data items.
- SQL (Structured Query Language).
- Allows you to migrate your SQL workloads with SQL Server on Azure Virtual Machines.
- The SQL database supports modern cloud applications.
- Using your SQL skills in the cloud is the same as using the SQL Server engine.
Entity Framework Core:
- It can serve as an object-relational mapper.
- It eliminates the need for a large amount of coding to be completed.
- It supports a wide range of model development approaches.
C Sharp Programming Language:
- A type-safe programming language.
- It is a component-oriented and object-oriented programming language.
- It is a natural language in which to create and use software components.
Why You Should Do It
There are a lot of reasons why we move existing data from one database to another. For example, it can reduce costs if you migrate data from an on-premise database to a cloud database. It saves on infrastructure as well as the expertise and manpower that is required to maintain it.
Another reason to migrate data is to move it from an outdated system to a new one that has been created specifically to support modern needs. As technology changes new storage techniques are necessary. One example of this is a company choosing to move from a legacy SQL database to a data lake or a different flexible system. Upgrading to the latest version of a database also improves compliance and security.
One of the reasons to migrate data is to move it all into one place to make it more accessible. This can either be from merging data from several different databases to provide a unified data view or making all data available to all divisions in your company. For example, Marketing may have one database whilst IT has another meaning the systems cannot communicate. When you have incompatible databases it becomes very difficult to gain insights from your data.
Who We Are: Silver Limes
Migrating your data from one database to another can certainly appear to be a daunting task. But that’s where we come in. With over 15 years of experience in the field, we are more than happy to migrate your data for you.
Don’t allow yourself to stay stuck in the past when you can reap the benefits of moving your data to an updated database. Get in contact with us today.