MS SQL Server on UNIX

UNIX for Beginners Q & A UNIX for Dummies Questions & Answers
1

Hi GURUs,

I have following queries:

1) If its possible to configure Microsoft SQL Server database on a UNIX machine, if yes, can any body pls point me to the guide to acheive the same.

2) I know Oracle runs perfectly on UNIX based machines, can any body point me to the guide to achieve the same.

3) Which UNIX/LINUX server you would recommend if its a small/medium business for Oracle database.

Any help would be highly appreciated.

Cheers,
Patras

2

www.orafaq.com
has some articles about sizing Oracle support for an application. It has more to do with transactions per minute, number of tables, number of simultaneous users, and total data store required. Most Unix Oracle apps are distributed - PC's running Oracle Forms, and a UNIX box with lots of disk space and memory -- all on a fast network.

You should look to support issues first and foremost - like can you get hardware & software support (ie., people) on your site the same day?...

3

Thanks Jim for your prompt reply. I'll get all the data and feedback here, this was all about Oracle.

What about MS SQL Server on UNIX? If there is any way to run it on UNIX?

Thanks in advance.

Cheers,
Patras

4

MS SQL Server will not run on UNIX machines. Windows only (2000, 2003, XP, some versions will work on NT 4.0).

5

Linux &UNIX have ODBC support that allows you to query networked Windows servers.

http://www.unixodbc.org/ free
Build a Custom Connector - OpenAccess SDK | Progress DataDirect supported/cost

6

And production versions of MS SQL server will only run on certain editions of Windows. For instance, SQL Server (Standard) is only installable on "Server" editions of Windows only.

7

You cant run SQL Server on Unix. However, you can access the SQL Server running on Windows from a Unix machine using JDBC/ODBC