{"id":587,"date":"2020-09-15T12:30:45","date_gmt":"2020-09-15T12:30:45","guid":{"rendered":"https:\/\/www.arysontechnologies.com\/how-to\/?p=587"},"modified":"2026-07-07T09:49:23","modified_gmt":"2026-07-07T09:49:23","slug":"migrate-database-from-mysql-into-ms-sql-server","status":"publish","type":"post","link":"https:\/\/www.arysontechnologies.com\/how-to\/migrate-database-from-mysql-into-ms-sql-server\/","title":{"rendered":"How to Migrate Database from MySQL to SQL Server"},"content":{"rendered":"<p>MySQL and Microsoft SQL as we know, are the most commonly used Relational Database Management Systems (RDBMSs). While MySQL is an independent and open-source RDBMS supported by Oracle whereas MS SQL is a proprietary RDBMS of Microsoft.<\/p>\r\n<p>If you want to migrate MySQL to SQL Server, then you&#8217;ve come to the right place. Through this piece of article, I will describe how to migrate data from MySQL to SQL Server quickly. Some easy solutions will be described to help you complete complex database migration tasks and save a lot of time. So, without wasting any more time, let&#8217;s start!<\/p>\r\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_83 counter-hierarchy ez-toc-counter ez-toc-light-blue ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title ez-toc-toggle\" style=\"cursor:pointer\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 eztoc-toggle-hide-by-default' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.arysontechnologies.com\/how-to\/migrate-database-from-mysql-into-ms-sql-server\/#Why_Migrate_MySQL_Database_to_SQL_Server\" >Why Migrate MySQL Database to SQL Server?<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.arysontechnologies.com\/how-to\/migrate-database-from-mysql-into-ms-sql-server\/#Migrate_Using_SQL_Server_Import_Export_Wizard\" >Migrate Using SQL Server Import &amp; Export Wizard<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.arysontechnologies.com\/how-to\/migrate-database-from-mysql-into-ms-sql-server\/#Migrate_MySQL_Database_to_SQL_Server_Using_Professional_Tool\" >Migrate MySQL Database to SQL Server Using Professional Tool<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.arysontechnologies.com\/how-to\/migrate-database-from-mysql-into-ms-sql-server\/#Bottom_Lines\" >Bottom Lines<\/a><\/li><\/ul><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"main_heading\"><span class=\"ez-toc-section\" id=\"Why_Migrate_MySQL_Database_to_SQL_Server\"><\/span>Why Migrate MySQL Database to SQL Server?<span class=\"ez-toc-section-end\"><\/span><\/h2>\r\n<p>There may be a time when your MySQL database solution evolves into a mission-critical solution. Suddenly service level agreements become an issue for areas such as security, high availability, disaster recovery, scalability, data governance.<\/p>\r\n<p>Migration from MySQL to SQL database is gaining momentum nowadays. Microsoft SQL Server empowers your entire data asset by supporting structured and unstructured data sources. Additionally, SQL Server has also been the least vulnerable database in a couple of years.<\/p>\r\n<h3 class=\"main_heading\"><span class=\"ez-toc-section\" id=\"Migrate_Using_SQL_Server_Import_Export_Wizard\"><\/span>Migrate Using SQL Server Import &amp; Export Wizard<span class=\"ez-toc-section-end\"><\/span><\/h3>\r\n\r\n<div class=\"schema-how-to wp-block-yoast-how-to-block\">\r\n<p class=\"schema-how-to-description\">Migrate Database from MySQL to MSSQL Server using SQL Import &amp; Export Methods<\/p>\r\n<ol class=\"schema-how-to-steps\">\r\n<li id=\"how-to-step-1668429366441\" class=\"schema-how-to-step\"><strong class=\"schema-how-to-step-name\">Download and Install MySQL ODBC Connector<\/strong>\r\n<p class=\"schema-how-to-step-text\">First of all, download and install the MySQL ODBC Connector. The newest release is available at http:\/\/dev.mysql.com\/downloads\/connector\/odbc\/<\/p>\r\n<\/li>\r\n<li id=\"how-to-step-1668429436252\" class=\"schema-how-to-step\"><strong class=\"schema-how-to-step-name\">Open ODBC Data Source Administrator &amp; browse the MySQL ODBC driver<\/strong>\r\n<p class=\"schema-how-to-step-text\">Then, open your ODBC Data Source Administrator from the control panel &gt;&gt; Administrative Tools. On the System DSN tab click Add, browse the &#8216;MySQL ODBC driver&#8217; and press Finish button.<\/p>\r\n<\/li>\r\n<li id=\"how-to-step-1668429524927\" class=\"schema-how-to-step\"><strong class=\"schema-how-to-step-name\">Enter MySQL server connection details<\/strong>\r\n<p class=\"schema-how-to-step-text\">In the next wizard, input your MySQL server connection details, test it and click OK.<\/p>\r\n<\/li>\r\n<li id=\"how-to-step-1668429556259\" class=\"schema-how-to-step\"><strong class=\"schema-how-to-step-name\">Set SQL_MODE<\/strong>\r\n<p class=\"schema-how-to-step-text\">Now, set SQL_MODE to ANSI_QUOTES on MySQL Server.<\/p>\r\n<\/li>\r\n<li id=\"how-to-step-1668429582733\" class=\"schema-how-to-step\"><strong class=\"schema-how-to-step-name\">Launch the SQL Server Management Studio<\/strong>\r\n<p class=\"schema-how-to-step-text\">After that, launch the SQL Server Management Studio.<\/p>\r\n<\/li>\r\n<li id=\"how-to-step-1668429605140\" class=\"schema-how-to-step\"><strong class=\"schema-how-to-step-name\">Create a new database<\/strong>\r\n<p class=\"schema-how-to-step-text\">Click Next, create a new database or use an existing database<\/p>\r\n<\/li>\r\n<li id=\"how-to-step-1668429633363\" class=\"schema-how-to-step\"><strong class=\"schema-how-to-step-name\">Click Import Data to launch the SQL Server Import and Export Wizard<\/strong>\r\n<p class=\"schema-how-to-step-text\">Right-click on the destination database and select Tasks then click Import Data to launch the SQL Server Import and Export Wizard.<\/p>\r\n<\/li>\r\n<li id=\"how-to-step-1668429670575\" class=\"schema-how-to-step\"><strong class=\"schema-how-to-step-name\">Choose the .NET Data Provider for ODBC<\/strong>\r\n<p class=\"schema-how-to-step-text\">Choose the .NET Data Provider for ODBC as Data Source and specify the DSN created previously.<\/p>\r\n<\/li>\r\n<li id=\"how-to-step-1668429688851\" class=\"schema-how-to-step\"><strong class=\"schema-how-to-step-name\">Enter the details of your SQL Server database<\/strong>\r\n<p class=\"schema-how-to-step-text\">Then you have to choose the SQL Server Native Client 10 as Destination, enter the details of your SQL Server database and click Next.<\/p>\r\n<\/li>\r\n<li id=\"how-to-step-1668429719112\" class=\"schema-how-to-step\"><strong class=\"schema-how-to-step-name\">Copy data from one or more tables<\/strong>\r\n<p class=\"schema-how-to-step-text\">Select Copy data from one or more tables or views and click Next.<\/p>\r\n<\/li>\r\n<li id=\"how-to-step-1668429746857\" class=\"schema-how-to-step\"><strong class=\"schema-how-to-step-name\">Choose the source and destination tables<\/strong>\r\n<p class=\"schema-how-to-step-text\">Choose the source and destination tables. You can enable identity insert using the Edit Mappings option.<\/p>\r\n<\/li>\r\n<li id=\"how-to-step-1668429769498\" class=\"schema-how-to-step\"><strong class=\"schema-how-to-step-name\">Execute the package<\/strong>\r\n<p class=\"schema-how-to-step-text\">Finally, execute the package and save it for future use if necessary.<\/p>\r\n<\/li>\r\n<\/ol>\r\n<\/div>\r\n\r\n<h4 class=\"main_heading\"><span class=\"ez-toc-section\" id=\"Migrate_MySQL_Database_to_SQL_Server_Using_Professional_Tool\"><\/span>Migrate MySQL Database to SQL Server Using Professional Tool<span class=\"ez-toc-section-end\"><\/span><\/h4>\r\n<p>If the above method fails to do the migration then one of the best approaches is to do the automatic conversion of MySQL to MS SQL databases using specialized database converter tools such as <a href=\"https:\/\/www.arysontechnologies.com\/mysql-to-mssql\/\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>Aryson<\/strong> <strong>MySQL to SQL Converter<\/strong><\/a> Tool.<\/p>\r\n<p>The software supports database migration by allowing offline conversion of database records and attributes in an easy and hassle-free manner. In addition, the software quickly migrates your MySQL tables with indexes and keys from one database to another within the same MySQL server while preserving the integrity of the database. Moreover, the tool also comes with an option to merge MySQL data into an existing MySQL database. Essentially, the converter tool helps administrators and users save time and efforts in writing complex queries to transfer MySQL database files to MSSQL database file format. So, I would recommend you to try the free demo version of this utility to get the flair idea about database conversions.<\/p>\r\n<h4 class=\"main_heading\"><span class=\"ez-toc-section\" id=\"Bottom_Lines\"><\/span>Bottom Lines<span class=\"ez-toc-section-end\"><\/span><\/h4>\r\n<p>Organizations can develop the need to migrate from MySQL servers to Microsoft SQL due to various limitations related to their scalability, performance, and security. While migration from one database to another can be done manually, it can be a too time-consuming and error-prone process.<\/p>\r\n<p>A better option is to use specialized database converter software such as <strong>MySQL to MSSQL Converter<\/strong>, specifically designed to help DBAs and developers automate the process of converting database file format into another. The software also <a href=\"https:\/\/www.arysontechnologies.com\/how-to\/copy-mysql-table-from-one-database-to-another\/\" target=\"_blank\" rel=\"noreferrer noopener\">copy a table from one database to another database in MySQL<\/a>.<\/p>\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-left kksr-valign-bottom\"\n    data-payload='{&quot;align&quot;:&quot;left&quot;,&quot;id&quot;:&quot;587&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;bottom&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;4&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;5&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;5\\\/5 - (4 votes)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;How to Migrate Database from MySQL to SQL Server&quot;,&quot;width&quot;:&quot;142.5&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 142.5px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            5\/5 - (4 votes)    <\/div>\n    <\/div>\n","protected":false},"excerpt":{"rendered":"<p>MySQL and Microsoft SQL as we know, are the most commonly used Relational Database Management Systems (RDBMSs). While MySQL is<a class=\"read-more ml-1 main-read-more\" href=\"https:\/\/www.arysontechnologies.com\/how-to\/migrate-database-from-mysql-into-ms-sql-server\/\">Read More<\/a><\/p>\n","protected":false},"author":6,"featured_media":594,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-587","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql-server"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Migrate Database from MySQL to Microsoft SQL Server<\/title>\n<meta name=\"description\" content=\"A direct ways to migrate database table from MySQL Server to MS SQL Server database is MySQL to MSSQL Migration Tool.\" \/>\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.arysontechnologies.com\/how-to\/migrate-database-from-mysql-into-ms-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Migrate Database from MySQL to Microsoft SQL Server\" \/>\n<meta property=\"og:description\" content=\"A direct ways to migrate database table from MySQL Server to MS SQL Server database is MySQL to MSSQL Migration Tool.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.arysontechnologies.com\/how-to\/migrate-database-from-mysql-into-ms-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"How to\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/arysontech\/\" \/>\n<meta property=\"article:published_time\" content=\"2020-09-15T12:30:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-07-07T09:49:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.arysontechnologies.com\/how-to\/wp-content\/uploads\/2020\/09\/how-to-migrate-database-from-mysql-to-sql-server.png\" \/>\n\t<meta property=\"og:image:width\" content=\"698\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Harshita Sachdeva\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@Arysontec\" \/>\n<meta name=\"twitter:site\" content=\"@Arysontec\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Harshita Sachdeva\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.arysontechnologies.com\\\/how-to\\\/migrate-database-from-mysql-into-ms-sql-server\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.arysontechnologies.com\\\/how-to\\\/migrate-database-from-mysql-into-ms-sql-server\\\/\"},\"author\":{\"name\":\"Harshita Sachdeva\",\"@id\":\"https:\\\/\\\/www.arysontechnologies.com\\\/how-to\\\/#\\\/schema\\\/person\\\/86a4b57963281c6f8e85b733ba681d41\"},\"headline\":\"How to Migrate Database from MySQL to SQL Server\",\"datePublished\":\"2020-09-15T12:30:45+00:00\",\"dateModified\":\"2026-07-07T09:49:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.arysontechnologies.com\\\/how-to\\\/migrate-database-from-mysql-into-ms-sql-server\\\/\"},\"wordCount\":746,\"publisher\":{\"@id\":\"https:\\\/\\\/www.arysontechnologies.com\\\/how-to\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.arysontechnologies.com\\\/how-to\\\/migrate-database-from-mysql-into-ms-sql-server\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.arysontechnologies.com\\\/how-to\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/how-to-migrate-database-from-mysql-to-sql-server.png\",\"articleSection\":[\"SQL Server\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.arysontechnologies.com\\\/how-to\\\/migrate-database-from-mysql-into-ms-sql-server\\\/\",\"url\":\"https:\\\/\\\/www.arysontechnologies.com\\\/how-to\\\/migrate-database-from-mysql-into-ms-sql-server\\\/\",\"name\":\"How to Migrate Database from MySQL to Microsoft SQL Server\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.arysontechnologies.com\\\/how-to\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.arysontechnologies.com\\\/how-to\\\/migrate-database-from-mysql-into-ms-sql-server\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.arysontechnologies.com\\\/how-to\\\/migrate-database-from-mysql-into-ms-sql-server\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.arysontechnologies.com\\\/how-to\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/how-to-migrate-database-from-mysql-to-sql-server.png\",\"datePublished\":\"2020-09-15T12:30:45+00:00\",\"dateModified\":\"2026-07-07T09:49:23+00:00\",\"description\":\"A direct ways to migrate database table from MySQL Server to MS SQL Server database is MySQL to MSSQL Migration Tool.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.arysontechnologies.com\\\/how-to\\\/migrate-database-from-mysql-into-ms-sql-server\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.arysontechnologies.com\\\/how-to\\\/migrate-database-from-mysql-into-ms-sql-server\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.arysontechnologies.com\\\/how-to\\\/migrate-database-from-mysql-into-ms-sql-server\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.arysontechnologies.com\\\/how-to\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/how-to-migrate-database-from-mysql-to-sql-server.png\",\"contentUrl\":\"https:\\\/\\\/www.arysontechnologies.com\\\/how-to\\\/wp-content\\\/uploads\\\/2020\\\/09\\\/how-to-migrate-database-from-mysql-to-sql-server.png\",\"width\":698,\"height\":400},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.arysontechnologies.com\\\/how-to\\\/migrate-database-from-mysql-into-ms-sql-server\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.arysontechnologies.com\\\/how-to\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Migrate Database from MySQL to SQL Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.arysontechnologies.com\\\/how-to\\\/#website\",\"url\":\"https:\\\/\\\/www.arysontechnologies.com\\\/how-to\\\/\",\"name\":\"How to\",\"description\":\"Aryson Technologies\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.arysontechnologies.com\\\/how-to\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.arysontechnologies.com\\\/how-to\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.arysontechnologies.com\\\/how-to\\\/#organization\",\"name\":\"Aryson Technologies\",\"url\":\"https:\\\/\\\/www.arysontechnologies.com\\\/how-to\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.arysontechnologies.com\\\/how-to\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.arysontechnologies.com\\\/how-to\\\/wp-content\\\/uploads\\\/2025\\\/07\\\/cropped-arysonlogo-1.png\",\"contentUrl\":\"https:\\\/\\\/www.arysontechnologies.com\\\/how-to\\\/wp-content\\\/uploads\\\/2025\\\/07\\\/cropped-arysonlogo-1.png\",\"width\":247,\"height\":60,\"caption\":\"Aryson Technologies\"},\"image\":{\"@id\":\"https:\\\/\\\/www.arysontechnologies.com\\\/how-to\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/arysontech\\\/\",\"https:\\\/\\\/x.com\\\/Arysontec\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/arysontechnologies\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.arysontechnologies.com\\\/how-to\\\/#\\\/schema\\\/person\\\/86a4b57963281c6f8e85b733ba681d41\",\"name\":\"Harshita Sachdeva\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5220782b762f40b2ef26a3237a585a93f7394ddcf35ec95a6c207db7d2b8ac1b?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5220782b762f40b2ef26a3237a585a93f7394ddcf35ec95a6c207db7d2b8ac1b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5220782b762f40b2ef26a3237a585a93f7394ddcf35ec95a6c207db7d2b8ac1b?s=96&d=mm&r=g\",\"caption\":\"Harshita Sachdeva\"},\"description\":\"Harshita Sachdeva, a professional technical writer at Aryson Technologies, specialize in delivering clear, hands-on documentation for data management, migration, and recovery solutions. With a meticulous, reader-first approach, I break down complex technical processes into simple, actionable content - helping IT professionals and decision-makers tackle challenges efficiently.\",\"sameAs\":[\"https:\\\/\\\/in.linkedin.com\\\/in\\\/harshita-sachdeva-028156292\"],\"url\":\"https:\\\/\\\/www.arysontechnologies.com\\\/how-to\\\/author\\\/harshita-sachdeva\\\/\"},{\"@type\":\"HowTo\",\"@id\":\"https:\\\/\\\/www.arysontechnologies.com\\\/how-to\\\/migrate-database-from-mysql-into-ms-sql-server\\\/#howto-1\",\"name\":\"How to Migrate Database from MySQL to SQL Server\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.arysontechnologies.com\\\/how-to\\\/migrate-database-from-mysql-into-ms-sql-server\\\/#article\"},\"description\":\"Migrate Database from MySQL to MSSQL Server using SQL Import &amp; Export Methods\",\"step\":[{\"@type\":\"HowToStep\",\"url\":\"https:\\\/\\\/www.arysontechnologies.com\\\/how-to\\\/migrate-database-from-mysql-into-ms-sql-server\\\/#how-to-step-1668429366441\",\"name\":\"Download and Install MySQL ODBC Connector\",\"itemListElement\":[{\"@type\":\"HowToDirection\",\"text\":\"First of all, download and install the MySQL ODBC Connector. The newest release is available at http:\\\/\\\/dev.mysql.com\\\/downloads\\\/connector\\\/odbc\\\/\"}]},{\"@type\":\"HowToStep\",\"url\":\"https:\\\/\\\/www.arysontechnologies.com\\\/how-to\\\/migrate-database-from-mysql-into-ms-sql-server\\\/#how-to-step-1668429436252\",\"name\":\"Open ODBC Data Source Administrator &amp; browse the MySQL ODBC driver\",\"itemListElement\":[{\"@type\":\"HowToDirection\",\"text\":\"Then, open your ODBC Data Source Administrator from the control panel >> Administrative Tools. On the System DSN tab click Add, browse the 'MySQL ODBC driver' and press Finish button.\"}]},{\"@type\":\"HowToStep\",\"url\":\"https:\\\/\\\/www.arysontechnologies.com\\\/how-to\\\/migrate-database-from-mysql-into-ms-sql-server\\\/#how-to-step-1668429524927\",\"name\":\"Enter MySQL server connection details\",\"itemListElement\":[{\"@type\":\"HowToDirection\",\"text\":\"In the next wizard, input your MySQL server connection details, test it and click OK.\"}]},{\"@type\":\"HowToStep\",\"url\":\"https:\\\/\\\/www.arysontechnologies.com\\\/how-to\\\/migrate-database-from-mysql-into-ms-sql-server\\\/#how-to-step-1668429556259\",\"name\":\"Set SQL_MODE\",\"itemListElement\":[{\"@type\":\"HowToDirection\",\"text\":\"Now, set SQL_MODE to ANSI_QUOTES on MySQL Server.\"}]},{\"@type\":\"HowToStep\",\"url\":\"https:\\\/\\\/www.arysontechnologies.com\\\/how-to\\\/migrate-database-from-mysql-into-ms-sql-server\\\/#how-to-step-1668429582733\",\"name\":\"Launch the SQL Server Management Studio\",\"itemListElement\":[{\"@type\":\"HowToDirection\",\"text\":\"After that, launch the SQL Server Management Studio.\"}]},{\"@type\":\"HowToStep\",\"url\":\"https:\\\/\\\/www.arysontechnologies.com\\\/how-to\\\/migrate-database-from-mysql-into-ms-sql-server\\\/#how-to-step-1668429605140\",\"name\":\"Create a new database\",\"itemListElement\":[{\"@type\":\"HowToDirection\",\"text\":\"Click Next, create a new database or use an existing database\"}]},{\"@type\":\"HowToStep\",\"url\":\"https:\\\/\\\/www.arysontechnologies.com\\\/how-to\\\/migrate-database-from-mysql-into-ms-sql-server\\\/#how-to-step-1668429633363\",\"name\":\"Click Import Data to launch the SQL Server Import and Export Wizard\",\"itemListElement\":[{\"@type\":\"HowToDirection\",\"text\":\"Right-click on the destination database and select Tasks then click Import Data to launch the SQL Server Import and Export Wizard.\"}]},{\"@type\":\"HowToStep\",\"url\":\"https:\\\/\\\/www.arysontechnologies.com\\\/how-to\\\/migrate-database-from-mysql-into-ms-sql-server\\\/#how-to-step-1668429670575\",\"name\":\"Choose the .NET Data Provider for ODBC\",\"itemListElement\":[{\"@type\":\"HowToDirection\",\"text\":\"Choose the .NET Data Provider for ODBC as Data Source and specify the DSN created previously.\"}]},{\"@type\":\"HowToStep\",\"url\":\"https:\\\/\\\/www.arysontechnologies.com\\\/how-to\\\/migrate-database-from-mysql-into-ms-sql-server\\\/#how-to-step-1668429688851\",\"name\":\"Enter the details of your SQL Server database\",\"itemListElement\":[{\"@type\":\"HowToDirection\",\"text\":\"Then you have to choose the SQL Server Native Client 10 as Destination, enter the details of your SQL Server database and click Next.\"}]},{\"@type\":\"HowToStep\",\"url\":\"https:\\\/\\\/www.arysontechnologies.com\\\/how-to\\\/migrate-database-from-mysql-into-ms-sql-server\\\/#how-to-step-1668429719112\",\"name\":\"Copy data from one or more tables\",\"itemListElement\":[{\"@type\":\"HowToDirection\",\"text\":\"Select Copy data from one or more tables or views and click Next.\"}]},{\"@type\":\"HowToStep\",\"url\":\"https:\\\/\\\/www.arysontechnologies.com\\\/how-to\\\/migrate-database-from-mysql-into-ms-sql-server\\\/#how-to-step-1668429746857\",\"name\":\"Choose the source and destination tables\",\"itemListElement\":[{\"@type\":\"HowToDirection\",\"text\":\"Choose the source and destination tables. You can enable identity insert using the Edit Mappings option.\"}]},{\"@type\":\"HowToStep\",\"url\":\"https:\\\/\\\/www.arysontechnologies.com\\\/how-to\\\/migrate-database-from-mysql-into-ms-sql-server\\\/#how-to-step-1668429769498\",\"name\":\"Execute the package\",\"itemListElement\":[{\"@type\":\"HowToDirection\",\"text\":\"Finally, execute the package and save it for future use if necessary.\"}]}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Migrate Database from MySQL to Microsoft SQL Server","description":"A direct ways to migrate database table from MySQL Server to MS SQL Server database is MySQL to MSSQL Migration Tool.","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.arysontechnologies.com\/how-to\/migrate-database-from-mysql-into-ms-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"How to Migrate Database from MySQL to Microsoft SQL Server","og_description":"A direct ways to migrate database table from MySQL Server to MS SQL Server database is MySQL to MSSQL Migration Tool.","og_url":"https:\/\/www.arysontechnologies.com\/how-to\/migrate-database-from-mysql-into-ms-sql-server\/","og_site_name":"How to","article_publisher":"https:\/\/www.facebook.com\/arysontech\/","article_published_time":"2020-09-15T12:30:45+00:00","article_modified_time":"2026-07-07T09:49:23+00:00","og_image":[{"width":698,"height":400,"url":"https:\/\/www.arysontechnologies.com\/how-to\/wp-content\/uploads\/2020\/09\/how-to-migrate-database-from-mysql-to-sql-server.png","type":"image\/png"}],"author":"Harshita Sachdeva","twitter_card":"summary_large_image","twitter_creator":"@Arysontec","twitter_site":"@Arysontec","twitter_misc":{"Written by":"Harshita Sachdeva","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.arysontechnologies.com\/how-to\/migrate-database-from-mysql-into-ms-sql-server\/#article","isPartOf":{"@id":"https:\/\/www.arysontechnologies.com\/how-to\/migrate-database-from-mysql-into-ms-sql-server\/"},"author":{"name":"Harshita Sachdeva","@id":"https:\/\/www.arysontechnologies.com\/how-to\/#\/schema\/person\/86a4b57963281c6f8e85b733ba681d41"},"headline":"How to Migrate Database from MySQL to SQL Server","datePublished":"2020-09-15T12:30:45+00:00","dateModified":"2026-07-07T09:49:23+00:00","mainEntityOfPage":{"@id":"https:\/\/www.arysontechnologies.com\/how-to\/migrate-database-from-mysql-into-ms-sql-server\/"},"wordCount":746,"publisher":{"@id":"https:\/\/www.arysontechnologies.com\/how-to\/#organization"},"image":{"@id":"https:\/\/www.arysontechnologies.com\/how-to\/migrate-database-from-mysql-into-ms-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/www.arysontechnologies.com\/how-to\/wp-content\/uploads\/2020\/09\/how-to-migrate-database-from-mysql-to-sql-server.png","articleSection":["SQL Server"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.arysontechnologies.com\/how-to\/migrate-database-from-mysql-into-ms-sql-server\/","url":"https:\/\/www.arysontechnologies.com\/how-to\/migrate-database-from-mysql-into-ms-sql-server\/","name":"How to Migrate Database from MySQL to Microsoft SQL Server","isPartOf":{"@id":"https:\/\/www.arysontechnologies.com\/how-to\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.arysontechnologies.com\/how-to\/migrate-database-from-mysql-into-ms-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/www.arysontechnologies.com\/how-to\/migrate-database-from-mysql-into-ms-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/www.arysontechnologies.com\/how-to\/wp-content\/uploads\/2020\/09\/how-to-migrate-database-from-mysql-to-sql-server.png","datePublished":"2020-09-15T12:30:45+00:00","dateModified":"2026-07-07T09:49:23+00:00","description":"A direct ways to migrate database table from MySQL Server to MS SQL Server database is MySQL to MSSQL Migration Tool.","breadcrumb":{"@id":"https:\/\/www.arysontechnologies.com\/how-to\/migrate-database-from-mysql-into-ms-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.arysontechnologies.com\/how-to\/migrate-database-from-mysql-into-ms-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.arysontechnologies.com\/how-to\/migrate-database-from-mysql-into-ms-sql-server\/#primaryimage","url":"https:\/\/www.arysontechnologies.com\/how-to\/wp-content\/uploads\/2020\/09\/how-to-migrate-database-from-mysql-to-sql-server.png","contentUrl":"https:\/\/www.arysontechnologies.com\/how-to\/wp-content\/uploads\/2020\/09\/how-to-migrate-database-from-mysql-to-sql-server.png","width":698,"height":400},{"@type":"BreadcrumbList","@id":"https:\/\/www.arysontechnologies.com\/how-to\/migrate-database-from-mysql-into-ms-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.arysontechnologies.com\/how-to\/"},{"@type":"ListItem","position":2,"name":"How to Migrate Database from MySQL to SQL Server"}]},{"@type":"WebSite","@id":"https:\/\/www.arysontechnologies.com\/how-to\/#website","url":"https:\/\/www.arysontechnologies.com\/how-to\/","name":"How to","description":"Aryson Technologies","publisher":{"@id":"https:\/\/www.arysontechnologies.com\/how-to\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.arysontechnologies.com\/how-to\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.arysontechnologies.com\/how-to\/#organization","name":"Aryson Technologies","url":"https:\/\/www.arysontechnologies.com\/how-to\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.arysontechnologies.com\/how-to\/#\/schema\/logo\/image\/","url":"https:\/\/www.arysontechnologies.com\/how-to\/wp-content\/uploads\/2025\/07\/cropped-arysonlogo-1.png","contentUrl":"https:\/\/www.arysontechnologies.com\/how-to\/wp-content\/uploads\/2025\/07\/cropped-arysonlogo-1.png","width":247,"height":60,"caption":"Aryson Technologies"},"image":{"@id":"https:\/\/www.arysontechnologies.com\/how-to\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/arysontech\/","https:\/\/x.com\/Arysontec","https:\/\/www.linkedin.com\/company\/arysontechnologies\/"]},{"@type":"Person","@id":"https:\/\/www.arysontechnologies.com\/how-to\/#\/schema\/person\/86a4b57963281c6f8e85b733ba681d41","name":"Harshita Sachdeva","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/5220782b762f40b2ef26a3237a585a93f7394ddcf35ec95a6c207db7d2b8ac1b?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/5220782b762f40b2ef26a3237a585a93f7394ddcf35ec95a6c207db7d2b8ac1b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5220782b762f40b2ef26a3237a585a93f7394ddcf35ec95a6c207db7d2b8ac1b?s=96&d=mm&r=g","caption":"Harshita Sachdeva"},"description":"Harshita Sachdeva, a professional technical writer at Aryson Technologies, specialize in delivering clear, hands-on documentation for data management, migration, and recovery solutions. With a meticulous, reader-first approach, I break down complex technical processes into simple, actionable content - helping IT professionals and decision-makers tackle challenges efficiently.","sameAs":["https:\/\/in.linkedin.com\/in\/harshita-sachdeva-028156292"],"url":"https:\/\/www.arysontechnologies.com\/how-to\/author\/harshita-sachdeva\/"},{"@type":"HowTo","@id":"https:\/\/www.arysontechnologies.com\/how-to\/migrate-database-from-mysql-into-ms-sql-server\/#howto-1","name":"How to Migrate Database from MySQL to SQL Server","mainEntityOfPage":{"@id":"https:\/\/www.arysontechnologies.com\/how-to\/migrate-database-from-mysql-into-ms-sql-server\/#article"},"description":"Migrate Database from MySQL to MSSQL Server using SQL Import &amp; Export Methods","step":[{"@type":"HowToStep","url":"https:\/\/www.arysontechnologies.com\/how-to\/migrate-database-from-mysql-into-ms-sql-server\/#how-to-step-1668429366441","name":"Download and Install MySQL ODBC Connector","itemListElement":[{"@type":"HowToDirection","text":"First of all, download and install the MySQL ODBC Connector. The newest release is available at http:\/\/dev.mysql.com\/downloads\/connector\/odbc\/"}]},{"@type":"HowToStep","url":"https:\/\/www.arysontechnologies.com\/how-to\/migrate-database-from-mysql-into-ms-sql-server\/#how-to-step-1668429436252","name":"Open ODBC Data Source Administrator &amp; browse the MySQL ODBC driver","itemListElement":[{"@type":"HowToDirection","text":"Then, open your ODBC Data Source Administrator from the control panel >> Administrative Tools. On the System DSN tab click Add, browse the 'MySQL ODBC driver' and press Finish button."}]},{"@type":"HowToStep","url":"https:\/\/www.arysontechnologies.com\/how-to\/migrate-database-from-mysql-into-ms-sql-server\/#how-to-step-1668429524927","name":"Enter MySQL server connection details","itemListElement":[{"@type":"HowToDirection","text":"In the next wizard, input your MySQL server connection details, test it and click OK."}]},{"@type":"HowToStep","url":"https:\/\/www.arysontechnologies.com\/how-to\/migrate-database-from-mysql-into-ms-sql-server\/#how-to-step-1668429556259","name":"Set SQL_MODE","itemListElement":[{"@type":"HowToDirection","text":"Now, set SQL_MODE to ANSI_QUOTES on MySQL Server."}]},{"@type":"HowToStep","url":"https:\/\/www.arysontechnologies.com\/how-to\/migrate-database-from-mysql-into-ms-sql-server\/#how-to-step-1668429582733","name":"Launch the SQL Server Management Studio","itemListElement":[{"@type":"HowToDirection","text":"After that, launch the SQL Server Management Studio."}]},{"@type":"HowToStep","url":"https:\/\/www.arysontechnologies.com\/how-to\/migrate-database-from-mysql-into-ms-sql-server\/#how-to-step-1668429605140","name":"Create a new database","itemListElement":[{"@type":"HowToDirection","text":"Click Next, create a new database or use an existing database"}]},{"@type":"HowToStep","url":"https:\/\/www.arysontechnologies.com\/how-to\/migrate-database-from-mysql-into-ms-sql-server\/#how-to-step-1668429633363","name":"Click Import Data to launch the SQL Server Import and Export Wizard","itemListElement":[{"@type":"HowToDirection","text":"Right-click on the destination database and select Tasks then click Import Data to launch the SQL Server Import and Export Wizard."}]},{"@type":"HowToStep","url":"https:\/\/www.arysontechnologies.com\/how-to\/migrate-database-from-mysql-into-ms-sql-server\/#how-to-step-1668429670575","name":"Choose the .NET Data Provider for ODBC","itemListElement":[{"@type":"HowToDirection","text":"Choose the .NET Data Provider for ODBC as Data Source and specify the DSN created previously."}]},{"@type":"HowToStep","url":"https:\/\/www.arysontechnologies.com\/how-to\/migrate-database-from-mysql-into-ms-sql-server\/#how-to-step-1668429688851","name":"Enter the details of your SQL Server database","itemListElement":[{"@type":"HowToDirection","text":"Then you have to choose the SQL Server Native Client 10 as Destination, enter the details of your SQL Server database and click Next."}]},{"@type":"HowToStep","url":"https:\/\/www.arysontechnologies.com\/how-to\/migrate-database-from-mysql-into-ms-sql-server\/#how-to-step-1668429719112","name":"Copy data from one or more tables","itemListElement":[{"@type":"HowToDirection","text":"Select Copy data from one or more tables or views and click Next."}]},{"@type":"HowToStep","url":"https:\/\/www.arysontechnologies.com\/how-to\/migrate-database-from-mysql-into-ms-sql-server\/#how-to-step-1668429746857","name":"Choose the source and destination tables","itemListElement":[{"@type":"HowToDirection","text":"Choose the source and destination tables. You can enable identity insert using the Edit Mappings option."}]},{"@type":"HowToStep","url":"https:\/\/www.arysontechnologies.com\/how-to\/migrate-database-from-mysql-into-ms-sql-server\/#how-to-step-1668429769498","name":"Execute the package","itemListElement":[{"@type":"HowToDirection","text":"Finally, execute the package and save it for future use if necessary."}]}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/www.arysontechnologies.com\/how-to\/wp-json\/wp\/v2\/posts\/587","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.arysontechnologies.com\/how-to\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.arysontechnologies.com\/how-to\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.arysontechnologies.com\/how-to\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.arysontechnologies.com\/how-to\/wp-json\/wp\/v2\/comments?post=587"}],"version-history":[{"count":8,"href":"https:\/\/www.arysontechnologies.com\/how-to\/wp-json\/wp\/v2\/posts\/587\/revisions"}],"predecessor-version":[{"id":3334,"href":"https:\/\/www.arysontechnologies.com\/how-to\/wp-json\/wp\/v2\/posts\/587\/revisions\/3334"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.arysontechnologies.com\/how-to\/wp-json\/wp\/v2\/media\/594"}],"wp:attachment":[{"href":"https:\/\/www.arysontechnologies.com\/how-to\/wp-json\/wp\/v2\/media?parent=587"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.arysontechnologies.com\/how-to\/wp-json\/wp\/v2\/categories?post=587"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.arysontechnologies.com\/how-to\/wp-json\/wp\/v2\/tags?post=587"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}