Migration Tale of Databases – 6 Reasons to Move from Oracle to Microsoft SQL
According to my knowledge, there are two main types of DBAs. One who prefers Microsoft SQL and one who prefers Oracle. Each database system has been thoroughly tested and improved over years. They share many similarities, but they also have very few differences. This makes it easy for software and system architects to choose between the two.
This article does not discuss the differences between them, but provides a high-level overview of the migration strategy behind moving the database workloads to MS SQL from Oracle.
Why should I migrate my databases from Oracle into MS SQL?
Do you find this question in your head? Let me tell you six reasons.
#1. Oracle Systems has very limited cloud exposure
Every organization today needs cloud technology. It is not always possible to migrate 100%, but it is possible to use cloud as part of hybrid implementations or disaster recovery sites. Microsoft SQL gives us the option of implementing the database both on-premises and on-cloud. Even if the database was installed on-premises it can be integrated very tightly with Microsoft Azure. Oracle, on the other hand, doesn’t currently have these cloud capabilities. To be honest, I don’t see Oracle having any future in cloud computing.
Costing MS SQL is not difficult. There are many good factors. Because the setup and maintenance operations of MS SQL are not as complex as Oracle database systems, even a database developer with intermediate knowledge can assume the role of database administrator. It will not be necessary to spend more on DBAs, which would reduce IT budget. It also features such as Always On with MS SQL make it highly available and support business continuity plan at no additional cost, unlike Oracle which comes with features like Active Data Guards’ and Real Application Clusters’.
#3. The ‘In Memory’ capabilities of MS SQL.
Microsoft’s latest offering in database world: the ‘In-Memory OLTP is a true game changer. This feature is also known by the name Hekaton. This ability allows applications to perform at their best. This technique stores and manages data with incredible efficiency. This technique is ideal for workloads that require high data ingestion rates, session state management, read performance scaling, and heavy data processing.
A good news for Linux lovers. Microsoft has just announced that the SQL Server version compatible with Linux will be released sometime in mid-2017. As it is still a few months away, we don’t have much information. This will be a great opportunity for hybrid environments that use different OS platforms.
#5. #5. Microsoft’s migration offer
Microsoft is serious about marketing its SQL server products. Microsoft is offering customers who are willing to migrate their databases from Oracle into Microsoft SQL with software assurance, free licenses until June 30th 2016. They would not only help with migration but also provide free training on SQL products. That’s just too aggressive!
Many people around the world follow Gartner reports. This report is the most useful for Cloud Solutions Architects and other Technical Consultings to show that their preferred platform or product is efficient. It is quite impressive to see MS SQL leading the way in database technology, and ahead of Oracle. Take a look at the report here
SSMA may be able to help you if you are ready to migrate. SSMA stands to be SQL Server Migration Assistant. Microsoft has created a very fancy tool that can be used to quickly and easily migrate SQL Server.