This article will explain how to set up a connection from a Windows host OS using a PuTTY client to a remote MySQL server on Linux Ubuntu 18.04.
Read more »
MySQL
How to create and configure a linked server to connect to MySQL in SQL Server Management Studio
October 7, 2019This article will guide you with all the necessary steps to successfully create a linked server in SSMS to connect to the MySQL database.
Read more »
MySQL Query (T-SQL) Tutorial for SQL Server
September 25, 2019Microsoft SQL Server and MySQL, both are quite well-established database engines. In our role as a DBA, at some given time point we require T-SQL straddling between both database engines unites Select, Insert, Update, Delete and some other…
Read more »
How to migrate MySQL tables to Microsoft Azure SQL database
May 18, 2017Introduction
Today, it is a common practice to migrate our local data to Azure. Sometimes, we migrate files, sometimes databases and sometimes virtual machines. All the service in the cloud including Azure help a lot to simplify the administrative effort and reduce costs.
Read more »
How to migrate MySQL tables to SQL Server using the SQL Server Migration Assistant (SSMA) and SSIS
April 25, 2017Introduction
In this article, we will demonstrate how to migrate MySQL tables to SQL Server using the SQL Server Migration Assistant (SSMA) and SSIS. We will give a brief introduction to MySQL and create a table. If you do not have any experience in MySQL, this tutorial will teach you your first steps. After that, we will migrate the created table and existing tables. We will also mention common problems when we migrate tables.
Read more »