{"id":56665,"date":"2024-10-01T14:18:58","date_gmt":"2024-10-01T14:18:58","guid":{"rendered":"https:\/\/dbtut.com\/?p=56665"},"modified":"2024-10-01T14:22:26","modified_gmt":"2024-10-01T14:22:26","slug":"create-a-linked-server-to-mysql-from-sql-server","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2024\/10\/01\/create-a-linked-server-to-mysql-from-sql-server\/","title":{"rendered":"Create A Linked Server To MySQL From SQL Server"},"content":{"rendered":"<p>In today&#8217;s article, we will learn how to Create a Linked Server from SQL Server to MySQL.<\/p>\n<p>We can use the linked server feature to connect to multiple databases in MSSQL.<\/p>\n<p>First, we install the ODBC driver suitable for your operating system, which can be found in the link below.<\/p>\n<pre class=\"lang:default decode:true \">https:\/\/dev.mysql.com\/downloads\/connector\/odbc\/<\/pre>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/www.farukerdem.com\/wp-content\/uploads\/2019\/04\/mysqlodbcinstaller1.png\" \/><\/p>\n<p>We select the OS version (64-bit (x64) for me) and click on Download to go to the next screen.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/www.farukerdem.com\/wp-content\/uploads\/2019\/04\/mysqlodbcinstaller2.png\" \/><\/p>\n<p id=\"hCadEbG\">We download it without signing up by clicking on the yellow marked area on the next screen.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/www.farukerdem.com\/wp-content\/uploads\/2019\/04\/mysqlodbcinstaller3.png\" \/><\/p>\n<p id=\"AziyHJm\">If you receive an error like the one above while installing the file we downloaded, you can download it by clicking the link below and continue the installation.<\/p>\n<pre class=\"lang:default decode:true \">https:\/\/support.microsoft.com\/en-us\/topic\/the-latest-supported-visual-c-downloads-2647da03-1eea-4433-9aff-95f26a218cc0<\/pre>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/www.farukerdem.com\/wp-content\/uploads\/2019\/04\/mysqlodbcinstaller4.png\" \/><\/p>\n<p id=\"Qcxeyxs\">We continue by saying \u201cNext\u201d.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/www.farukerdem.com\/wp-content\/uploads\/2019\/04\/mysqlodbcinstaller5.png\" \/><\/p>\n<p>We continue by selecting \u201cI accept the terms in the license agreement\u201d.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/www.farukerdem.com\/wp-content\/uploads\/2019\/04\/mysqlodbcinstaller6.png\" \/><\/p>\n<p>We continue by selecting \u201cComplete\u201d.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/www.farukerdem.com\/wp-content\/uploads\/2019\/04\/mysqlodbcinstaller7-1.png\" \/><\/p>\n<p id=\"SBJTkBp\">We start the installation by saying Install.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/www.farukerdem.com\/wp-content\/uploads\/2019\/04\/mysqlodbcinstaller7.png\" \/><\/p>\n<p id=\"ybNEsvR\">After clicking Finish, our ODBC Connector that we will use for MYSQL is installed.<\/p>\n<p>After installing, we need to add it to the system dsn to use it in SQL Server. To do this, we type \u201cODBC\u201d in the search field and select \u201cODBC Data Sources (64-bit)\u201d. (If your operating system is 32-bit, you can select 32-bit)<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/www.farukerdem.com\/wp-content\/uploads\/2019\/04\/mysqlodbcinstaller8.png\" \/><\/p>\n<p id=\"OSgxrKt\">After opening the ODBC data sources, we go to the System DSN section as below and click the &#8220;Add&#8221; button.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/www.farukerdem.com\/wp-content\/uploads\/2021\/09\/systemdsn.png\" \/><\/p>\n<p id=\"YIoFdZJ\">We continue by selecting MYSQL ODBC 8.0 Unicode Driver.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/www.farukerdem.com\/wp-content\/uploads\/2019\/04\/mysqlodbcinstaller10.png\" \/><\/p>\n<p>We fill in the relevant fields in the window that opens as in the picture below.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/www.farukerdem.com\/wp-content\/uploads\/2019\/04\/mysqlodbcinstaller11.png\" \/><\/p>\n<p>DataSource: You can give the desired name, we will give the value written here later in the Linked Server Setup.<\/p>\n<p>Database: Database name on the MYSQL side<\/p>\n<p>Server: MYSQL ip<\/p>\n<p>Port: MYSQL port<\/p>\n<p>Username: MYSQL user<\/p>\n<p>Password: MYSQL password<\/p>\n<p>Description: You can leave it blank or write a description.<\/p>\n<p>After filling in the above information, we click on the \u201cTest\u201d button and verify that it has been successfully connected.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/www.farukerdem.com\/wp-content\/uploads\/2019\/04\/mysqltomssql.png\" \/><\/p>\n<p>After verification, we are finished with the \u201cODBC Data Source Manager (64-bit)\u201d window by clicking the OK buttons.<\/p>\n<p>We continue by selecting \u201cNew Linked Server\u201d on SQL.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/www.farukerdem.com\/wp-content\/uploads\/2019\/04\/mysqltomssqllinkedserver.png\" \/><\/p>\n<p id=\"bxhuebH\">After saying New Linked Server, we fill in the fields below.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/www.farukerdem.com\/wp-content\/uploads\/2019\/04\/mysqltomssqldblink.png\" \/><\/p>\n<p>We fill in the window that opens according to the information below.<\/p>\n<p>Linked Server: You can give any name.<\/p>\n<p>Provider: We select \u201cMicrosoft OLE DB Provider for ODBC Drivers\u201d.<\/p>\n<p>Product Name: We write MySQL.<\/p>\n<p>Data Source: We enter the name we wrote in the Data Source section in \u201cODBC Data Sources (64-bit)\u201d.<\/p>\n<p>We enter our postgresql username and password in the \u201cSecurity\u201d section.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/www.farukerdem.com\/wp-content\/uploads\/2021\/09\/mssql-to-mysql-linkedserver.png\" \/><\/p>\n<p id=\"OpBfvJw\">We go to the \u201cServer Options\u201d section and change the parameters as follows.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/www.farukerdem.com\/wp-content\/uploads\/2021\/09\/mssql-to-mysql-linkedserver1.png\" \/><\/p>\n<p id=\"ObokEfi\">After completing the above process, by clicking the &#8220;OK&#8221; button, our linked server definition process from MSSQL to MYSQL is completed.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/www.farukerdem.com\/wp-content\/uploads\/2021\/09\/mssqltomysqllinkedserver02.png\" \/><\/p>\n<p>As seen above, we have listed the table in the database named \u201cmysqlfrk\u201d in postgresql.<\/p>\n<p>You can query as follows.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/www.farukerdem.com\/wp-content\/uploads\/2021\/09\/mssqlto-mysql-query.png\" \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_56665\" class=\"pvc_stats all  \" data-element-id=\"56665\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>In today&#8217;s article, we will learn how to Create a Linked Server from SQL Server to MySQL. We can use the linked server feature to connect to multiple databases in MSSQL. First, we install the ODBC driver suitable for your operating system, which can be found in the link below. https:\/\/dev.mysql.com\/downloads\/connector\/odbc\/ We select the OS &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_56665\" class=\"pvc_stats all  \" data-element-id=\"56665\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":366,"featured_media":56685,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[3],"tags":[],"class_list":["post-56665","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-mssql"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Create A Linked Server To MySQL From SQL Server - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How to Create a Linked Server from SQL Server to MySQL. We can use the linked server feature to connect to multiple databases in MSSQL.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2024\/10\/01\/create-a-linked-server-to-mysql-from-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Create A Linked Server To MySQL From SQL Server - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How to Create a Linked Server from SQL Server to MySQL. We can use the linked server feature to connect to multiple databases in MSSQL.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2024\/10\/01\/create-a-linked-server-to-mysql-from-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2024-10-01T14:18:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-10-01T14:22:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/10\/Ekran-goruntusu-2024-10-01-171827.png\" \/>\n\t<meta property=\"og:image:width\" content=\"762\" \/>\n\t<meta property=\"og:image:height\" content=\"313\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Faruk Erdem\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Faruk Erdem\" \/>\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:\/\/dbtut.com\/index.php\/2024\/10\/01\/create-a-linked-server-to-mysql-from-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/10\/01\/create-a-linked-server-to-mysql-from-sql-server\/\"},\"author\":{\"name\":\"Faruk Erdem\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb\"},\"headline\":\"Create A Linked Server To MySQL From SQL Server\",\"datePublished\":\"2024-10-01T14:18:58+00:00\",\"dateModified\":\"2024-10-01T14:22:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/10\/01\/create-a-linked-server-to-mysql-from-sql-server\/\"},\"wordCount\":477,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/10\/01\/create-a-linked-server-to-mysql-from-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/10\/Ekran-goruntusu-2024-10-01-171827.png\",\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2024\/10\/01\/create-a-linked-server-to-mysql-from-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/10\/01\/create-a-linked-server-to-mysql-from-sql-server\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2024\/10\/01\/create-a-linked-server-to-mysql-from-sql-server\/\",\"name\":\"Create A Linked Server To MySQL From SQL Server - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/10\/01\/create-a-linked-server-to-mysql-from-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/10\/01\/create-a-linked-server-to-mysql-from-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/10\/Ekran-goruntusu-2024-10-01-171827.png\",\"datePublished\":\"2024-10-01T14:18:58+00:00\",\"dateModified\":\"2024-10-01T14:22:26+00:00\",\"description\":\"How to Create a Linked Server from SQL Server to MySQL. We can use the linked server feature to connect to multiple databases in MSSQL.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/10\/01\/create-a-linked-server-to-mysql-from-sql-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2024\/10\/01\/create-a-linked-server-to-mysql-from-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/10\/01\/create-a-linked-server-to-mysql-from-sql-server\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/10\/Ekran-goruntusu-2024-10-01-171827.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/10\/Ekran-goruntusu-2024-10-01-171827.png\",\"width\":762,\"height\":313},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/10\/01\/create-a-linked-server-to-mysql-from-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Create A Linked Server To MySQL From SQL Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb\",\"name\":\"Faruk Erdem\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ad1e61fb5a7c9a590e765f7cad8f2dc8332090f1ceb9a5ee2aa95c69213f0c50?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ad1e61fb5a7c9a590e765f7cad8f2dc8332090f1ceb9a5ee2aa95c69213f0c50?s=96&d=mm&r=g\",\"caption\":\"Faruk Erdem\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/farukerdem\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Create A Linked Server To MySQL From SQL Server - Database Tutorials","description":"How to Create a Linked Server from SQL Server to MySQL. We can use the linked server feature to connect to multiple databases in MSSQL.","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:\/\/dbtut.com\/index.php\/2024\/10\/01\/create-a-linked-server-to-mysql-from-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"Create A Linked Server To MySQL From SQL Server - Database Tutorials","og_description":"How to Create a Linked Server from SQL Server to MySQL. We can use the linked server feature to connect to multiple databases in MSSQL.","og_url":"https:\/\/dbtut.com\/index.php\/2024\/10\/01\/create-a-linked-server-to-mysql-from-sql-server\/","og_site_name":"Database Tutorials","article_published_time":"2024-10-01T14:18:58+00:00","article_modified_time":"2024-10-01T14:22:26+00:00","og_image":[{"width":762,"height":313,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/10\/Ekran-goruntusu-2024-10-01-171827.png","type":"image\/png"}],"author":"Faruk Erdem","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Faruk Erdem","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2024\/10\/01\/create-a-linked-server-to-mysql-from-sql-server\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/10\/01\/create-a-linked-server-to-mysql-from-sql-server\/"},"author":{"name":"Faruk Erdem","@id":"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb"},"headline":"Create A Linked Server To MySQL From SQL Server","datePublished":"2024-10-01T14:18:58+00:00","dateModified":"2024-10-01T14:22:26+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/10\/01\/create-a-linked-server-to-mysql-from-sql-server\/"},"wordCount":477,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/10\/01\/create-a-linked-server-to-mysql-from-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/10\/Ekran-goruntusu-2024-10-01-171827.png","articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2024\/10\/01\/create-a-linked-server-to-mysql-from-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2024\/10\/01\/create-a-linked-server-to-mysql-from-sql-server\/","url":"https:\/\/dbtut.com\/index.php\/2024\/10\/01\/create-a-linked-server-to-mysql-from-sql-server\/","name":"Create A Linked Server To MySQL From SQL Server - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/10\/01\/create-a-linked-server-to-mysql-from-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/10\/01\/create-a-linked-server-to-mysql-from-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/10\/Ekran-goruntusu-2024-10-01-171827.png","datePublished":"2024-10-01T14:18:58+00:00","dateModified":"2024-10-01T14:22:26+00:00","description":"How to Create a Linked Server from SQL Server to MySQL. We can use the linked server feature to connect to multiple databases in MSSQL.","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/10\/01\/create-a-linked-server-to-mysql-from-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2024\/10\/01\/create-a-linked-server-to-mysql-from-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2024\/10\/01\/create-a-linked-server-to-mysql-from-sql-server\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/10\/Ekran-goruntusu-2024-10-01-171827.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/10\/Ekran-goruntusu-2024-10-01-171827.png","width":762,"height":313},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2024\/10\/01\/create-a-linked-server-to-mysql-from-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Create A Linked Server To MySQL From SQL Server"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb","name":"Faruk Erdem","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ad1e61fb5a7c9a590e765f7cad8f2dc8332090f1ceb9a5ee2aa95c69213f0c50?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ad1e61fb5a7c9a590e765f7cad8f2dc8332090f1ceb9a5ee2aa95c69213f0c50?s=96&d=mm&r=g","caption":"Faruk Erdem"},"url":"https:\/\/dbtut.com\/index.php\/author\/farukerdem\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/56665","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/366"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=56665"}],"version-history":[{"count":4,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/56665\/revisions"}],"predecessor-version":[{"id":56689,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/56665\/revisions\/56689"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/56685"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=56665"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=56665"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=56665"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}