{"id":29532,"date":"2023-11-23T21:22:38","date_gmt":"2023-11-23T20:22:38","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=29532"},"modified":"2023-12-15T11:04:04","modified_gmt":"2023-12-15T10:04:04","slug":"posgresql-sql-server-wiltondb-part-1-installation","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/posgresql-sql-server-wiltondb-part-1-installation\/","title":{"rendered":"PosgreSQL + SQL Server = WiltonDB \u2013 Part 1 \u2013 Installation"},"content":{"rendered":"\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"764\" height=\"186\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/image-15.png\" alt=\"\" class=\"wp-image-29533\" style=\"aspect-ratio:4.10752688172043;width:840px;height:auto\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/image-15.png 764w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/image-15-300x73.png 300w\" sizes=\"auto, (max-width: 764px) 100vw, 764px\" \/><\/figure>\n\n\n\n<p>I know,&nbsp; few years ago, it was uncredible to associate SQL Server &amp; PostgreSQL or see Microsoft in the Open source world. \ud83d\ude09 The world changes and we follow it\u2026<\/p>\n\n\n\n<p>My colleague<a href=\"https:\/\/www.dbi-services.com\/blog\/author\/daniel-westermann\/\"> Daniel Westermann<\/a> will enjoy that I write a blog about PostgreSQL but also SQL Server\u2026<\/p>\n\n\n\n<p>My first one in 10 years by dbi services but it\u2019s good to begin new challenges!<\/p>\n\n\n\n<p>I will also thanks <a href=\"https:\/\/www.dbi-services.com\/blog\/author\/daniel-westermann\/\">Daniel<\/a> to share with me the information and he knows my curiosity\u2026 \ud83d\ude09<\/p>\n\n\n\n<p>I write this article to introduce this new Open Source RDBMS&nbsp; based on PostgreSQL (I don\u2019t believe what I writing) and can accept T-SQL queries\u2026<\/p>\n\n\n\n<p>Ok more seriously, for these first steps, I test the installation, configuration &nbsp;and how to connect.<\/p>\n\n\n\n<p>WiltonDB uses the extension Babelfish to understand T-SQL queries the query language for Microsoft SQL Server. More information about it <a href=\"https:\/\/babelfishpg.org\/\">here<\/a>. <\/p>\n\n\n\n<p>You can find more explanations on the dedicated website: <a href=\"https:\/\/eur03.safelinks.protection.outlook.com\/?url=https%3A%2F%2Fwiltondb.com%2F&amp;data=05%7C01%7Cstephane.haby%40dbi-services.com%7C09e131011d0a4cbefecc08dbe5c928da%7Cb9c70613b1ea47b79fdde6f3a67ce75c%7C0%7C0%7C638356424351100661%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&amp;sdata=%2FJkPMQ%2FBGolqw%2BXxZC11jiJa1VnRknInOmxJiucX%2BLI%3D&amp;reserved=0\">https:\/\/wiltondb.com\/<\/a><\/p>\n\n\n\n<p>Let start\u2019s!<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-the-installation\"><strong>The Installation<\/strong><\/h2>\n\n\n\n<p>To install WiltonDB, I download the msi file for Windows <a href=\"https:\/\/github.com\/wiltondb\/wiltondb\/wiki\/Getting-Started\">here<\/a>.<\/p>\n\n\n\n<p>I do the installation on a Windows Server 2022, I&#8217;m still a Microsoft guy but it\u2019s possible to do it on Linux.<\/p>\n\n\n\n<p>I run the msi file and follow the only 2 steps for the installation:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Accept the License terms as usual<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"494\" height=\"385\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/image-29.png\" alt=\"\" class=\"wp-image-29553\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/image-29.png 494w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/image-29-300x234.png 300w\" sizes=\"auto, (max-width: 494px) 100vw, 494px\" \/><\/figure>\n<\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>Choose the installation folder and I take the default C:\\Program Files\\WiltonDB Software\\witondb3.3<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"494\" height=\"386\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/image-16.png\" alt=\"\" class=\"wp-image-29534\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/image-16.png 494w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/image-16-300x234.png 300w\" sizes=\"auto, (max-width: 494px) 100vw, 494px\" \/><\/figure>\n<\/div>\n\n\n<p>Few seconds later, the installation is finish and you can run the WiltonDB Configuration Tool directly from the installer<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"495\" height=\"386\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/image-18.png\" alt=\"\" class=\"wp-image-29536\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/image-18.png 495w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/image-18-300x234.png 300w\" sizes=\"auto, (max-width: 495px) 100vw, 495px\" \/><\/figure>\n<\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"h-the-configuration\"><strong>The Configuration<\/strong><\/h2>\n\n\n\n<p>The WiltonDB Configuration tool has a lot of Settings that we can configure as you can see in this screenshot.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"774\" height=\"575\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/image-19.png\" alt=\"\" class=\"wp-image-29538\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/image-19.png 774w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/image-19-300x223.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/image-19-768x571.png 768w\" sizes=\"auto, (max-width: 774px) 100vw, 774px\" \/><\/figure>\n<\/div>\n\n\n<p>You can choose also to have only a part of the settings with a already group of settings like Memory only or Networking only<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"773\" height=\"574\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/image-20.png\" alt=\"\" class=\"wp-image-29539\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/image-20.png 773w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/image-20-300x223.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/image-20-768x570.png 768w\" sizes=\"auto, (max-width: 773px) 100vw, 773px\" \/><\/figure>\n<\/div>\n\n\n<p>I choose to select the Network Only and it&#8217;s more easy to read the settings and change it if needed<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"772\" height=\"579\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/image-21.png\" alt=\"\" class=\"wp-image-29540\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/image-21.png 772w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/image-21-300x225.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/image-21-768x576.png 768w\" sizes=\"auto, (max-width: 772px) 100vw, 772px\" \/><\/figure>\n<\/div>\n\n\n<p>You can notice the <strong>babelfishpg_tds.port<\/strong> is set to <strong>1433<\/strong>, a known-port in the SQL Server world\u2026<\/p>\n\n\n\n<p>If you change something, push the button reload settings to apply your changes<\/p>\n\n\n\n<p><strong><em>Tips<\/em><\/strong><\/p>\n\n\n\n<p>if you search in the windows menu, you will not find the WiltonDB Configuration tool. You need to go to the folder <strong>C:\\Program Files\\WiltonDB Software\\witondb3.3\\bin and run wdb_config.exe<\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"542\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/image-22-1024x542.png\" alt=\"\" class=\"wp-image-29541\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/image-22-1024x542.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/image-22-300x159.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/image-22-768x406.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/image-22.png 1507w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p>When you run wdb_config.exe, the WiltonDB Configuration tool asks you the connection credential and after you can easily change again the settings.<\/p>\n\n\n\n<p>The default login and password are wilton and test the connection first and load the settings after\u2026<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"639\" height=\"506\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/image-23.png\" alt=\"\" class=\"wp-image-29542\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/image-23.png 639w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/image-23-300x238.png 300w\" sizes=\"auto, (max-width: 639px) 100vw, 639px\" \/><\/figure>\n<\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"h-the-queries-test\"><strong>The Queries Test<\/strong><\/h2>\n\n\n\n<p>Now go to test through SSMS (SQL Server Management Studio)<\/p>\n\n\n\n<p>The connection will work only with the 127.0.0.1 and port 1433. Localhost or the computer name does not work\u2026<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"933\" height=\"506\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/image-24.png\" alt=\"\" class=\"wp-image-29543\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/image-24.png 933w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/image-24-300x163.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/image-24-768x417.png 768w\" sizes=\"auto, (max-width: 933px) 100vw, 933px\" \/><\/figure>\n<\/div>\n\n\n<p>As you can see, the SQL Server version see by SSMS is 12.0.2000.8<\/p>\n\n\n\n<p>Let&#8217;s go with the first <a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/t-sql\/functions\/configuration-functions-transact-sql?view=sql-server-ver16\">configuration scalar function<\/a> well known in the SQL Server World: <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT @@VERSION<\/code><\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"299\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/image-25-1024x299.png\" alt=\"\" class=\"wp-image-29544\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/image-25-1024x299.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/image-25-300x88.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/image-25-768x224.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/image-25.png 1281w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p>Nice result: Babelfish for PosgreSQL with SQL Server Compatibilty \u2013 12.0.2000.8 \u2026.<\/p>\n\n\n\n<p>I run a select of 3 configuration scalar function: <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT @@VERSION, @@SERVERNAME, @@LANGUAGE <\/code><\/pre>\n\n\n\n<p>and run it on the wiltonDB and to compare to SQL Server, I have installed a named instance inst01<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"626\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/image-26-1024x626.png\" alt=\"\" class=\"wp-image-29545\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/image-26-1024x626.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/image-26-300x183.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/image-26-768x469.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/image-26.png 1029w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p>You can see that the servername is <strong><em>BABELFISH<\/em><\/strong> and not the real name of the server\u2026 \u2639<\/p>\n\n\n\n<p>I continue with <a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/t-sql\/functions\/metadata-functions-transact-sql?view=sql-server-ver16\">Metadata scalar function<\/a> for database object on both instance<\/p>\n\n\n\n<p>I don&#8217;t try all but just these two on 2 system databases (master and msdb):<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT DB_NAME(), DB_ID()<\/code><\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"718\" height=\"684\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/image-27.png\" alt=\"\" class=\"wp-image-29546\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/image-27.png 718w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/image-27-300x286.png 300w\" sizes=\"auto, (max-width: 718px) 100vw, 718px\" \/><\/figure>\n<\/div>\n\n\n<p>I continue with the <a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/relational-databases\/system-catalog-views\/catalog-views-transact-sql?view=sql-server-ver16\">System Catalog Views<\/a>  on the WiltonDB with<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT * from Sys.databases \nSELECT * from Sys.configurations\nSELECT * from Sys.Logins<\/code><\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"334\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/image-28-1024x334.png\" alt=\"\" class=\"wp-image-29547\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/image-28-1024x334.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/image-28-300x98.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/image-28-768x250.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/image-28-1536x500.png 1536w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/image-28.png 1550w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p>We can see that we have 3 system databases (master,msdb and tempdb) like SQL Server. The model is missing\u2026<\/p>\n\n\n\n<p>On the configuration, we have only 7 parameters and as login only the &#8220;SQL Login&#8221; wilton<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-conclusion\">Conclusion<\/h2>\n\n\n\n<p>I was very curious about it and begin the first steps (installation, configurations &amp; first queries)<\/p>\n\n\n\n<p>I need to say that WiltonDB is easy to install and very fast.<\/p>\n\n\n\n<p>The default configuration is a good start &nbsp;but need to be more studying to optimize the settings.<\/p>\n\n\n\n<p>I&#8217;m very interested to continue to test and see the possibilities of WiltonDB\u2026<\/p>\n\n\n\n<p><strong><em>See you soon for the next steps of my tests like the security, database creation, restore an existing database,\u2026.!<\/em><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>I know,&nbsp; few years ago, it was uncredible to associate SQL Server &amp; PostgreSQL or see Microsoft in the Open source world. \ud83d\ude09 The world changes and we follow it\u2026 My colleague Daniel Westermann will enjoy that I write a blog about PostgreSQL but also SQL Server\u2026 My first one in 10 years by dbi [&hellip;]<\/p>\n","protected":false},"author":15,"featured_media":29550,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,198,83,99,48],"tags":[49,2602,51],"type_dbi":[2749,2874],"class_list":["post-29532","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","category-database-management","category-postgresql","category-sql-server","category-technology-survey","tag-microsoft","tag-postgresql-2","tag-sql-server","type-postgresql","type-sql-server"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>PosgreSQL + SQL Server = WiltonDB \u2013 Part 1 \u2013 Installation - dbi Blog<\/title>\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.dbi-services.com\/blog\/posgresql-sql-server-wiltondb-part-1-installation\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PosgreSQL + SQL Server = WiltonDB \u2013 Part 1 \u2013 Installation\" \/>\n<meta property=\"og:description\" content=\"I know,&nbsp; few years ago, it was uncredible to associate SQL Server &amp; PostgreSQL or see Microsoft in the Open source world. \ud83d\ude09 The world changes and we follow it\u2026 My colleague Daniel Westermann will enjoy that I write a blog about PostgreSQL but also SQL Server\u2026 My first one in 10 years by dbi [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/posgresql-sql-server-wiltondb-part-1-installation\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2023-11-23T20:22:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-15T10:04:04+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/wilton.png\" \/>\n\t<meta property=\"og:image:width\" content=\"171\" \/>\n\t<meta property=\"og:image:height\" content=\"66\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"St\u00e9phane Haby\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"St\u00e9phane Haby\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/posgresql-sql-server-wiltondb-part-1-installation\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/posgresql-sql-server-wiltondb-part-1-installation\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"headline\":\"PosgreSQL + SQL Server = WiltonDB \u2013 Part 1 \u2013 Installation\",\"datePublished\":\"2023-11-23T20:22:38+00:00\",\"dateModified\":\"2023-12-15T10:04:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/posgresql-sql-server-wiltondb-part-1-installation\/\"},\"wordCount\":690,\"commentCount\":1,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/posgresql-sql-server-wiltondb-part-1-installation\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/wilton.png\",\"keywords\":[\"Microsoft\",\"postgresql\",\"SQL Server\"],\"articleSection\":[\"Database Administration &amp; Monitoring\",\"Database management\",\"PostgreSQL\",\"SQL Server\",\"Technology Survey\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/posgresql-sql-server-wiltondb-part-1-installation\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/posgresql-sql-server-wiltondb-part-1-installation\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/posgresql-sql-server-wiltondb-part-1-installation\/\",\"name\":\"PosgreSQL + SQL Server = WiltonDB \u2013 Part 1 \u2013 Installation - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/posgresql-sql-server-wiltondb-part-1-installation\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/posgresql-sql-server-wiltondb-part-1-installation\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/wilton.png\",\"datePublished\":\"2023-11-23T20:22:38+00:00\",\"dateModified\":\"2023-12-15T10:04:04+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/posgresql-sql-server-wiltondb-part-1-installation\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/posgresql-sql-server-wiltondb-part-1-installation\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/posgresql-sql-server-wiltondb-part-1-installation\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/wilton.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/wilton.png\",\"width\":171,\"height\":66},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/posgresql-sql-server-wiltondb-part-1-installation\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PosgreSQL + SQL Server = WiltonDB \u2013 Part 1 \u2013 Installation\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\",\"name\":\"St\u00e9phane Haby\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"caption\":\"St\u00e9phane Haby\"},\"description\":\"St\u00e9phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. St\u00e9phane Haby is Microsoft Most Valuable Professional (MVP) as well as Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals &amp; Pharmaceuticals, Banking \/ Financial Services, and many other industries.\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/stephane-haby\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"PosgreSQL + SQL Server = WiltonDB \u2013 Part 1 \u2013 Installation - dbi Blog","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.dbi-services.com\/blog\/posgresql-sql-server-wiltondb-part-1-installation\/","og_locale":"en_US","og_type":"article","og_title":"PosgreSQL + SQL Server = WiltonDB \u2013 Part 1 \u2013 Installation","og_description":"I know,&nbsp; few years ago, it was uncredible to associate SQL Server &amp; PostgreSQL or see Microsoft in the Open source world. \ud83d\ude09 The world changes and we follow it\u2026 My colleague Daniel Westermann will enjoy that I write a blog about PostgreSQL but also SQL Server\u2026 My first one in 10 years by dbi [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/posgresql-sql-server-wiltondb-part-1-installation\/","og_site_name":"dbi Blog","article_published_time":"2023-11-23T20:22:38+00:00","article_modified_time":"2023-12-15T10:04:04+00:00","og_image":[{"width":171,"height":66,"url":"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/wilton.png","type":"image\/png"}],"author":"St\u00e9phane Haby","twitter_card":"summary_large_image","twitter_misc":{"Written by":"St\u00e9phane Haby","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/posgresql-sql-server-wiltondb-part-1-installation\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/posgresql-sql-server-wiltondb-part-1-installation\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"headline":"PosgreSQL + SQL Server = WiltonDB \u2013 Part 1 \u2013 Installation","datePublished":"2023-11-23T20:22:38+00:00","dateModified":"2023-12-15T10:04:04+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/posgresql-sql-server-wiltondb-part-1-installation\/"},"wordCount":690,"commentCount":1,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/posgresql-sql-server-wiltondb-part-1-installation\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/wilton.png","keywords":["Microsoft","postgresql","SQL Server"],"articleSection":["Database Administration &amp; Monitoring","Database management","PostgreSQL","SQL Server","Technology Survey"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/posgresql-sql-server-wiltondb-part-1-installation\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/posgresql-sql-server-wiltondb-part-1-installation\/","url":"https:\/\/www.dbi-services.com\/blog\/posgresql-sql-server-wiltondb-part-1-installation\/","name":"PosgreSQL + SQL Server = WiltonDB \u2013 Part 1 \u2013 Installation - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/posgresql-sql-server-wiltondb-part-1-installation\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/posgresql-sql-server-wiltondb-part-1-installation\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/wilton.png","datePublished":"2023-11-23T20:22:38+00:00","dateModified":"2023-12-15T10:04:04+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/posgresql-sql-server-wiltondb-part-1-installation\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/posgresql-sql-server-wiltondb-part-1-installation\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/posgresql-sql-server-wiltondb-part-1-installation\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/wilton.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/11\/wilton.png","width":171,"height":66},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/posgresql-sql-server-wiltondb-part-1-installation\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"PosgreSQL + SQL Server = WiltonDB \u2013 Part 1 \u2013 Installation"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b","name":"St\u00e9phane Haby","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","caption":"St\u00e9phane Haby"},"description":"St\u00e9phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. St\u00e9phane Haby is Microsoft Most Valuable Professional (MVP) as well as Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals &amp; Pharmaceuticals, Banking \/ Financial Services, and many other industries.","url":"https:\/\/www.dbi-services.com\/blog\/author\/stephane-haby\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/29532","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=29532"}],"version-history":[{"count":4,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/29532\/revisions"}],"predecessor-version":[{"id":29554,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/29532\/revisions\/29554"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/29550"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=29532"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=29532"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=29532"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=29532"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}