It wasn’t all that long ago that a headline saying Microsoft company would offer SQL Server for Linux system would have been taken as an April Fool’s joke; however, times have changed, and it was quite serious when Scott Guthrie, executive vice chairman of Microsoft windows Reasoning and Business division, officially declared in Goal that Microsoft would assist SQL Server on Linux system. In his weblog, Guthrie had written, “This will enable SQL Server to deliver a consistent information system across Microsoft windows Server and Linux system, as well as on premises and cloud.”
Although not everyone remembers it, SQL Server actually has its roots in Unix. When unique designer Sybase (now part of SAP) initially launched its form of SQL Server in 1987, the product was a Unix databases. Microsoft began joint growth work with Sybase and then-prominent PC databases designer Ashton-Tate in 1998, and one year later they launched the 1.0 form of what became Microsoft SQL Server — this time for IBM’s OS/2 os, which it had helped develop. This ported SQL Server to Microsoft windows NT in 1992 and went its own way on growth from then on.
Since that time, the SQL Server program code platform has evolved significantly. The company made huge changes to the program code in the SQL Server 7 and SQL Server 2005 produces, transforming the application from a departmental databases to a business information management system. Despite all this, since the unique program code platform came from Unix, moving SQL Server to Linux system isn’t as unreasonable as it might look at first.
What’s behind SQL Server for Linux?
Microsoft’s turn to put SQL Server on Linux system is fully in line with its recent accept of free and CEO Satya Nadella’s depart from Windows-centricity and increased focus on the cloud and traveling with a laptop. Microsoft company has also launched versions of Office and its Cortana personal assistant application for iOS and Android; in another turn to accept iOS and Android os applications, a few months ago, the company acquired cellular growth source Xamarin. In the long run, the SQL Server for Linux system launch will probably be seen as part of Microsoft windows strategic shift toward its Azure cloud system over Microsoft windows.
Microsoft has already declared assistance from Canonical, the commercial sponsor of the popular Ubuntu distribution of Linux system, and rival Linux system source Red Hat. In his Goal announcement, Guthrie had written, “We are bringing the main relational databasescapabilities to preview today, and are targeting availability in mid-2017.” In other words, the first launch of SQL Server on Linux system will consist of the relational databases engine and assistance for transaction processing and information warehousing. The initial launch is not expected to include other subsystems like SQL Server Analysis Solutions, Integration Solutions and Reporting Solutions.
Later in Goal, Takeshi Numoto, corporate vice chairman for cloud and enterprising marketing at Microsoft had written on the SQL Server Blog about some of the retailer’s licensing plans for the Linux system SQL Server offering. Takeshi indicated that clients who buy SQL Server per-core or per-server licenses will be able to use them on either Microsoft windows Server or Linux system. Likewise, clients who purchase Microsoft windows Software Assurance maintenance program will have the rights to release the SQL Server for Linux system, as Microsoft company makes them available.
Java Database Connection (JDBC) car owner can link Java applications to SQL Server, Azure SQL Data source and Parallel Data Warehouse. Microsoft company JDBC Driver for SQL Server is a freely available Type 4 JDBC driver; version 6.0 is available now as a review, or users can obtain earlier 4.2, 4.1 and 4.0 releases.
Microsoft company also offers an Open Data source Connection (ODBC) car owner for SQL Server on both Windows and A linux systemunix. A new Microsoft company ODBC Driver 13 release is available for obtain, currently in review. It facilitates Ubuntu in addition to the previously supported Red Hat Enterprise A linux systemunix and SUSE A linux systemunix. The review car owner also props up use of SQL Server 2016’s Always Encrypted security capability.
Free drivers for Node.js, Python and Ruby can also be used to link SQL Server to A linux systemunix systems.