MS SQL Server on UNIX


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers MS SQL Server on UNIX
# 1  
Old 07-11-2006
MS SQL Server on UNIX

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  
Old 07-11-2006
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  
Old 07-11-2006
Quote:
It has more to do with transactions per minute, number of tables, number of simultaneous users, and total data store required
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  
Old 07-11-2006
MS SQL Server on UNIX

MS SQL Server will not run on UNIX machines. Windows only (2000, 2003, XP, some versions will work on NT 4.0).
# 5  
Old 07-11-2006
Linux &UNIX have ODBC support that allows you to query networked Windows servers.

http://www.unixodbc.org/ free
http://www.odbcsdk.com/products/open...x_overview.asp supported/cost
# 6  
Old 07-11-2006
Quote:
Originally Posted by hshapiro
MS SQL Server will not run on UNIX machines. Windows only (2000, 2003, XP, some versions will work on NT 4.0).
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  
Old 07-12-2006
You cant run SQL Server on Unix. However, you can access the SQL Server running on Windows from a Unix machine using JDBC/ODBC
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Invoking sql server from UNIX

I would like to invoke a procedure in SQL server which will return some results of a select query from UNIX script. I would like to invoke this procedure and load the data into a flat file in UNIX. Can you please help? I am not able to find any sample programs in Internet. (1 Reply)
Discussion started by: madhu.sushmitha
1 Replies

2. UNIX for Dummies Questions & Answers

UNIX string connection to sql server db

Hi, i have to perform a connection from unix to sql server database, using TCP protocol. I have all connection parameters (user,pwd,server_name,port,db_name). How can i perform this connection, by unix console ? is it available a command similar to this one (for oracle): sqlplus... (1 Reply)
Discussion started by: nash83
1 Replies

3. Shell Programming and Scripting

Unix and SQL server

Hi All, I am accessing Unix through putty (i.e. unix is installed on other server and i am accessing it remotely through putty). I am having SQL Server 2008 installed on my computer. Now i want to access sql server via. unix. Could some one please help me in this!!! Thanks (2 Replies)
Discussion started by: preetpalkapoor
2 Replies

4. Emergency UNIX and Linux Support

How to connect Unix and Sql Server 2005?

Hi All Can any one please help me about How to connect Unix with Sql Server 2005 I want to do it urgently and i didn't find the way. (14 Replies)
Discussion started by: parthmittal2007
14 Replies

5. Shell Programming and Scripting

Unix with sql Server 2005

Hello All I am getting a problem.What i want to do is to connect unix(korn shell) and sql server 2005. But it is not happening. The task is to schedule a job using crown or something else that connect with sql server 2005 and run the query and save the result in a text file. (5 Replies)
Discussion started by: parthmittal2007
5 Replies

6. Shell Programming and Scripting

From Solaris UNIX to MS SQL Server

Hello, my problem is, that I want to send an SQL-Statement via ksh-Shell to an MS-SQL-Database based on SQL Server 2005. I want to receive a file, which can be used for further actions on UNIX (Sun OS 5.9). ODBCUnix and JDBC and FreeTDS are not allowed. Does anybody have a suggestion? Br,... (0 Replies)
Discussion started by: usagi67
0 Replies

7. Shell Programming and Scripting

Unix to Sql Server via JDBC

I am trying to connect SQL SERVER VIA JDCB. Following is something I tried and will appreciate any help what I am doing wrong Here's what I did, I tried several variations, but I keep getting this error: Exception in thread "main" java.sql.SQLException: Unable to connect. Invalid URL I... (1 Reply)
Discussion started by: cqldba
1 Replies

8. Shell Programming and Scripting

Can SQL Server call be made from unix sh

Hi, I need to make SQL Server procedure call (exec <proc name>)from unix shell script. First of all I would like to know if it is possible. I know we can do it from Oracle but not sure about SQL Server. Version: SunOS 5.8 SQL 8.0 I have made the below entry in the interface file. NSXNA267 ... (0 Replies)
Discussion started by: sspreethi
0 Replies

9. Shell Programming and Scripting

Script needed to FTP a file from sql report to unix server

Hi All, I have a Sqlplus report which will create a file. I need a FTP Script that will be executed inside the Sqlplus Report to FTP the report output file to unix server. Thanks, Previn (0 Replies)
Discussion started by: vprevin
0 Replies

10. UNIX for Dummies Questions & Answers

Installing Ms Sql Server 2000 On Unix

Hello As per requirements, can i Install a MSSQL SERVER on UNIX , is it possible., can i install or not.., could u plz give me reply with some installation details.......... Regards&Thanking You sreedhar G (1 Reply)
Discussion started by: sreedhargunda
1 Replies
Login or Register to Ask a Question