{"id":763,"date":"2016-09-20T05:42:50","date_gmt":"2016-09-20T05:42:50","guid":{"rendered":"https:\/\/www.knowband.com\/blog\/?p=763"},"modified":"2022-08-13T12:01:14","modified_gmt":"2018-10-31T11:54:52","slug":"how-to-migrate-from-mysql-database-to-mssql-database","status":"publish","type":"post","link":"https:\/\/www.knowband.com\/blog\/ecommerce-blog\/how-to-migrate-from-mysql-database-to-mssql-database\/","title":{"rendered":"How to migrate from MySQL Database to MSSQL Database?"},"content":{"rendered":"<p style=\"text-align: justify;\">Migration is the crucial and important step in a business environment due to the various restrictions in a platform or a framework and the need to make the data accessible on other required platforms. This migration helps in improving the usability and access to data or content among different available platforms.<\/p>\n<p style=\"text-align: justify;\">Here, we are discussing how to migrate the data of MySQL into Microsoft SQL Server in a flawless manner. There is no \u201cRocket Science\u201d involved in the entire process and it is as simple as it can be. By performing certain simple steps, it is now much easier to plan the migration from MySQL platform to Microsoft SQL Server environment. Before going further in this direction, let us first discuss the various things that need to be considered while planning a migration process.<\/p>\n<p style=\"text-align: justify;\"><strong>Checklists for the data migration from MySQL to MSSQL platform<\/strong><\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/www.knowband.com\/blog\/wp-content\/uploads\/2016\/09\/data-migration-checklist.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-22411 \" src=\"https:\/\/www.knowband.com\/blog\/wp-content\/uploads\/2016\/09\/data-migration-checklist.jpg\" alt=\"data-migration-checklist\" width=\"443\" height=\"277\" srcset=\"https:\/\/www.knowband.com\/blog\/wp-content\/uploads\/2016\/09\/data-migration-checklist.jpg 1000w, https:\/\/www.knowband.com\/blog\/wp-content\/uploads\/2016\/09\/data-migration-checklist-300x188.jpg 300w, https:\/\/www.knowband.com\/blog\/wp-content\/uploads\/2016\/09\/data-migration-checklist-768x480.jpg 768w\" sizes=\"auto, (max-width: 443px) 100vw, 443px\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">If you want to perform the data migration task from MySQL to MSSQL platform in a flawless manner, you need to pay attention to various things.<\/p>\n<ul style=\"text-align: justify;\">\n<li>You need to ensure that the MySQL is properly installed on the various operating systems. There are different <a href=\"https:\/\/www.knowband.com\/blog\/ecommerce-blog\/how-to-install-mysql-on-windows-and-linux-systems\/\" target=\"_blank\">installation steps for MySQL for Windows and Linux Ubuntu platforms<\/a>. Check out the operating system first and then follow the required installation steps accordingly.<\/li>\n<\/ul>\n<ul style=\"text-align: justify;\">\n<li>It is also important to analyze properly if the SQL Server Management Studio is installed efficiently or not. In the case of the Windows system, you need to perform the certain <a href=\"https:\/\/www.knowband.com\/blog\/ecommerce-blog\/how-to-get-sql-server-management-studio-2008-express-installed-on-a-windows-7\/\" target=\"_blank\">installation steps for Microsoft SQL Server Management Studio<\/a>. This platform is restricted to Window users only and is not available for Linux users.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><strong>Data Migration Steps from MySQL to MSSQL platform<\/strong><\/p>\n<p style=\"text-align: justify;\">Here is the step by step instructions for performing the data migration from MySQL platform to MSSQL platform. Take a look below at these simple steps.<\/p>\n<ul style=\"text-align: justify;\">\n<li>You need to first download and install the MySQL ODBC Connector, to begin with, the above process. You can also find out the latest release of this extension <a href=\"https:\/\/dev.mysql.com\/downloads\/connector\/odbc\/\" target=\"_blank\" rel=\"nofollow\">here<\/a>.<\/li>\n<li>Now, it is time to download and install SQL Server Migration Assistant for MySQL platform. Users can easily download the same from <a href=\"https:\/\/www.microsoft.com\/en-in\/download\/details.aspx?id=42657\" target=\"_blank\" rel=\"nofollow\">here<\/a>.<\/li>\n<li>On the same page, you need to locate and click on the \u201cDownload\u201d button. The action would open up a new page. Once the page is opened, you need to select the file named as \u201cSSMA_MySql\\SSMA for MySql.5.3.0.exe\u201d. The user just has to download the required file from there and get it installed on your system.<\/li>\n<li>The user just has to open the \u201cMicrosoft SQL Server Migration Assistant for MySQL\u201d tool that is already installed on your system. In case, the tool is not visible on the desktop, it is time to go to \u201cStart\u201d button and search the same tool over there. You would get the screen as shown below:<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/www.knowband.com\/blog\/wp-content\/uploads\/2016\/09\/Microsoft-SQL-Server-Migration-Assistant-for-MySQL.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-769 size-full\" src=\"https:\/\/www.knowband.com\/blog\/wp-content\/uploads\/2016\/09\/Microsoft-SQL-Server-Migration-Assistant-for-MySQL.png\" alt=\"Microsoft SQL Server Migration Assistant for MySQL | Knowband\" width=\"853\" height=\"520\" srcset=\"https:\/\/www.knowband.com\/blog\/wp-content\/uploads\/2016\/09\/Microsoft-SQL-Server-Migration-Assistant-for-MySQL.png 853w, https:\/\/www.knowband.com\/blog\/wp-content\/uploads\/2016\/09\/Microsoft-SQL-Server-Migration-Assistant-for-MySQL-300x183.png 300w, https:\/\/www.knowband.com\/blog\/wp-content\/uploads\/2016\/09\/Microsoft-SQL-Server-Migration-Assistant-for-MySQL-768x468.png 768w\" sizes=\"auto, (max-width: 853px) 100vw, 853px\" \/><\/a><\/p>\n<ul style=\"text-align: justify;\">\n<li>To get started with this platform, you need to go to \u201cFile -&gt; New Project\u201d and then create a new project for the data migration from MySQL to MSSQL platform. Here is the screenshot of the same process as shown below:<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/www.knowband.com\/blog\/wp-content\/uploads\/2016\/09\/New-Project.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-767 size-full\" src=\"https:\/\/www.knowband.com\/blog\/wp-content\/uploads\/2016\/09\/New-Project.png\" alt=\"MySQL data conversion into Microsoft SQL Server- New Project | Knowband\" width=\"598\" height=\"212\" srcset=\"https:\/\/www.knowband.com\/blog\/wp-content\/uploads\/2016\/09\/New-Project.png 598w, https:\/\/www.knowband.com\/blog\/wp-content\/uploads\/2016\/09\/New-Project-300x106.png 300w\" sizes=\"auto, (max-width: 598px) 100vw, 598px\" \/><\/a><\/p>\n<ul style=\"text-align: justify;\">\n<li>Once, the user has created the project successfully, it is time to click on the \u201cConnect to MySQL\u201d option present on the top of the page. A dialog box would be opened known as \u201cConnect to MySQL\u201d. Once, the dialog box is opened, user needs to perform the following functions:<\/li>\n<li>First, select the \u201cProvider\u201d as \u201cMySQL ODBC 5.1 Driver\u201d.<\/li>\n<li>Now, enter the \u201cServer name\u201d as \u201clocalhost\u201d.<\/li>\n<li>You need to enter the \u201cUsername\u201d and \u201cPassword\u201d of localhost which are required for logging into the MySQL.<\/li>\n<li>Finally, you need to click on the \u201cConnect\u201d option. This will help in connecting the user to MySQL and contains the list of all the databases that are mapped along with the username that are used for login purposes.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/www.knowband.com\/blog\/wp-content\/uploads\/2016\/09\/Connect-to-MySQL-.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-772 size-full\" src=\"https:\/\/www.knowband.com\/blog\/wp-content\/uploads\/2016\/09\/Connect-to-MySQL-.png\" alt=\"MySQL data conversion into Microsoft SQL Server- Connect to Mysql | Knowband\" width=\"437\" height=\"339\" srcset=\"https:\/\/www.knowband.com\/blog\/wp-content\/uploads\/2016\/09\/Connect-to-MySQL-.png 437w, https:\/\/www.knowband.com\/blog\/wp-content\/uploads\/2016\/09\/Connect-to-MySQL--300x233.png 300w\" sizes=\"auto, (max-width: 437px) 100vw, 437px\" \/><\/a><\/p>\n<ul style=\"text-align: justify;\">\n<li>After this, you need to click on the \u201cConnect to SQL Server\u201d option provided at the top. This will open up a new dialog box known as \u201cConnect to SQL Server\u201d as shown below. Now, you need to perform the following steps as mentioned below:<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/www.knowband.com\/blog\/wp-content\/uploads\/2016\/09\/Connect-to-SQL-Server.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-771 size-full\" src=\"https:\/\/www.knowband.com\/blog\/wp-content\/uploads\/2016\/09\/Connect-to-SQL-Server.png\" alt=\"MySQL data conversion into Microsoft SQL Server- Connect to sql server | Knowband\" width=\"425\" height=\"363\" srcset=\"https:\/\/www.knowband.com\/blog\/wp-content\/uploads\/2016\/09\/Connect-to-SQL-Server.png 425w, https:\/\/www.knowband.com\/blog\/wp-content\/uploads\/2016\/09\/Connect-to-SQL-Server-300x256.png 300w\" sizes=\"auto, (max-width: 425px) 100vw, 425px\" \/><\/a><\/p>\n<ul style=\"text-align: justify;\">\n<li>You need to first select or enter the Server Name.<\/li>\n<li>Now, the user needs to select the \u201cServer Port\u201d as \u201cdefault\u201d.<\/li>\n<li>To carry out the data migration of the MySQL platform, it is important to select the right database. This database creation in SQL Server with the help of \u201cSQL Server Management Studio\u201d is an important step before the creation of a database connection.<\/li>\n<li>The user needs to select the \u201cAuthentication\u201d as Windows or SQL Server.<\/li>\n<li>It is required to enter the \u201cUsername\u201d and \u201cPassword\u201d for connecting the SQL Server.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Finally, you need to click on the \u201cConnect\u201d option. It will open up a new dialog box that says \u201cOperation Prerequisite Not Met\u201d, you need to click on \u201cContinue\u201d option. With this step, you would be able to establish a connection with SQL Server along with list of all the databases. Below are the images about the same process.<\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/www.knowband.com\/blog\/wp-content\/uploads\/2016\/09\/Operation-Prerequisite-Not-Met.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-766 size-full\" src=\"https:\/\/www.knowband.com\/blog\/wp-content\/uploads\/2016\/09\/Operation-Prerequisite-Not-Met.png\" alt=\"MySQL data conversion into Microsoft SQL Server- Operation prerequisite not met | Knowband\" width=\"577\" height=\"272\" srcset=\"https:\/\/www.knowband.com\/blog\/wp-content\/uploads\/2016\/09\/Operation-Prerequisite-Not-Met.png 577w, https:\/\/www.knowband.com\/blog\/wp-content\/uploads\/2016\/09\/Operation-Prerequisite-Not-Met-300x141.png 300w\" sizes=\"auto, (max-width: 577px) 100vw, 577px\" \/><\/a><\/p>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/www.knowband.com\/blog\/wp-content\/uploads\/2016\/09\/SQL-Server-Database-Management-Schema.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-765 size-full\" src=\"https:\/\/www.knowband.com\/blog\/wp-content\/uploads\/2016\/09\/SQL-Server-Database-Management-Schema.png\" alt=\"MySQL data conversion into Microsoft SQL Server- Sql server database management schema | Knowband\" width=\"858\" height=\"526\" srcset=\"https:\/\/www.knowband.com\/blog\/wp-content\/uploads\/2016\/09\/SQL-Server-Database-Management-Schema.png 858w, https:\/\/www.knowband.com\/blog\/wp-content\/uploads\/2016\/09\/SQL-Server-Database-Management-Schema-300x184.png 300w, https:\/\/www.knowband.com\/blog\/wp-content\/uploads\/2016\/09\/SQL-Server-Database-Management-Schema-768x471.png 768w\" sizes=\"auto, (max-width: 858px) 100vw, 858px\" \/><\/a><\/p>\n<ul style=\"text-align: justify;\">\n<li>Now, you need to select the database from \u201cMySQL Metadata Explorer\u201d sub- window that needs to be migrated to SQL Server. Once, you have made the selection, a \u201cConvert Schema\u201d option is enabled which needs to be clicked. With this step, you can easily convert the MySQL Database Schema into the SQL Server Database Schema. This process changes the data types of all the columns available in database tables into an applicable data type of the SQL Server.<\/li>\n<\/ul>\n<ul style=\"text-align: justify;\">\n<li>Once, the schema has been converted, you need to select the database from the \u201cSQL Server Metadata Explorer\u201d sub-window. The user just have to right click on that and then select \u201cSave as Script\u201d option to save the required script into the desired location of the system. This is an important step before finally accomplishing the data migration as all the tables of your existing MySQL needs to be created on the target database of the SQL Server.<\/li>\n<\/ul>\n<ul style=\"text-align: justify;\">\n<li>Now, it is time to locate the file that you have saved and double click on it. An \u201cSQL Server Management Studio\u201d window will open up asking for the establishment of connection with the SQL Server. You need to enter the required credentials over there and then click on the \u201cConnect\u201d option.<\/li>\n<\/ul>\n<ul style=\"text-align: justify;\">\n<li>Once, the connection has been established, you need to click on the \u201cExecute\u201d option located at the top. This option will help in executing the file and will include all the tables into the selected database as shown in the image below:<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/www.knowband.com\/blog\/wp-content\/uploads\/2016\/09\/SQL-Server-Database-Operation-Window.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-764 size-full\" src=\"https:\/\/www.knowband.com\/blog\/wp-content\/uploads\/2016\/09\/SQL-Server-Database-Operation-Window.png\" alt=\"MySQL data conversion into Microsoft SQL Server- Sql server database operation window | Knowband\" width=\"914\" height=\"534\" srcset=\"https:\/\/www.knowband.com\/blog\/wp-content\/uploads\/2016\/09\/SQL-Server-Database-Operation-Window.png 914w, https:\/\/www.knowband.com\/blog\/wp-content\/uploads\/2016\/09\/SQL-Server-Database-Operation-Window-300x175.png 300w, https:\/\/www.knowband.com\/blog\/wp-content\/uploads\/2016\/09\/SQL-Server-Database-Operation-Window-768x449.png 768w\" sizes=\"auto, (max-width: 914px) 100vw, 914px\" \/><\/a><\/p>\n<ul style=\"text-align: justify;\">\n<li>Now, you need to move towards the \u201cSQL Server Migration Assistant\u201d tool and then select the required database where you want to perform the migration into the SQL Server. This will help in enabling the \u201cMigrate Data\u201d option provided at the top. By clicking on it, a dialog box will open up asking for the establishment of the connection with MySQL and SQL Server one by one. You need to enter the required credentials over there to establish the connection as shown in the image below:<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/www.knowband.com\/blog\/wp-content\/uploads\/2016\/09\/Data-Migration-Report.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-770 size-full\" src=\"https:\/\/www.knowband.com\/blog\/wp-content\/uploads\/2016\/09\/Data-Migration-Report.png\" alt=\"MySQL data conversion into Microsoft SQL Server- Data migration report | Knowband\" width=\"860\" height=\"433\" srcset=\"https:\/\/www.knowband.com\/blog\/wp-content\/uploads\/2016\/09\/Data-Migration-Report.png 860w, https:\/\/www.knowband.com\/blog\/wp-content\/uploads\/2016\/09\/Data-Migration-Report-300x151.png 300w, https:\/\/www.knowband.com\/blog\/wp-content\/uploads\/2016\/09\/Data-Migration-Report-768x387.png 768w\" sizes=\"auto, (max-width: 860px) 100vw, 860px\" \/><\/a><\/p>\n<ul style=\"text-align: justify;\">\n<li>Once, you have successfully established the connection, the system would automatically migrate the data into the targeted database of SQL Server and can also be seen in the \u201cSQL Server Management Studio\u201d for refreshing the above database.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">With the implementation of these simple steps, it is now easier to migrate the data of MySQL into the MSSQL platform without any trouble. In this way, websites can migrate their existing database from the MySQL platform to MSSQL Server in a quick and efficient manner. For more information about the useful <strong>eCommerce extensions<\/strong> that can help in the data migration services, you can visit our website at <a href=\"https:\/\/www.knowband.com\" target=\"_blank\">knowband<\/a> for availing our expert custom module development services.<\/p>\n<p style=\"text-align: justify;\"><strong>Liked This? You\u2019ll Like These Too<\/strong><\/p>\n<ul>\n<li style=\"text-align: justify;\"><a href=\"https:\/\/www.knowband.com\/blog\/ecommerce-blog\/how-to-get-sql-server-management-studio-2008-express-installed-on-a-windows-7\/\" target=\"_blank\">How to get SQL Server Management Studio 2008 Express installed on a Windows 7?<\/a><\/li>\n<li style=\"text-align: justify;\"><a href=\"https:\/\/www.knowband.com\/blog\/ecommerce-blog\/how-to-install-mysql-on-windows-and-linux-systems\/\" target=\"_blank\">How to install MySQL on Windows and Linux Systems?<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Migration is the crucial and important step in a business environment due to the various restrictions in a platform or a framework and the need to make the data accessible on other required platforms. This migration helps in improving the usability and access to data or content among different available platforms. Here, we are discussing [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":775,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_kbui_enabled":"","footnotes":""},"categories":[4],"tags":[7558,7559,7557,7560],"class_list":["post-763","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ecommerce-blog","tag-how-to-migrate-from-mysql-to-mssql","tag-how-to-move-from-mysql-to-mssql","tag-migrate-from-mysql-database-to-mssql-database","tag-move-from-mysql-to-mssql"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to migrate from MySQL to MSSQL? - Knowband Blog<\/title>\n<meta name=\"description\" content=\"Are you facing major issues while migrating your data from MySQL in MSSQL Server? Check out this blog that for seamless data migration.\" \/>\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.knowband.com\/blog\/ecommerce-blog\/how-to-migrate-from-mysql-database-to-mssql-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to migrate from MySQL to MSSQL? - Knowband Blog\" \/>\n<meta property=\"og:description\" content=\"Are you facing major issues while migrating your data from MySQL in MSSQL Server? Check out this blog that for seamless data migration.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.knowband.com\/blog\/ecommerce-blog\/how-to-migrate-from-mysql-database-to-mssql-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Knowband Blog | Ecommerce Modules\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/Knowband\" \/>\n<meta property=\"article:published_time\" content=\"2016-09-20T05:42:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-10-31T11:54:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.knowband.com\/blog\/wp-content\/uploads\/2016\/09\/How-to-get-your-MySQL-data-converted-into-Microsoft-SQL-Server.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"755\" \/>\n\t<meta property=\"og:image:height\" content=\"333\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Joe Parker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@KnowbandPlugin\" \/>\n<meta name=\"twitter:site\" content=\"@KnowbandPlugin\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Joe Parker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/ecommerce-blog\\\/how-to-migrate-from-mysql-database-to-mssql-database\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/ecommerce-blog\\\/how-to-migrate-from-mysql-database-to-mssql-database\\\/\"},\"author\":{\"name\":\"Joe Parker\",\"@id\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/fr\\\/#\\\/schema\\\/person\\\/3d766b60ef5a1c9338ff341a544f27a8\"},\"headline\":\"How to migrate from MySQL Database to MSSQL Database?\",\"datePublished\":\"2016-09-20T05:42:50+00:00\",\"dateModified\":\"2018-10-31T11:54:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/ecommerce-blog\\\/how-to-migrate-from-mysql-database-to-mssql-database\\\/\"},\"wordCount\":1311,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/fr\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/ecommerce-blog\\\/how-to-migrate-from-mysql-database-to-mssql-database\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/09\\\/How-to-get-your-MySQL-data-converted-into-Microsoft-SQL-Server.jpg\",\"keywords\":[\"How to migrate from MySQL to MSSQL\",\"How to move from mysql to mssql\",\"Migrate from MySQL Database to MSSQL Database\",\"move from mysql to mssql\"],\"articleSection\":[\"Ecommerce\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/ecommerce-blog\\\/how-to-migrate-from-mysql-database-to-mssql-database\\\/\",\"url\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/ecommerce-blog\\\/how-to-migrate-from-mysql-database-to-mssql-database\\\/\",\"name\":\"How to migrate from MySQL to MSSQL? - Knowband Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/fr\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/ecommerce-blog\\\/how-to-migrate-from-mysql-database-to-mssql-database\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/ecommerce-blog\\\/how-to-migrate-from-mysql-database-to-mssql-database\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/09\\\/How-to-get-your-MySQL-data-converted-into-Microsoft-SQL-Server.jpg\",\"datePublished\":\"2016-09-20T05:42:50+00:00\",\"dateModified\":\"2018-10-31T11:54:52+00:00\",\"description\":\"Are you facing major issues while migrating your data from MySQL in MSSQL Server? Check out this blog that for seamless data migration.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/ecommerce-blog\\\/how-to-migrate-from-mysql-database-to-mssql-database\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.knowband.com\\\/blog\\\/ecommerce-blog\\\/how-to-migrate-from-mysql-database-to-mssql-database\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/ecommerce-blog\\\/how-to-migrate-from-mysql-database-to-mssql-database\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/09\\\/How-to-get-your-MySQL-data-converted-into-Microsoft-SQL-Server.jpg\",\"contentUrl\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/09\\\/How-to-get-your-MySQL-data-converted-into-Microsoft-SQL-Server.jpg\",\"width\":755,\"height\":333,\"caption\":\"How to get your MySQL data converted into Microsoft SQL Server? | Knowband\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/ecommerce-blog\\\/how-to-migrate-from-mysql-database-to-mssql-database\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/fr\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to migrate from MySQL Database to MSSQL Database?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/fr\\\/#website\",\"url\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/fr\\\/\",\"name\":\"Knowband Blog | Ecommerce Modules\",\"description\":\"Magento, Prestashop, Opencart, Shopify\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/fr\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/fr\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/fr\\\/#organization\",\"name\":\"Knowband Blog | Ecommerce Modules\",\"url\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/fr\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/fr\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/09\\\/cropped-knowband_logo-v2.png\",\"contentUrl\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/wp-content\\\/uploads\\\/2016\\\/09\\\/cropped-knowband_logo-v2.png\",\"width\":153,\"height\":61,\"caption\":\"Knowband Blog | Ecommerce Modules\"},\"image\":{\"@id\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/fr\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/Knowband\",\"https:\\\/\\\/x.com\\\/KnowbandPlugin\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/fr\\\/#\\\/schema\\\/person\\\/3d766b60ef5a1c9338ff341a544f27a8\",\"name\":\"Joe Parker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/wp-content\\\/plugins\\\/wp-user-avatar\\\/deprecated\\\/wp-user-avatar\\\/images\\\/wpua-96x96.png\",\"url\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/wp-content\\\/plugins\\\/wp-user-avatar\\\/deprecated\\\/wp-user-avatar\\\/images\\\/wpua-96x96.png\",\"contentUrl\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/wp-content\\\/plugins\\\/wp-user-avatar\\\/deprecated\\\/wp-user-avatar\\\/images\\\/wpua-96x96.png\",\"caption\":\"Joe Parker\"},\"description\":\"We boast of the best in the industry plugins for eCommerce systems and has years of experience working with eCommerce websites. We provide best plugins for platforms like - Magento, Prestashop, OpenCart and Shopify . We also provide custom module development and customization services for the website and modules..\",\"url\":\"https:\\\/\\\/www.knowband.com\\\/blog\\\/author\\\/joe\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to migrate from MySQL to MSSQL? - Knowband Blog","description":"Are you facing major issues while migrating your data from MySQL in MSSQL Server? Check out this blog that for seamless data migration.","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.knowband.com\/blog\/ecommerce-blog\/how-to-migrate-from-mysql-database-to-mssql-database\/","og_locale":"en_US","og_type":"article","og_title":"How to migrate from MySQL to MSSQL? - Knowband Blog","og_description":"Are you facing major issues while migrating your data from MySQL in MSSQL Server? Check out this blog that for seamless data migration.","og_url":"https:\/\/www.knowband.com\/blog\/ecommerce-blog\/how-to-migrate-from-mysql-database-to-mssql-database\/","og_site_name":"Knowband Blog | Ecommerce Modules","article_publisher":"https:\/\/www.facebook.com\/Knowband","article_published_time":"2016-09-20T05:42:50+00:00","article_modified_time":"2018-10-31T11:54:52+00:00","og_image":[{"width":755,"height":333,"url":"https:\/\/www.knowband.com\/blog\/wp-content\/uploads\/2016\/09\/How-to-get-your-MySQL-data-converted-into-Microsoft-SQL-Server.jpg","type":"image\/jpeg"}],"author":"Joe Parker","twitter_card":"summary_large_image","twitter_creator":"@KnowbandPlugin","twitter_site":"@KnowbandPlugin","twitter_misc":{"Written by":"Joe Parker","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.knowband.com\/blog\/ecommerce-blog\/how-to-migrate-from-mysql-database-to-mssql-database\/#article","isPartOf":{"@id":"https:\/\/www.knowband.com\/blog\/ecommerce-blog\/how-to-migrate-from-mysql-database-to-mssql-database\/"},"author":{"name":"Joe Parker","@id":"https:\/\/www.knowband.com\/blog\/fr\/#\/schema\/person\/3d766b60ef5a1c9338ff341a544f27a8"},"headline":"How to migrate from MySQL Database to MSSQL Database?","datePublished":"2016-09-20T05:42:50+00:00","dateModified":"2018-10-31T11:54:52+00:00","mainEntityOfPage":{"@id":"https:\/\/www.knowband.com\/blog\/ecommerce-blog\/how-to-migrate-from-mysql-database-to-mssql-database\/"},"wordCount":1311,"commentCount":0,"publisher":{"@id":"https:\/\/www.knowband.com\/blog\/fr\/#organization"},"image":{"@id":"https:\/\/www.knowband.com\/blog\/ecommerce-blog\/how-to-migrate-from-mysql-database-to-mssql-database\/#primaryimage"},"thumbnailUrl":"https:\/\/www.knowband.com\/blog\/wp-content\/uploads\/2016\/09\/How-to-get-your-MySQL-data-converted-into-Microsoft-SQL-Server.jpg","keywords":["How to migrate from MySQL to MSSQL","How to move from mysql to mssql","Migrate from MySQL Database to MSSQL Database","move from mysql to mssql"],"articleSection":["Ecommerce"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.knowband.com\/blog\/ecommerce-blog\/how-to-migrate-from-mysql-database-to-mssql-database\/","url":"https:\/\/www.knowband.com\/blog\/ecommerce-blog\/how-to-migrate-from-mysql-database-to-mssql-database\/","name":"How to migrate from MySQL to MSSQL? - Knowband Blog","isPartOf":{"@id":"https:\/\/www.knowband.com\/blog\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.knowband.com\/blog\/ecommerce-blog\/how-to-migrate-from-mysql-database-to-mssql-database\/#primaryimage"},"image":{"@id":"https:\/\/www.knowband.com\/blog\/ecommerce-blog\/how-to-migrate-from-mysql-database-to-mssql-database\/#primaryimage"},"thumbnailUrl":"https:\/\/www.knowband.com\/blog\/wp-content\/uploads\/2016\/09\/How-to-get-your-MySQL-data-converted-into-Microsoft-SQL-Server.jpg","datePublished":"2016-09-20T05:42:50+00:00","dateModified":"2018-10-31T11:54:52+00:00","description":"Are you facing major issues while migrating your data from MySQL in MSSQL Server? Check out this blog that for seamless data migration.","breadcrumb":{"@id":"https:\/\/www.knowband.com\/blog\/ecommerce-blog\/how-to-migrate-from-mysql-database-to-mssql-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.knowband.com\/blog\/ecommerce-blog\/how-to-migrate-from-mysql-database-to-mssql-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.knowband.com\/blog\/ecommerce-blog\/how-to-migrate-from-mysql-database-to-mssql-database\/#primaryimage","url":"https:\/\/www.knowband.com\/blog\/wp-content\/uploads\/2016\/09\/How-to-get-your-MySQL-data-converted-into-Microsoft-SQL-Server.jpg","contentUrl":"https:\/\/www.knowband.com\/blog\/wp-content\/uploads\/2016\/09\/How-to-get-your-MySQL-data-converted-into-Microsoft-SQL-Server.jpg","width":755,"height":333,"caption":"How to get your MySQL data converted into Microsoft SQL Server? | Knowband"},{"@type":"BreadcrumbList","@id":"https:\/\/www.knowband.com\/blog\/ecommerce-blog\/how-to-migrate-from-mysql-database-to-mssql-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.knowband.com\/blog\/fr\/"},{"@type":"ListItem","position":2,"name":"How to migrate from MySQL Database to MSSQL Database?"}]},{"@type":"WebSite","@id":"https:\/\/www.knowband.com\/blog\/fr\/#website","url":"https:\/\/www.knowband.com\/blog\/fr\/","name":"Knowband Blog | Ecommerce Modules","description":"Magento, Prestashop, Opencart, Shopify","publisher":{"@id":"https:\/\/www.knowband.com\/blog\/fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.knowband.com\/blog\/fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.knowband.com\/blog\/fr\/#organization","name":"Knowband Blog | Ecommerce Modules","url":"https:\/\/www.knowband.com\/blog\/fr\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.knowband.com\/blog\/fr\/#\/schema\/logo\/image\/","url":"https:\/\/www.knowband.com\/blog\/wp-content\/uploads\/2016\/09\/cropped-knowband_logo-v2.png","contentUrl":"https:\/\/www.knowband.com\/blog\/wp-content\/uploads\/2016\/09\/cropped-knowband_logo-v2.png","width":153,"height":61,"caption":"Knowband Blog | Ecommerce Modules"},"image":{"@id":"https:\/\/www.knowband.com\/blog\/fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/Knowband","https:\/\/x.com\/KnowbandPlugin"]},{"@type":"Person","@id":"https:\/\/www.knowband.com\/blog\/fr\/#\/schema\/person\/3d766b60ef5a1c9338ff341a544f27a8","name":"Joe Parker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.knowband.com\/blog\/wp-content\/plugins\/wp-user-avatar\/deprecated\/wp-user-avatar\/images\/wpua-96x96.png","url":"https:\/\/www.knowband.com\/blog\/wp-content\/plugins\/wp-user-avatar\/deprecated\/wp-user-avatar\/images\/wpua-96x96.png","contentUrl":"https:\/\/www.knowband.com\/blog\/wp-content\/plugins\/wp-user-avatar\/deprecated\/wp-user-avatar\/images\/wpua-96x96.png","caption":"Joe Parker"},"description":"We boast of the best in the industry plugins for eCommerce systems and has years of experience working with eCommerce websites. We provide best plugins for platforms like - Magento, Prestashop, OpenCart and Shopify . We also provide custom module development and customization services for the website and modules..","url":"https:\/\/www.knowband.com\/blog\/author\/joe\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.knowband.com\/blog\/wp-json\/wp\/v2\/posts\/763","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.knowband.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.knowband.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.knowband.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.knowband.com\/blog\/wp-json\/wp\/v2\/comments?post=763"}],"version-history":[{"count":13,"href":"https:\/\/www.knowband.com\/blog\/wp-json\/wp\/v2\/posts\/763\/revisions"}],"predecessor-version":[{"id":22413,"href":"https:\/\/www.knowband.com\/blog\/wp-json\/wp\/v2\/posts\/763\/revisions\/22413"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.knowband.com\/blog\/wp-json\/wp\/v2\/media\/775"}],"wp:attachment":[{"href":"https:\/\/www.knowband.com\/blog\/wp-json\/wp\/v2\/media?parent=763"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.knowband.com\/blog\/wp-json\/wp\/v2\/categories?post=763"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.knowband.com\/blog\/wp-json\/wp\/v2\/tags?post=763"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}