question

quandary avatar image
quandary asked

Is there any way to get MS-SQL to work on Linux ?

Because if not, I have to use Oracle. I guess not, because it doesn't work with wine, and because MS wouldn't like that.
sql-server-2008sql-server-2005sql-server-2008-r2linux
6 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

why Oracle? You could use MySQL. (Other DBMSs exist.) Just curious.
2 Likes 2 ·
If you say "There is gonna be a lot of db usage" then I would invest time and effort in reviewing your requirements.
1 Like 1 ·
Because I need enforcement of constraints and datatype correctness (date). There is gonna be a lot of db usage and a lot of data. I could use postgre, but it's too slow. Besides, MySQL is also Oracle now.
0 Likes 0 ·
@ThomasRushton MySQL is a piece of Oracle by now :) I mean they bought it few years back.
0 Likes 0 ·
I already have, actually with benchmark. It led me to Linux, because Windows file handling and network shares are too slow.
0 Likes 0 ·
Show more comments
Shawn_Melton avatar image
Shawn_Melton answered
Directly...No. Round about way...Install ESX Server (which is based off Linux kernel), then build Windows VM, then install SQL Server. I'm with @ThomasRushton though there are other DBMSs out there beside Oracle that run on Linux, and are much cheaper than Oracle.
7 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Not to start a debate on pricing and all but where do you find Oracle for $175? There website shows Personal Edition is $460, but that license is for development purposes and only runs on Windows. Then you have Express edition which looks to be free, but shows to be limited to 4GB of user data. Standard Edition starts at $5,800.
3 Likes 3 ·
@jonlee lockwood. You should have taken notice of the date 04/01/2005 APRIL FOOLS DAY. Steve is notorious for outlandish things on April Fools. Such as this year being SSC was moving to Google and NOSQL.
1 Like 1 ·
Oracle only costs 175$ for what I need. And why install ESX server, when you're anyway gonna install a VM ? And a VM doesn't count as "running on Linux", since one needs the windows license, then.
0 Likes 0 ·
VM or nothing. That's the only answer.
0 Likes 0 ·
Show more comments
Matt Whitfield avatar image
Matt Whitfield answered
If you have to run on Linux, run PostGreSQL. It would certainly be my first port of call if wandering outside of the SQL Server world... In short though, no, there isn't a way that you can get SQL Server to run on Linux *directly*. As others have said, VMs running Windows are an option, but if you have to install Linux on the bare tin, I don't see why you would be allowed to install Windows in a VM...
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Pavel Pawlowski avatar image
Pavel Pawlowski answered
If you need to store enormous amount of data and the speed is also important, besides Oracle you can use eg. [Greenplum Database][1] which is good especially for big Data Warehouses and in a Community Edition is free (1 server with 2 logical nodes). You can move anytime to a commercial version for MPP. Btw. it is build upon PostreSQL. :-) Alternatively if you need a real power you can move to [Teradata][2] which also runs on linux (but the preces are not in hundreds of $ :-) [1]: http://www.greenplum.com/products/greenplum-database [2]: http://www.teradata.com/
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

KenAWatson avatar image
KenAWatson answered
HBase/Hadoop?
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

SQIAR avatar image
SQIAR answered
**Data Warehousing** Now a Business System is so Complex.And Company Need to Present it Data into Meaningful Form.so Every One Easily Understand it.Our Company http://www.sqiar.com/ Which is in London.our Experts Provide Services like Data Warehousing (Data Mining,Data Modelling,ETL Services) etc.So in this Services We Convert Company Data into Meaningful Form.So user Take Better and Informed Decisions
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.