{"id":13249,"date":"2019-10-22T08:14:27","date_gmt":"2019-10-22T08:14:27","guid":{"rendered":"https:\/\/dbtut.com\/?p=13249"},"modified":"2019-10-23T07:00:04","modified_gmt":"2019-10-23T07:00:04","slug":"how-to-create-a-linked-server-to-connect-to-postgresql-from-sql-server","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/10\/22\/how-to-create-a-linked-server-to-connect-to-postgresql-from-sql-server\/","title":{"rendered":"How To Create a Linked Server To Connect To PostgreSQL From SQL Server"},"content":{"rendered":"<p>You may want to transfer data to MSSQL from PostgreSQL or send query to PostgreSQL from MSSQL. There are different methods to perform this. One of method is linked server.<\/p>\n<p>First, to create a linked server to connect to PostgreSQL from MSSQL, you need to download the .msi package from the following site.<\/p>\n<p>https:\/\/www.pgoledb.com\/index.php\/component\/filecabinet\/?view=files&#038;id=1<\/p>\n<p>After downloading and installing from the above link, we can create a linked server by following the steps below. You need to see if you have the required provider in the instance by go to the &#8220;Server Objects&gt; Linked Servers&gt; Providers&#8221; tab.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2019\/04\/mssqltopostgresql_1.png\" width=\"351\" height=\"651\" \/><\/p>\n<h2>Create Linked Server<\/h2>\n<p>First, right-click the Linked Server tab under the Server Objects tab and click the New Linked Server.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2019\/04\/mssqltopostgresql_2.png\" width=\"484\" height=\"425\" \/><\/p>\n<p>After you click New Linked Server, you have to fill in the fields on the General tab as I will explain.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2019\/04\/mssqltopostgresql_3.png\" \/><\/p>\n<p>Linked server\u00a0 \u00a0-&gt; Give any name<br \/>\nServer Type\u00a0 \u00a0 \u00a0 -&gt; Chose Other data source.<br \/>\nProvider\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0-&gt; Choose Intellisoft OLE DB Provider for PostgreSQL.<br \/>\nProduct Name\u00a0 -&gt; Give any name.<br \/>\nData Source\u00a0 \u00a0 \u00a0 -&gt; Write PostgreSQL IP<br \/>\nProvider\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0-&gt; SERVER=POSTGRESQL_IP,port;USER ID=POSTGRESQL_USER<\/p>\n<p>Example: SERVER=127.0.5.5,5432;USER ID=postgres<\/p>\n<p>After you fill the necessary fields on the General tab, go to the Security tab.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13255 aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/10\/Ads\u0131z-13.png\" alt=\"\" width=\"685\" height=\"623\" \/><\/p>\n<p>On the Security tab, we select &#8220;Be made using this security context&#8221; at the bottom and write the PostgreSQL user name and password. After completing these steps, you will see the Linked Server created under the Linked Server tab.<\/p>\n<p>You can check linked server is created successfully by right-clicking on the created linked server and clicking test connection.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13256 aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/10\/Ads\u0131z-14.png\" alt=\"\" width=\"473\" height=\"221\" \/><\/p>\n<p>In the Message Box above, you can see that we have successfully connected from MSSQL to PostgreSQL via a linked server.<\/p>\n<p>If you want to see the databases in the PostgreSQL you are connected to, you can see the databases by clicking the Catalog tab in the Linked Server you created. We can query PostgreSQL via the linked server as follows.<\/p>\n<pre class=\"lang:default decode:true \">SELECT *\u00a0 FROM [POSTGRESQL].[postgres].[public].[Person]<\/pre>\n<p>if you want to connect to SQL Server or Oracle From PostgreSQL you may want to read the below articles.<\/p>\n<p>&#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/10\/23\/foreign-data-wrapper-between-postgresql-and-mssql\/\" target=\"_blank\" rel=\"noopener noreferrer\">Foreing Data Wrapper Between PostgreSQL and MSSQL<\/a>&#8220;,<\/p>\n<p>&#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/12\/02\/foreign-data-wrapper-between-postgresql-and-oracle\/\" target=\"_blank\" rel=\"noopener noreferrer\">Foreign Data Wrapper Between PostgreSQL and Oracle<\/a>&#8220;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_13249\" class=\"pvc_stats all  \" data-element-id=\"13249\" 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>You may want to transfer data to MSSQL from PostgreSQL or send query to PostgreSQL from MSSQL. There are different methods to perform this. One of method is linked server. First, to create a linked server to connect to PostgreSQL from MSSQL, you need to download the .msi package from the following site. https:\/\/www.pgoledb.com\/index.php\/component\/filecabinet\/?view=files&#038;id=1 After &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_13249\" class=\"pvc_stats all  \" data-element-id=\"13249\" 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":13259,"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,5],"tags":[4951,4953,4952,4954,4955,4956,4958,4957],"class_list":["post-13249","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-mssql","category-postgres","tag-connect-postgres-from-mssql","tag-connect-postgres-from-sql-server","tag-connect-postgresql-from-mssql","tag-connect-postgresql-from-sql-server","tag-linked-server-for-postgres","tag-linked-server-for-postgresql","tag-move-data-from-postgresql-to-sql-server","tag-transfer-data-from-postgresql-to-sql-server"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How To Create a Linked Server To Connect To PostgreSQL From SQL Server - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How To Create a Linked Server To Connect To PostgreSQL From SQL Server\" \/>\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\/2019\/10\/22\/how-to-create-a-linked-server-to-connect-to-postgresql-from-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 Create a Linked Server To Connect To PostgreSQL From SQL Server - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How To Create a Linked Server To Connect To PostgreSQL From SQL Server\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/10\/22\/how-to-create-a-linked-server-to-connect-to-postgresql-from-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-10-22T08:14:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-10-23T07:00:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/10\/Ads\u0131z-15.png\" \/>\n\t<meta property=\"og:image:width\" content=\"609\" \/>\n\t<meta property=\"og:image:height\" content=\"401\" \/>\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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/10\/22\/how-to-create-a-linked-server-to-connect-to-postgresql-from-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/10\/22\/how-to-create-a-linked-server-to-connect-to-postgresql-from-sql-server\/\"},\"author\":{\"name\":\"Faruk Erdem\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb\"},\"headline\":\"How To Create a Linked Server To Connect To PostgreSQL From SQL Server\",\"datePublished\":\"2019-10-22T08:14:27+00:00\",\"dateModified\":\"2019-10-23T07:00:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/10\/22\/how-to-create-a-linked-server-to-connect-to-postgresql-from-sql-server\/\"},\"wordCount\":386,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/10\/22\/how-to-create-a-linked-server-to-connect-to-postgresql-from-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/10\/Ads\u0131z-15.png\",\"keywords\":[\"connect postgres from mssql\",\"connect postgres from sql server\",\"connect postgresql from mssql\",\"connect postgresql from sql server\",\"linked server for postgres\",\"linked server for postgresql\",\"move data from postgresql to sql server\",\"transfer data from postgresql to sql server\"],\"articleSection\":[\"MSSQL\",\"PostgreSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/10\/22\/how-to-create-a-linked-server-to-connect-to-postgresql-from-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/10\/22\/how-to-create-a-linked-server-to-connect-to-postgresql-from-sql-server\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/10\/22\/how-to-create-a-linked-server-to-connect-to-postgresql-from-sql-server\/\",\"name\":\"How To Create a Linked Server To Connect To PostgreSQL From SQL Server - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/10\/22\/how-to-create-a-linked-server-to-connect-to-postgresql-from-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/10\/22\/how-to-create-a-linked-server-to-connect-to-postgresql-from-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/10\/Ads\u0131z-15.png\",\"datePublished\":\"2019-10-22T08:14:27+00:00\",\"dateModified\":\"2019-10-23T07:00:04+00:00\",\"description\":\"How To Create a Linked Server To Connect To PostgreSQL From SQL Server\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/10\/22\/how-to-create-a-linked-server-to-connect-to-postgresql-from-sql-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/10\/22\/how-to-create-a-linked-server-to-connect-to-postgresql-from-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/10\/22\/how-to-create-a-linked-server-to-connect-to-postgresql-from-sql-server\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/10\/Ads\u0131z-15.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/10\/Ads\u0131z-15.png\",\"width\":609,\"height\":401},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/10\/22\/how-to-create-a-linked-server-to-connect-to-postgresql-from-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Create a Linked Server To Connect To PostgreSQL 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":"How To Create a Linked Server To Connect To PostgreSQL From SQL Server - Database Tutorials","description":"How To Create a Linked Server To Connect To PostgreSQL From SQL Server","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\/2019\/10\/22\/how-to-create-a-linked-server-to-connect-to-postgresql-from-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"How To Create a Linked Server To Connect To PostgreSQL From SQL Server - Database Tutorials","og_description":"How To Create a Linked Server To Connect To PostgreSQL From SQL Server","og_url":"https:\/\/dbtut.com\/index.php\/2019\/10\/22\/how-to-create-a-linked-server-to-connect-to-postgresql-from-sql-server\/","og_site_name":"Database Tutorials","article_published_time":"2019-10-22T08:14:27+00:00","article_modified_time":"2019-10-23T07:00:04+00:00","og_image":[{"width":609,"height":401,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/10\/Ads\u0131z-15.png","type":"image\/png"}],"author":"Faruk Erdem","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Faruk Erdem","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/10\/22\/how-to-create-a-linked-server-to-connect-to-postgresql-from-sql-server\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/10\/22\/how-to-create-a-linked-server-to-connect-to-postgresql-from-sql-server\/"},"author":{"name":"Faruk Erdem","@id":"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb"},"headline":"How To Create a Linked Server To Connect To PostgreSQL From SQL Server","datePublished":"2019-10-22T08:14:27+00:00","dateModified":"2019-10-23T07:00:04+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/10\/22\/how-to-create-a-linked-server-to-connect-to-postgresql-from-sql-server\/"},"wordCount":386,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/10\/22\/how-to-create-a-linked-server-to-connect-to-postgresql-from-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/10\/Ads\u0131z-15.png","keywords":["connect postgres from mssql","connect postgres from sql server","connect postgresql from mssql","connect postgresql from sql server","linked server for postgres","linked server for postgresql","move data from postgresql to sql server","transfer data from postgresql to sql server"],"articleSection":["MSSQL","PostgreSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/10\/22\/how-to-create-a-linked-server-to-connect-to-postgresql-from-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/10\/22\/how-to-create-a-linked-server-to-connect-to-postgresql-from-sql-server\/","url":"https:\/\/dbtut.com\/index.php\/2019\/10\/22\/how-to-create-a-linked-server-to-connect-to-postgresql-from-sql-server\/","name":"How To Create a Linked Server To Connect To PostgreSQL From SQL Server - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/10\/22\/how-to-create-a-linked-server-to-connect-to-postgresql-from-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/10\/22\/how-to-create-a-linked-server-to-connect-to-postgresql-from-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/10\/Ads\u0131z-15.png","datePublished":"2019-10-22T08:14:27+00:00","dateModified":"2019-10-23T07:00:04+00:00","description":"How To Create a Linked Server To Connect To PostgreSQL From SQL Server","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/10\/22\/how-to-create-a-linked-server-to-connect-to-postgresql-from-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/10\/22\/how-to-create-a-linked-server-to-connect-to-postgresql-from-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/10\/22\/how-to-create-a-linked-server-to-connect-to-postgresql-from-sql-server\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/10\/Ads\u0131z-15.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/10\/Ads\u0131z-15.png","width":609,"height":401},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/10\/22\/how-to-create-a-linked-server-to-connect-to-postgresql-from-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Create a Linked Server To Connect To PostgreSQL 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\/13249","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=13249"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/13249\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/13259"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=13249"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=13249"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=13249"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}