SQL Server and UNIX

Question

SQL Server and UNIX

Vishal Singh

SSCertifiable

Points: 5830
More actions
June 10, 2010 at 11:58 pm

#140783

Guys, my one liner question. I know it has many things associated along but still.
Is there any chance for SQL Server to be compatible on UNIX (or similar) OS platform in near future?
-Forum Etiquette: How to post Performance Problems[/url]
-Forum Etiquette: How to post data/code to get the best help [/url]

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323504 More actions · Answer 1

No, MS sql server is locked into the MS windows operating systems, with no plans for multi-platform.

so while the SQL Engine itself must run in a windows environment, you can still access SQL Server from UNIX, and it's also possible to run a virtual windows environment from within UNIX to have a virtual Windows instance.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Vishal Singh SSCertifiable Points: 5830 More actions · Answer 2

Thanks Lowell,

Can you shed some more light on accessing SQL Server DB Engine from an UNIX platform.

-Forum Etiquette: How to post Performance Problems[/url]

-Forum Etiquette: How to post data/code to get the best help [/url]

Johan Bijnens SSC Guru Points: 135255 More actions · Answer 3

SQLServer actually on unix : only when hell freezes over 😉

or MS sells the product

or MS is broke (and someone else is willing to adapt it all).

to connect to sqlserver from a unix platform: use the JDBC driver.

Have a look at "Using the JDBC Driver" http://msdn.microsoft.com/en-us/library/ms378526%28SQL.90%29.aspx

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

free_mascot One Orange Chip Points: 27169 More actions · Answer 4

You can refer the following link for reference:

http://www.sommarskog.se/mssqlperl/unix.html

HTH

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

Vishal Singh SSCertifiable Points: 5830 More actions · Answer 5

free_mascot (6/16/2010)
You can refer the following link for reference:
http://www.sommarskog.se/mssqlperl/unix.html
HTH

This is a good link. Thanks.

-Forum Etiquette: How to post Performance Problems[/url]

-Forum Etiquette: How to post data/code to get the best help [/url]

spaghettidba SSC Guru Points: 105732 More actions · Answer 6

You could use Sybase. That works on UNIX.

-- Gianluca Sartori

Vishal Singh SSCertifiable Points: 5830 More actions · Answer 7

Gianluca Sartori (6/16/2010)
You could use Sybase. That works on UNIX.

I am bounded to use SQL Server.. 🙂

-Forum Etiquette: How to post Performance Problems[/url]

-Forum Etiquette: How to post data/code to get the best help [/url]

Nice Marmot SSCrazy Points: 2278 More actions · Answer 8

I seem to remember some kind of marketing questionnaire from Microsoft a few months ago about client tools support for non-Windows platforms. So, there could be something in the pipeline . . . or not. 😀

Vishal Singh SSCertifiable Points: 5830 More actions · Answer 9

Nice Marmot (6/18/2010)
I seem to remember some kind of marketing questionnaire from Microsoft a few months ago about client tools support for non-Windows platforms. So, there could be something in the pipeline . . . or not. 😀

We recently had a project where we were making a decisions between SQL Server and Oracle, and Oracle won just because it has multiple OS supports.

Everything else was quite ok with SQL Server but this one force it to loose the game...

-Forum Etiquette: How to post Performance Problems[/url]

-Forum Etiquette: How to post data/code to get the best help [/url]