Microsoft SQL Server on Linux on March, 2016. I was installed it as a toy and was impressed by the easy installation, just add a repository, then yum\/apt-get install and that it! <\/p>\n
Now, SQL Server 2017 on Linux became official GA. Restore the backup dump from Windows using SQL Management Studio, and changed the connection string, then your application is ready to go. So far, it’s fast and stable. Some benchmarks show the performance same as on Windows. So, how a native Windows application ported to Linux without performance lost? The magic is the SQL Server Operating System. SQL manages threads and memory by it own even on Windows, and it uses Drawbridge as a thin layer to call Linux native APIs.<\/p>\n
Supporting Linux is a great advantage on cloud. With the exit of DB2, SQL Server on Linux surely can compete with Oracle DB, MySQL and PostgreSQL on cloud.<\/p>\n
SQL Server 2017 on Linux \u5df2\u6b63\u5f0f\u63a8\u51fa\u3002\u7d42\u65bc\u6709\u6642\u9593\u8a8d\u771f\u8a66\u4e0b\u3002\u975e\u5e38\u597d\uff0c\u6bd4 Windows \u7248\u66f4\u6613\u5b89\u88dd\uff0c\u574a\u9593\u6e2c\u9a57\u7d50\u679c Linux \u7248\u6548\u80fd\u540c Windows \u7248\u4e0d\u76f8\u4f2f\u4ef2\u3002\u80cc\u5f8c\u529f\u81e3\u662f SQL Server Operation System \u548c Drawbridge\u3002Microsoft \u8d70\u5c0d\u4e86\u65b9\u5411\uff0c\u56e0\u70ba\u96f2\u662f Linux \u4e16\u754c\uff0c\u652f\u63f4 Linux \u5f8c\uff0cSQL Server \u5728 DB2 \u68c4\u6b0a\u7684\u60c5\u6cc1\u4e0b\uff0c\u53ef\u5728\u96f2\u4e16\u754c\u540c Oracle DB \/ MySQL \/ PostgreSQL \u722d\u4e00\u65e5\u9577\u77ed\u3002<\/p>\n
References (English): \u53c3\u8003 (\u4e2d\u6587)\uff1a Microsoft SQL Server on Linux on March, 2016. I was installed it as a toy and was impressed by the easy installation, just add a repository, then yum\/apt-get install and that it! Now, SQL Server 2017 on Linux became official GA. Restore the backup dump from Windows using SQL Management Studio, and changed the connection\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[18],"tags":[],"_links":{"self":[{"href":"https:\/\/carlos.aboutmy.info\/blog\/index.php?rest_route=\/wp\/v2\/posts\/685"}],"collection":[{"href":"https:\/\/carlos.aboutmy.info\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/carlos.aboutmy.info\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/carlos.aboutmy.info\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/carlos.aboutmy.info\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=685"}],"version-history":[{"count":9,"href":"https:\/\/carlos.aboutmy.info\/blog\/index.php?rest_route=\/wp\/v2\/posts\/685\/revisions"}],"predecessor-version":[{"id":694,"href":"https:\/\/carlos.aboutmy.info\/blog\/index.php?rest_route=\/wp\/v2\/posts\/685\/revisions\/694"}],"wp:attachment":[{"href":"https:\/\/carlos.aboutmy.info\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=685"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/carlos.aboutmy.info\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=685"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/carlos.aboutmy.info\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=685"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nHow Microsoft brought SQL Server to Linux<\/a>
\nSQL Server 2017: What’s new, what’s missing on Linux, and what’s next?<\/a>
\nHow an old Drawbridge helped Microsoft bring SQL Server to Linux<\/a><\/p>\n
\nWindows\u662f\u5982\u4f55\u628aSQL Server\u5f15\u5165\u5230Linux\u7684<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"