Welcome to WebmasterWorld Guest from 54.158.10.156

Forum Moderators: bill

Message Too Old, No Replies

Microsoft has made SQL Server for Linux

     
1:17 am on Mar 8, 2016 (gmt 0)

Administrator from JP 

WebmasterWorld Administrator bill is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month Best Post Of The Month

joined:Oct 12, 2000
posts:14789
votes: 86


https://blogs.microsoft.com/blog/2016/03/07/announcing-sql-server-on-linux/ [blogs.microsoft.com]

Announcing SQL Server on Linux

Today Iím excited to announce our plans to bring SQL Server to Linux as well. This will enable SQL Server to deliver a consistent data platform across Windows Server and Linux, as well as on-premises and cloud. We are bringing the core relational database capabilities to preview today, and are targeting availability in mid-2017.
8:22 am on Mar 8, 2016 (gmt 0)

Administrator from GB 

WebmasterWorld Administrator engine is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month Best Post Of The Month

joined:May 9, 2000
posts:23150
votes: 344


Wow, this is a big step, and one which will make its SQL server offering more likely to be employed.
10:36 am on Mar 8, 2016 (gmt 0)

Senior Member

WebmasterWorld Senior Member topr8 is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:Apr 19, 2002
posts:3196
votes: 12


i moved from sqlserver to mysql some years ago when i moved to a redhat.

at the time, imho, it was much better than mysql - no comparison really.

i'm sure it has kept getting better, so this is a really big step and a good one.
11:24 am on Mar 8, 2016 (gmt 0)

Senior Member from LK 

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month

joined:Nov 16, 2005
posts: 2509
votes: 31


I can see advantages over MySQL, but why would you use it rather than Postgres, Oracle or DB2?
1:19 pm on Mar 8, 2016 (gmt 0)

Senior Member

WebmasterWorld Senior Member Top Contributors Of The Month

joined:Aug 1, 2013
posts:1338
votes: 22


I can see how this could be a game changer for some, eventually. Asking Linux users to trust anything Microsoft is a stretch in itself. The thing that makes SQL Server great for me is that you can get it on most shared Windows hosting accounts (often for free like MySQL) and when you couple that with SQL Management Studio, it's a really flexible and powerful RDBMS. In that particular scenario, it's a far more friendly system than MySQL and the arcane management systems build for it, IMHO.

From an enterprise perspective, I don't know if it can compete with Oracle, DB2 or Postgres but who knows. Again, at that level, it's tough to teach old dogs new tricks. Only time will tell.
2:20 pm on Mar 8, 2016 (gmt 0)

Senior Member from LK 

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month

joined:Nov 16, 2005
posts: 2509
votes: 31


I am not a fan of MySQL either - I use Postgres whenever I can so personally that would be most interesting comparison.

I feel the big news is not that there is another RDBMS available for Linux, but the change in attitude at MS.
3:21 pm on Mar 8, 2016 (gmt 0)

Moderator from US 

WebmasterWorld Administrator lifeinasia is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month

joined:Dec 10, 2005
posts:5618
votes: 44


Wow! We're in the process of moving our data from MSSQL to MySQL and I really don't like the loss of functionality from not having Management Studio.

The licensing costs (and the amount of time needed to try to figure them out!) are the main reason for switching. As I suspect they'd carry over to Linux, I doubt we'd be switching back.

However, if/when we have the need for enterprise level, that might be a different story. Assuming similar costs, I'd probably prefer to go back to MSSQL than switch (again) to Oracle or something else.
6:12 pm on Mar 12, 2016 (gmt 0)

New User from BA 

joined:Oct 1, 2014
posts:14
votes: 0


Good thing for users using Linux.
2:56 am on Mar 21, 2016 (gmt 0)

Administrator from JP 

WebmasterWorld Administrator bill is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month Best Post Of The Month

joined:Oct 12, 2000
posts:14789
votes: 86


Microsoft provides a few more details on its SQL on Linux plans

https://blogs.technet.microsoft.com/dataplatforminsider/2016/03/15/data-driven-top-10/ [blogs.technet.microsoft.com]

Data Driven Top 10

We'll first release the core relational database capabilities on Linux targeting mid calendar year 2017 and will work with customers to prioritize the additional capabilities. The core relational database capabilities, inclusive of transaction processing and data warehousing, are the core foundation of building intelligent applications and will enable customers to get started quickly with their deployments.