{"id":140074,"date":"2023-06-28T09:19:10","date_gmt":"2023-06-28T09:19:10","guid":{"rendered":"https:\/\/www.stellarinfo.com\/blog\/?p=140074"},"modified":"2023-06-30T06:50:00","modified_gmt":"2023-06-30T06:50:00","slug":"migrating-from-mysql-to-sql-server-using-ssma","status":"publish","type":"post","link":"https:\/\/www.stellarinfo.com\/blog\/migrating-from-mysql-to-sql-server-using-ssma\/","title":{"rendered":"Migrating from MySQL to SQL Server using SSMA"},"content":{"rendered":"<?xml encoding=\"utf-8\" ?><?xml encoding=\"utf-8\" ?><p>Microsoft&rsquo;s SQL Server Migration Assistant (SSMA) for MySQL is a free tool that you can use for migrating data from MySQL database to SQL Server or SQL Azure. The latest release (v9.3) of the tool contains some important changes, including support for MySQL 8.x and SQL Server 2022.<\/p><h2 class=\"wp-block-heading\" id=\"the-ssma-for-mysql-is-a-program-developed-to-perform-the-following-tasks:\"><strong>The SSMA for MySQL is a program developed to perform the following tasks:<\/strong><\/h2><ul class=\"wp-block-list\">\n<li>Connect to a MySQL database (the source).<\/li>\n\n\n\n<li>Connect to an instance of SQL Server or Azure SQL database (the target).<\/li>\n\n\n\n<li>Convert all the objects from MySQL to SQL Server or Azure SQL database.<\/li>\n\n\n\n<li>Load these objects into SQL Server or Azure SQL database.<\/li>\n\n\n\n<li>Migrate data to SQL Server or Azure SQL database.<\/li>\n<\/ul><h2 class=\"wp-block-heading\" id=\"let&rsquo;s-see-how-to-use-this-tool-to-migrate-data-from-mysql-to-sql.\"><strong>Let&rsquo;s see how to use this tool to migrate data from MySQL to SQL.<\/strong><\/h2><p><strong>Step-by-Step Process to Migrate from MySQL to SQL using SSMA<\/strong><\/p><p>You need to first install the SSMA for MySQL. Here are a few prerequisites needed to install this tool:<\/p><ul class=\"wp-block-list\">\n<li>Windows 7 or newer version with, at least, 4 GB of RAM.<\/li>\n\n\n\n<li>Windows Server 2008 or newer version with, at least, 4 GB of RAM.<\/li>\n\n\n\n<li>Microsoft Windows Installer 3.1 or newer version.<\/li>\n\n\n\n<li>Microsoft .NET Framework version 4.7.2 or higher.<\/li>\n\n\n\n<li>MySQL ODBC 5.1 Driver.<\/li>\n\n\n\n<li>Credentials to access (login) the instance of SQL Server and have sufficient permissions.<\/li>\n<\/ul><p><strong>Now, look at the installation procedure. This is a wizard setup, which is quite simple.<\/strong><\/p><ul class=\"wp-block-list\">\n<li>Go to the official Microsoft <a href=\"https:\/\/aka.ms\/ssmaformysql\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">SQL Server Migration Assistant download page<\/a> and press the <strong>download<\/strong> button to download the installer.<\/li>\n<\/ul><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"709\" height=\"247\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image001-1.png\" alt=\"Migration Assistant for MySQL\" class=\"wp-image-140076 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image001-1.png 709w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image001-1-300x105.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image001-1-150x52.png 150w\" sizes=\"auto, (max-width: 709px) 100vw, 709px\" \/><\/figure><ul class=\"wp-block-list\">\n<li>Choose the version you need to install and press the <strong>Next<\/strong> button.<\/li>\n<\/ul><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"715\" height=\"299\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image002-1.png\" alt=\"Click Next by Choosing version\" class=\"wp-image-140077 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image002-1.png 715w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image002-1-300x125.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image002-1-150x63.png 150w\" sizes=\"auto, (max-width: 715px) 100vw, 715px\" \/><\/figure><ul class=\"wp-block-list\">\n<li>Double-click on the downloaded file.&nbsp;<\/li>\n<\/ul><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"632\" height=\"128\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image003-1.png\" alt=\"Click on Download File\" class=\"wp-image-140078 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image003-1.png 632w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image003-1-300x61.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image003-1-150x30.png 150w\" sizes=\"auto, (max-width: 632px) 100vw, 632px\" \/><\/figure><ul class=\"wp-block-list\">\n<li>Click the <strong>Next<\/strong> button in the welcome window.<\/li>\n<\/ul><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"495\" height=\"387\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image004-1.png\" alt=\"SSMA for MySQL\" class=\"wp-image-140079 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image004-1.png 495w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image004-1-300x235.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image004-1-150x117.png 150w\" sizes=\"auto, (max-width: 495px) 100vw, 495px\" \/><\/figure><ul class=\"wp-block-list\">\n<li>Accept the Licence Agreement and press <strong>Next<\/strong>.<\/li>\n<\/ul><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"497\" height=\"387\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image005-1.png\" alt=\"Licence Agreement\" class=\"wp-image-140080 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image005-1.png 497w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image005-1-300x234.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image005-1-150x117.png 150w\" sizes=\"auto, (max-width: 497px) 100vw, 497px\" \/><\/figure><ul class=\"wp-block-list\">\n<li>If any prerequisites are missing, a message will appear. In this case, exit from the installation program and install the missing prerequisites. Then, run the setup again.<\/li>\n\n\n\n<li>Otherwise, choose the <strong>Setup Type<\/strong>, select&nbsp;<strong>Typical<\/strong>, and press the <strong>Next<\/strong> button.<\/li>\n<\/ul><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"494\" height=\"387\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image006-1.png\" alt=\"Select set up type as Typical\" class=\"wp-image-140081 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image006-1.png 494w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image006-1-300x235.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image006-1-150x118.png 150w\" sizes=\"auto, (max-width: 494px) 100vw, 494px\" \/><\/figure><ul class=\"wp-block-list\">\n<li>Choose to enable (or not) both telemetry and automatic update checks. Click the <strong>Install<\/strong> button.<\/li>\n<\/ul><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"493\" height=\"385\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image007-1.png\" alt=\"Click on Install\" class=\"wp-image-140082 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image007-1.png 493w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image007-1-300x234.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image007-1-150x117.png 150w\" sizes=\"auto, (max-width: 493px) 100vw, 493px\" \/><\/figure><ul class=\"wp-block-list\">\n<li>It may take a few seconds for the installation to complete.<\/li>\n<\/ul><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"492\" height=\"387\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image008-1.png\" alt=\"Installation Running\" class=\"wp-image-140083 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image008-1.png 492w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image008-1-300x236.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image008-1-150x118.png 150w\" sizes=\"auto, (max-width: 492px) 100vw, 492px\" \/><\/figure><ul class=\"wp-block-list\">\n<li>When installed, click on the <strong>Finish<\/strong> button.<\/li>\n<\/ul><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"231\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image009-1.png\" alt=\"Tool Installed\" class=\"wp-image-140084 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image009-1.png 600w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image009-1-300x116.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image009-1-150x58.png 150w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/figure><p>Now, let&rsquo;s see how this tool works.<\/p><ul class=\"wp-block-list\">\n<li>Run the tool and create a <strong>new project<\/strong>.<\/li>\n<\/ul><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"749\" height=\"491\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image010-1.png\" alt=\"Adding new project to SQL\" class=\"wp-image-140085 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image010-1.png 749w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image010-1-300x197.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image010-1-150x98.png 150w\" sizes=\"auto, (max-width: 749px) 100vw, 749px\" \/><\/figure><ul class=\"wp-block-list\">\n<li>Specify the project name and a path to save it. Then, choose the version of SQL Server to migrate the data to.<\/li>\n<\/ul><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"674\" height=\"229\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image011-1.png\" alt=\"Version of SQL server for migration\" class=\"wp-image-140086 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image011-1.png 674w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image011-1-300x102.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image011-1-150x51.png 150w\" sizes=\"auto, (max-width: 674px) 100vw, 674px\" \/><\/figure><ul class=\"wp-block-list\">\n<li>In the main window, click on the <strong>Connect to MySQL<\/strong> button.<\/li>\n<\/ul><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"205\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image012-1.png\" alt=\"Click on Connect to MySQL button\" class=\"wp-image-140087 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image012-1.png 600w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image012-1-300x103.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image012-1-150x51.png 150w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/figure><ul class=\"wp-block-list\">\n<li>Enter the server&rsquo;s name, the username, and the password. Press the <strong>Connect<\/strong> button.<\/li>\n<\/ul><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"420\" height=\"331\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image013-1.png\" alt=\"Enter details and edit\" class=\"wp-image-140088 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image013-1.png 420w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image013-1-300x236.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image013-1-150x118.png 150w\" sizes=\"auto, (max-width: 420px) 100vw, 420px\" \/><\/figure><ul class=\"wp-block-list\">\n<li>The list of MySQL databases is shown. Press <strong>OK.<\/strong><\/li>\n<\/ul><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"388\" height=\"395\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image014-1.png\" alt=\"Loads all user objects\" class=\"wp-image-140089 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image014-1.png 388w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image014-1-295x300.png 295w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image014-1-150x153.png 150w\" sizes=\"auto, (max-width: 388px) 100vw, 388px\" \/><\/figure><ul class=\"wp-block-list\">\n<li>We selected our simple demo database, called TEST_SSMA, created with a single table, from the list of MySQL databases.<\/li>\n<\/ul><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"792\" height=\"203\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image015-1.png\" alt=\"List of the MySQL databases\" class=\"wp-image-140090 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image015-1.png 792w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image015-1-300x77.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image015-1-768x197.png 768w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image015-1-150x38.png 150w\" sizes=\"auto, (max-width: 792px) 100vw, 792px\" \/><\/figure><ul class=\"wp-block-list\">\n<li>Connect to the target database by pressing the <strong>Connect to SQL Server<\/strong> button.<\/li>\n<\/ul><ul class=\"wp-block-list\">\n<li>Enter the server name, database name, user name, and password.<\/li>\n<\/ul><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"406\" height=\"369\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image016-1.png\" alt=\"Enter Details\" class=\"wp-image-140091 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image016-1.png 406w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image016-1-300x273.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image016-1-150x136.png 150w\" sizes=\"auto, (max-width: 406px) 100vw, 406px\" \/><\/figure><ul class=\"wp-block-list\">\n<li>Select the database to process and then press the <strong>Migrate Data <\/strong>to start the migration of data.<\/li>\n<\/ul><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"709\" height=\"316\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image017-1.png\" alt=\"Migrate Data\" class=\"wp-image-140092 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image017-1.png 709w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image017-1-300x134.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image017-1-150x67.png 150w\" sizes=\"auto, (max-width: 709px) 100vw, 709px\" \/><\/figure><ul class=\"wp-block-list\">\n<li>A new connection to MySQL is needed. Press the <strong>Connect<\/strong> button.<\/li>\n<\/ul><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"420\" height=\"330\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image018.png\" alt=\"Adding All database details\" class=\"wp-image-140093 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image018.png 420w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image018-300x236.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image018-150x118.png 150w\" sizes=\"auto, (max-width: 420px) 100vw, 420px\" \/><\/figure><ul class=\"wp-block-list\">\n<li>A new SQL Server connection is needed. Click <strong>Connect<\/strong>.<\/li>\n<\/ul><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"407\" height=\"369\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image019.png\" alt=\"Click on Connect\" class=\"wp-image-140094 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image019.png 407w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image019-300x272.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image019-150x136.png 150w\" sizes=\"auto, (max-width: 407px) 100vw, 407px\" \/><\/figure><ul class=\"wp-block-list\">\n<li>At the end of the process, you will find your data in SQL Server.<\/li>\n<\/ul><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"784\" height=\"414\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image020.png\" alt=\"Edit on Tables\" class=\"wp-image-140095 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image020.png 784w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image020-300x158.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image020-768x406.png 768w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image020-150x79.png 150w\" sizes=\"auto, (max-width: 784px) 100vw, 784px\" \/><\/figure><p>You can also migrate other objects, such as schemas, triggers, indexes, etc. to the SQL Server.<\/p><h2 class=\"wp-block-heading\" id=\"a-better-alternative-to-convert-mysql-database-to-sql\"><strong>A Better Alternative to Convert MySQL Database to SQL<\/strong><\/h2><p>Though Microsoft makes available a free tool such as SSMA, you can also use third-party dedicated tools to perform database conversion. One such tool dedicated to <strong><a href=\"https:\/\/www.stellarinfo.com\/database-converter.php\" target=\"_blank\" rel=\"noreferrer noopener\">database conversion<\/a> <\/strong>is Stellar Converter for Database. It can easily and quickly convert database file from one type to another. This application supports MS SQL (.mdf), MySQL, SQLite (.db and .sqlite), and SQL Anywhere (.db).<\/p><p><strong>Stellar Converter for Database has some unique features, such as:<\/strong><\/p><ul class=\"wp-block-list\">\n<li>Can convert a single table.<\/li>\n\n\n\n<li>Can convert an offline database.<\/li>\n\n\n\n<li>Interconverts between different database types.<\/li>\n<\/ul><p><strong>Now let&rsquo;s see the installation of the software.<\/strong><\/p><ul class=\"wp-block-list\">\n<li>Go to the product page and download the executable by pressing the Free Download button.<\/li>\n<\/ul><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"819\" height=\"321\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image021.png\" alt=\"Stellar Converter for Database Product Page\" class=\"wp-image-140184 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image021.png 819w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image021-300x118.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image021-768x301.png 768w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image021-150x59.png 150w\" sizes=\"auto, (max-width: 819px) 100vw, 819px\" \/><\/figure><ul class=\"wp-block-list\">\n<li>Once downloaded, double-click on the executable file.<\/li>\n<\/ul><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"709\" height=\"58\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image022.png\" alt=\"Click on executable file\" class=\"wp-image-140185 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image022.png 709w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image022-300x25.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image022-150x12.png 150w\" sizes=\"auto, (max-width: 709px) 100vw, 709px\" \/><\/figure><ul class=\"wp-block-list\">\n<li>A welcome window appears. Press the Next button.<\/li>\n<\/ul><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"475\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image023.png\" alt=\"Stellar Converter for Database Setup Wizard\" class=\"wp-image-140186 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image023.png 600w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image023-300x238.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image023-150x119.png 150w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/figure><ul class=\"wp-block-list\">\n<li>Accept the licence agreement and press the <strong>Next<\/strong> button.<\/li>\n<\/ul><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"500\" height=\"394\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image024.png\" alt=\"Licence Agreement\" class=\"wp-image-140236 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image024.png 500w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image024-300x236.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image024-150x118.png 150w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" \/><\/figure><ul class=\"wp-block-list\">\n<li>Choose the path to install the application. Press the Next button.<\/li>\n<\/ul><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"501\" height=\"394\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image025.png\" alt=\"Destination Path\" class=\"wp-image-140237 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image025.png 501w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image025-300x236.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image025-150x118.png 150w\" sizes=\"auto, (max-width: 501px) 100vw, 501px\" \/><\/figure><ul class=\"wp-block-list\">\n<li>An item in the start menu folder is created. Press the Next button.<\/li>\n<\/ul><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"502\" height=\"397\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image026.png\" alt=\"Setup for Converter for Database\" class=\"wp-image-140238 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image026.png 502w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image026-300x237.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image026-150x119.png 150w\" sizes=\"auto, (max-width: 502px) 100vw, 502px\" \/><\/figure><ul class=\"wp-block-list\">\n<li>Choose if you want to create a Desktop shortcut or the Quick Launch shortcut.<\/li>\n<\/ul><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"470\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image027.png\" alt=\"Additional tasks\" class=\"wp-image-140239 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image027.png 600w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image027-300x235.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image027-150x118.png 150w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/figure><ul class=\"wp-block-list\">\n<li>Press the Install button to start the installation procedure.<\/li>\n<\/ul><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"474\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image028.png\" alt=\"Install Procedure\" class=\"wp-image-140241 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image028.png 600w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image028-300x237.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image028-150x119.png 150w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/figure><ul class=\"wp-block-list\">\n<li>Stellar Converter for Database is installed. Press the Finish button.<\/li>\n<\/ul><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"471\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image029-1.png\" alt=\"Lauching the software\" class=\"wp-image-140242 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image029-1.png 600w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image029-1-300x236.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image029-1-150x118.png 150w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/figure><p><strong>Now let&rsquo;s see how to use the software.<\/strong><\/p><ul class=\"wp-block-list\">\n<li>Launch the program and choose the type of the source database. There are 5 options: MS Access, MS SQL, My SQL, SQL Anywhere, and SQL Lite.<\/li>\n<\/ul><ul class=\"wp-block-list\">\n<li>By default, data is read when the database is offline. You can choose to read data directly from the &ldquo;live&rdquo; database.<\/li>\n\n\n\n<li>Select MySQL as Data Source and Browse for files.<\/li>\n<\/ul><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"803\" height=\"419\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image030.png\" alt=\"Stellar Converter for database software\" class=\"wp-image-140243 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image030.png 803w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image030-300x157.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image030-768x401.png 768w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image030-150x78.png 150w\" sizes=\"auto, (max-width: 803px) 100vw, 803px\" \/><\/figure><ul class=\"wp-block-list\">\n<li>Enter a MySQL database and press Scan.<\/li>\n\n\n\n<li>On the left panel, the structure of the MySQL file is shown.<\/li>\n\n\n\n<li>Press the Convert button.<\/li>\n<\/ul><figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"217\" src=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image031.png\" alt=\"Convert option\" class=\"wp-image-140244 apply-gradient-on-post-images\" srcset=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image031.png 600w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image031-300x109.png 300w, https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/image031-150x54.png 150w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/figure><ul class=\"wp-block-list\">\n<li>Conversion will start and proceed super easy.<\/li>\n<\/ul><h2 class=\"wp-block-heading\" id=\"conclusion\"><strong>Conclusion<\/strong><\/h2><p>As you have seen, Microsoft provides a free utility, named SSMA for MySQL that is dedicated to migrating databases from MySQL to SQL Server. We have discussed the step-by-step process to migrate MySQL database to SQL Server using this utility. In addition, we have mentioned an alternative utility called <strong><a href=\"https:\/\/www.stellarinfo.com\/database-converter.php\" target=\"_blank\" rel=\"noreferrer noopener\">Stellar Converter for Database<\/a><\/strong>, which is also dedicated to data migration. This software interconverts MS SQL (.mdf), MySQL, SQLite (.db and .sqlite), SQL Anywhere (.db), and MS Access (.mdb and .accdb).<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft&rsquo;s SQL Server Migration Assistant (SSMA) for MySQL is a free tool&hellip; <a class=\"more-link\" href=\"https:\/\/www.stellarinfo.com\/blog\/migrating-from-mysql-to-sql-server-using-ssma\/\">Continue reading <span class=\"screen-reader-text\">Migrating from MySQL to SQL Server using SSMA<\/span><\/a><\/p>\n","protected":false},"author":85,"featured_media":140075,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[2045],"tags":[5178],"class_list":["post-140074","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-converter","tag-mysql-to-sql","entry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Migrate from MySQL to SQL Server with SSMA<\/title>\n<meta name=\"description\" content=\"Learn how to seamlessly migrate from MySQL to SQL Server using SSMA. Ensure a smooth transition and optimize your database management\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.stellarinfo.com\/blog\/migrating-from-mysql-to-sql-server-using-ssma\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Migrate from MySQL to SQL Server with SSMA\" \/>\n<meta property=\"og:description\" content=\"Learn how to seamlessly migrate from MySQL to SQL Server using SSMA. Ensure a smooth transition and optimize your database management\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.stellarinfo.com\/blog\/migrating-from-mysql-to-sql-server-using-ssma\/\" \/>\n<meta property=\"og:site_name\" content=\"Stellar Data Recovery Blog\" \/>\n<meta property=\"article:published_time\" content=\"2023-06-28T09:19:10+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-30T06:50:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/SSMA-Migrating-from-MySQL-to-SQL-server.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1000\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Bharat Bhushan\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Bharat Bhushan\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/migrating-from-mysql-to-sql-server-using-ssma\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/migrating-from-mysql-to-sql-server-using-ssma\/\"},\"author\":{\"name\":\"Bharat Bhushan\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/c2edd14c25759638c6a69f5aececf07a\"},\"headline\":\"Migrating from MySQL to SQL Server using SSMA\",\"datePublished\":\"2023-06-28T09:19:10+00:00\",\"dateModified\":\"2023-06-30T06:50:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/migrating-from-mysql-to-sql-server-using-ssma\/\"},\"wordCount\":912,\"image\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/migrating-from-mysql-to-sql-server-using-ssma\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/SSMA-Migrating-from-MySQL-to-SQL-server.jpg\",\"keywords\":[\"mysql to sql\"],\"articleSection\":[\"Database Converter\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/migrating-from-mysql-to-sql-server-using-ssma\/\",\"url\":\"https:\/\/www.stellarinfo.com\/blog\/migrating-from-mysql-to-sql-server-using-ssma\/\",\"name\":\"Migrate from MySQL to SQL Server with SSMA\",\"isPartOf\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/migrating-from-mysql-to-sql-server-using-ssma\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/migrating-from-mysql-to-sql-server-using-ssma\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/SSMA-Migrating-from-MySQL-to-SQL-server.jpg\",\"datePublished\":\"2023-06-28T09:19:10+00:00\",\"dateModified\":\"2023-06-30T06:50:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/c2edd14c25759638c6a69f5aececf07a\"},\"description\":\"Learn how to seamlessly migrate from MySQL to SQL Server using SSMA. Ensure a smooth transition and optimize your database management\",\"breadcrumb\":{\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/migrating-from-mysql-to-sql-server-using-ssma\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.stellarinfo.com\/blog\/migrating-from-mysql-to-sql-server-using-ssma\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/migrating-from-mysql-to-sql-server-using-ssma\/#primaryimage\",\"url\":\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/SSMA-Migrating-from-MySQL-to-SQL-server.jpg\",\"contentUrl\":\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/SSMA-Migrating-from-MySQL-to-SQL-server.jpg\",\"width\":1000,\"height\":600},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/migrating-from-mysql-to-sql-server-using-ssma\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.stellarinfo.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Migrating from MySQL to SQL Server using SSMA\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#website\",\"url\":\"https:\/\/www.stellarinfo.com\/blog\/\",\"name\":\"Stellar Data Recovery Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.stellarinfo.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/c2edd14c25759638c6a69f5aececf07a\",\"name\":\"Bharat Bhushan\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8371107c793354293acf244b899d7bf7f4209ee58e4305f3b195241bd426ef12?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8371107c793354293acf244b899d7bf7f4209ee58e4305f3b195241bd426ef12?s=96&d=mm&r=g\",\"caption\":\"Bharat Bhushan\"},\"description\":\"Bharat Bhushan is an experienced technical Marketer working at Stellar Data Recovery - expertise in data care. He is skilled in Microsoft Exchange Database, MSSQL Database troubleshooting &amp; data warehousing. He is a Management Post Graduate having a strong grip in Technology &amp; certified in SAP-SD, Oracle 10g &amp; Informatica Powercenter 9.1.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/bharat-bhushan-311956144\/\"],\"url\":\"https:\/\/www.stellarinfo.com\/blog\/author\/bharat\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Migrate from MySQL to SQL Server with SSMA","description":"Learn how to seamlessly migrate from MySQL to SQL Server using SSMA. Ensure a smooth transition and optimize your database management","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.stellarinfo.com\/blog\/migrating-from-mysql-to-sql-server-using-ssma\/","og_locale":"en_US","og_type":"article","og_title":"Migrate from MySQL to SQL Server with SSMA","og_description":"Learn how to seamlessly migrate from MySQL to SQL Server using SSMA. Ensure a smooth transition and optimize your database management","og_url":"https:\/\/www.stellarinfo.com\/blog\/migrating-from-mysql-to-sql-server-using-ssma\/","og_site_name":"Stellar Data Recovery Blog","article_published_time":"2023-06-28T09:19:10+00:00","article_modified_time":"2023-06-30T06:50:00+00:00","og_image":[{"width":1000,"height":600,"url":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/SSMA-Migrating-from-MySQL-to-SQL-server.jpg","type":"image\/jpeg"}],"author":"Bharat Bhushan","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Bharat Bhushan","Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.stellarinfo.com\/blog\/migrating-from-mysql-to-sql-server-using-ssma\/#article","isPartOf":{"@id":"https:\/\/www.stellarinfo.com\/blog\/migrating-from-mysql-to-sql-server-using-ssma\/"},"author":{"name":"Bharat Bhushan","@id":"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/c2edd14c25759638c6a69f5aececf07a"},"headline":"Migrating from MySQL to SQL Server using SSMA","datePublished":"2023-06-28T09:19:10+00:00","dateModified":"2023-06-30T06:50:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.stellarinfo.com\/blog\/migrating-from-mysql-to-sql-server-using-ssma\/"},"wordCount":912,"image":{"@id":"https:\/\/www.stellarinfo.com\/blog\/migrating-from-mysql-to-sql-server-using-ssma\/#primaryimage"},"thumbnailUrl":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/SSMA-Migrating-from-MySQL-to-SQL-server.jpg","keywords":["mysql to sql"],"articleSection":["Database Converter"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.stellarinfo.com\/blog\/migrating-from-mysql-to-sql-server-using-ssma\/","url":"https:\/\/www.stellarinfo.com\/blog\/migrating-from-mysql-to-sql-server-using-ssma\/","name":"Migrate from MySQL to SQL Server with SSMA","isPartOf":{"@id":"https:\/\/www.stellarinfo.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.stellarinfo.com\/blog\/migrating-from-mysql-to-sql-server-using-ssma\/#primaryimage"},"image":{"@id":"https:\/\/www.stellarinfo.com\/blog\/migrating-from-mysql-to-sql-server-using-ssma\/#primaryimage"},"thumbnailUrl":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/SSMA-Migrating-from-MySQL-to-SQL-server.jpg","datePublished":"2023-06-28T09:19:10+00:00","dateModified":"2023-06-30T06:50:00+00:00","author":{"@id":"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/c2edd14c25759638c6a69f5aececf07a"},"description":"Learn how to seamlessly migrate from MySQL to SQL Server using SSMA. Ensure a smooth transition and optimize your database management","breadcrumb":{"@id":"https:\/\/www.stellarinfo.com\/blog\/migrating-from-mysql-to-sql-server-using-ssma\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.stellarinfo.com\/blog\/migrating-from-mysql-to-sql-server-using-ssma\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.stellarinfo.com\/blog\/migrating-from-mysql-to-sql-server-using-ssma\/#primaryimage","url":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/SSMA-Migrating-from-MySQL-to-SQL-server.jpg","contentUrl":"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2023\/06\/SSMA-Migrating-from-MySQL-to-SQL-server.jpg","width":1000,"height":600},{"@type":"BreadcrumbList","@id":"https:\/\/www.stellarinfo.com\/blog\/migrating-from-mysql-to-sql-server-using-ssma\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.stellarinfo.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Migrating from MySQL to SQL Server using SSMA"}]},{"@type":"WebSite","@id":"https:\/\/www.stellarinfo.com\/blog\/#website","url":"https:\/\/www.stellarinfo.com\/blog\/","name":"Stellar Data Recovery Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.stellarinfo.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/c2edd14c25759638c6a69f5aececf07a","name":"Bharat Bhushan","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.stellarinfo.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8371107c793354293acf244b899d7bf7f4209ee58e4305f3b195241bd426ef12?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8371107c793354293acf244b899d7bf7f4209ee58e4305f3b195241bd426ef12?s=96&d=mm&r=g","caption":"Bharat Bhushan"},"description":"Bharat Bhushan is an experienced technical Marketer working at Stellar Data Recovery - expertise in data care. He is skilled in Microsoft Exchange Database, MSSQL Database troubleshooting &amp; data warehousing. He is a Management Post Graduate having a strong grip in Technology &amp; certified in SAP-SD, Oracle 10g &amp; Informatica Powercenter 9.1.","sameAs":["https:\/\/www.linkedin.com\/in\/bharat-bhushan-311956144\/"],"url":"https:\/\/www.stellarinfo.com\/blog\/author\/bharat\/"}]}},"_links":{"self":[{"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/posts\/140074","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/users\/85"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/comments?post=140074"}],"version-history":[{"count":18,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/posts\/140074\/revisions"}],"predecessor-version":[{"id":140753,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/posts\/140074\/revisions\/140753"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/media\/140075"}],"wp:attachment":[{"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/media?parent=140074"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/categories?post=140074"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stellarinfo.com\/blog\/wp-json\/wp\/v2\/tags?post=140074"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}