Why migrate your MySQL applications to SQL Server 2017?
There could be a time when your MySQL database solution evolves into a mission-critical solution. Suddenly, service level agreements for areas like security, high availability, disaster recovery, scalability, data governance, becomes an issue. Likewise, the solution may require integration with new capabilities like machine learning, data lake, graph, and in-memory computing.
Microsoft SQL Server 2017 powers your entire data estate by supporting structured and unstructured data sources. It builds on previous versions of SQL Server, which have been industry leading for four years in a row and have held a leading spot in TPC-E benchmark testing. SQL Server 2017 scales to accommodate petabytes of data through Polybase by using T-SQL over any data. SQL Server has also been the least vulnerable database over the last seven years.
When evaluating your rationale for migrating, consider the detail provided in the following sections.
According to the National Institute of Standards and Technology (NIST) public security board, SQL Server has the lowest number of reported security vulnerabilities across the major database vendors (NSIT, 2016).
Security features provide server-side security measures that vastly simplify the process of keeping data safe from unauthorized access without the need to modify existing client applications. These features include:
- Auditing, which enables teams to monitor access and track potentially suspicious activity.
- Transparent Data Encryption, which protects data at rest at a file level.
- Row-Level Security, which enables developers to implement fine-grained access control over rows in a database table.
- Dynamic Data Masking, which enables customers to designate how much of the sensitive data to reveal with minimal impact on the application layer.
- Always Encrypted, which secures data in motion and at rest.
SQL Server holds the top:
- TPC-E performance benchmarks for transaction processing.
- TPC-H performance benchmarks for data warehousing.
- Performance benchmarks with leading business applications.
In addition, in April 2017 Hewlett Packard Enterprise published a new TPC-H 1TB world record with SQL Server 2017 running on Linux.
These key SQL Server 2017 features that make this possible include:
- Columnstore, which provides column-based data storage and processing to achieve up to 10 times the query performance and data compression of row-based storage.
- In-memory OLTP, which brings transaction processing to memory-optimized tables at more than 2.5 times the speed of disk-based tables.
The power of SQL Server now on Linux and Container Instances
SQL Server 2017 offers the best performance and security features, and they are now available on all supported platforms, including Windows, Linux, and Azure Container Instances.
With these capabilities available on all editions of SQL Server, organizations can choose their deployment environment by operational need rather than desired features.
Adaptive Query Processing feature family
New in SQL Server 2017, Adaptive Query Processing introduces additional capabilities that allow the SQL Server query processor to modify plan choices based on runtime characteristics. During query processing and optimization, the cardinality estimation (CE) process is responsible for estimating the number of rows processed at each step in an execution plan. Inaccurate estimates can cause slow query response time, excessive resource utilization (CPU, Memory, IO), and reduced throughput and concurrency. To improve CE techniques, SQL Server 2017 introduces a new feature family: adaptive query processing (AQP). AQP improves handling of the more intractable CE issues.
Automatic plan correction
SQL Server 2017 also includes new features designed to detect plan choice regressions and provide recommendations on how to fix problems. These automatic plan correction features help to maintain the performance of data queries, even when application changes occur.
Customers want more than the ability to manage large volumes of data; they also need to analyze existing data more effectively to understand its relationships and patterns. Querying data from a relational schema by using traditional SQL queries can be a complex task. SQL Server 2017 introduces SQL Graph to make modeling and analyzing relationships easier by allowing users to handle relationships in a more flexible and agile way.
Resumable Online Index Rebuild
Planning, maintaining, and managing a large index online can be challenging. The bigger the index, the more difficult index maintenance becomes. Reorganizing and rebuilding indexes can be especially cumbersome. Resumable Online Index Rebuild in SQL Server 2017 enables continuation of an online index rebuild operation after a failure (such as a failover to a replica or insufficient disk space). Resumable Online Index Rebuild also enables pausing and later resuming an online index rebuild operation. For example, you might need to temporarily free up system resources to execute a high-priority task, or complete the index rebuild at another time if the available maintenance window is too short for a large table. Finally, Resumable Online Index Rebuild does not require significant log space, which allows you to perform log truncation while the resumable rebuild operation is running.
In-Memory OLTP enhancements in SQL Server 2017
First appearing as a feature in SQL Server 2014, in-memory technology for SQL Server dramatically improves the throughput and latency of SQL Server OLTP capabilities. This functionality is designed to meet the requirements of the most demanding transaction processing applications, and Microsoft has worked closely with several companies to prove these gains. SQL Server 2017 adds features to improve the performance and supportability of In-Memory OLTP workloads. In addition, we have removed many limitations on tables and stored procedures to make it easier to migrate applications and take advantage of the benefits of In-Memory OLTP.
A leader in MySQL to SQL Server migrations
The DB Best team developed a unique methodology for migrating MySQL applications to Microsoft SQL Server and proved it many times over with hundreds of customers. Being an architect and the original creator of SQL Server Migration Assistant (SSMA), the DB Best team is THE database migration expert you can trust with your project.
Based on our vast migration experience, the DB Best team developed our in-house products Database Compare Suite and DB Best Migration Platform, which greatly complement SSMA for MySQL.
Here are the DB Best tools that we’ve developed to optimize the MySQL to SQL Server migration process.
SQL Server Migration Assistant (SSMA)
See how you can get the most out of SSMA from the company who originally created the tool for Microsoft.
DB Best Database Compare Suite
Comparing two production databases for migration or an upgrade? Now you can do this with one powerful and simple tool that every DBA and database developer needs.
Our DBMSys platform collects data from multiple environments to develop a business case for modernization and chart an upgrade path while verifying servers conform to best practices. DBMSys provides a centralized dashboard to manage your database services on-premises and on the cloud.
DB Best MySQLMigrator
MySqlMigratorTM is an intuitive and effective tool for MySQL to SQL Server data migration. It helps to transfer data from MySQL tables to existing SQL Server tables in a few easy steps.
Sometimes you need a helping hand to get you started. Here are some of our offers to help with assessments, using SSMA, or developing a future-state roadmap.
Everybody is talking about the need for a digital transformation, but how do you get there? See how our future-state architecture design can use cutting edge technology to meet your organization’s needs.
Trust the team who built the SQL Server Migration Assistant to provide you with SSMA support in migrating your Oracle, SAP ASE, IBM DB2, MySQL, and Microsoft Access databases to SQL Server or Azure SQL Database.
Our training workshops allow you to understand how SQL Server really operates and take control over business-critical databases.
Learn how to take advantage of SQL Server 2017 and reduce costs by running on Linux, reducing performance troubleshooting time, and simplifying database security.
LEVERAGING YOUR EXISTING INVESTMENTS IN MIGRATION TECHNOLOGIES
Data integration tools play a big part in the successful migration of MySQL databases to SQL Server. Ideally, you want to minimize the changes to your data integration processes.
Our team can support open-source data integration tools such as:
We have extensive experience in the following commercial platforms.
Using Informatica solutions we can integrate your data from existing on-premises systems to the cloud, big data, and IoT systems smoothly and cost-effectively. Our solution architects will migrate the data accelerating time to value for your business goals.
We leverage a high-performance parallel framework on-premises or in the cloud with improved speed, flexibility and effectiveness to build powerful data integration infrastructure. Utilizing big data and Hadoop we help our customers more efficiently access new data sources.
Our developers can flawlessly replicate your data between different types of databases with handling any data changes. So your data never be missed. We also can simplify the ETL process and automate the manual procedures of data warehouse development to improve performance and cost.
We offer a fast and cost-effective way to connect, clean and share cloud and on-premises data using the architecture that easily scales to respond to growing business requests.
Put our Microsoft SQL Server Integration Services experience to use for seamless data extraction, transformation, and loading operations of any complexity.
We can help you get the most out of Oracle Golden Gate and facilitate real-time data integration, replication, transformations, and verification in heterogeneous IT environments. So you can have an extreme performance with Oracle Database integration and support for cloud environments.
Supporting your SQL Server solutions after the migration
As part of our migration project, we offer training, support, consulting, and managed services for your SQL Server solutions. If you don’t want to go through the hassle of maintaining the day-to-day operations of your databases and applications, be sure to check out our Operational Data Management service.
Are your DBA's stretched thin? Offload your IT needs to a dedicated team with industry-proven processes and world-leading tools and products
Check out the database consulting services we have used to help customers like you get the most out of their database platform.
Our DevOps services introduce cultural changes, best practices, and new technologies to improve collaboration between business, development, and operations to create an agile application development lifecycle.
We offer training in-person at your site, at a third party location, or remotely based on your needs. We can tailor our programs to your needs.
We have a great set of blog posts and data sheets to help you better understand our capabilities as the leader in database migration services and prove out possibilities and expertise in moving MySQL workloads to Microsoft SQL Server and Microsoft SQL Azure.
Reference data sheet
Modernizations to Microsoft's Data Platform
Cloud services such as Microsoft Azure, coupled with database technologies like SQL Server, enable organizations to quickly create and scale solutions that solve challenges and fuel new business opportunities. Through our tested migration methodology, we can provide a seamless transition…