Leslie,
Sybase is what SQL Server is built from, I think. I don't know much about
Sybase, but I Know that SQL Server 7 only has one transaction log file (redo
log file), that you have to back up regularly and truncate otherwise your
database will freeze. In SQL server there is no such thing as an "archived
log", you have to back up the transaction log's datafile to get your backup
of transactions. This is just one example. Does Sybase support multiple
log files? What about multiple archiving processes? That was a bit of a
bottleneck in Oracle7 for us, and I had created the max number of redo log
files. I can't imagine what it would be like with only one transaction log
file... I am looking forward to our upgrade to 8.1.6., I am curious to see
what multiple archiving processes can do.
Re. NT and UNIX, does Microsoft still sell NT? Here we could only by
Windows2000 licenses.
: )
NT is good for small to medium databases that are not too mission critical,
in my opinion, but from experience I much prefer UNIX.
I know you probably want numbers to compare, maybe you could ask DBAs how
long their NT and UNIX servers have been running without interruption, and
why they were brought down the last time...
Last I read on the 'net the new Windows versions will have new names. The
personal software (read Win9x/ME stream plus NT Workstation) will be called
WindowsXP, while the corporate operating systems (read: NT Server 4 and NT
Dataserver) will be called Windows2002. I don't know when these new
versions will be released, I think that for Windows2002 MS is aiming for 4th
quarter of 2001 at this point. That is... this coming Autumn!
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services | Services technologiques
Informatics Branch | Direction de l'informatique
Maritimes Region, DFO | Région des Maritimes, MPO
E-Mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
-----Original Message-----
From: Streeter, Lerone A LBX [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, May 03, 2001 3:27 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: might be really old topic, but please take a
look
briefly:
our choice was oracle/NT, based mainly on division/corporate
direction which
was based on the strengths of oracle. widely installed, industry
leader,
robust platform.
NT was a no-brainer; the majority of our knowledge is NT. price and
complexity were considered also, even though you have more control
over
*nix, the price of boxii to run it on as well as the cost of
training and
associated learning curve made *nix an unattractive option.
our user base is small-to-medium so an NT solution should suffice,
if we
were larger or more widely dispersed or web based; we'd look harder
at *nix.
remember i said brief.
===========================================
Lerone Streeter
System Analyst
Abbott LBG
[EMAIL PROTECTED]
===========================================
-----Original Message-----
Sent: Thursday, May 03, 2001 1:51 PM
To: Multiple recipients of list ORACLE-L
Oh, ha! that is an old one:
Oracle on Unix is the "only" choice.
No need to research at all! Just go out and buy one!
:)
Ross
p.s. give us more info, and you'll get a higher quality answer. GIGO
|| -----Original Message-----
|| From: Leslie Lu [mailto:[EMAIL PROTECTED]]
|| Sent: Thursday, May 03, 2001 1:37 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: Q: might be really old topic, but please take a look
||
||
|| Probably this has been posed million times, but I
|| really like to know. We'll have a meeting about this
|| in our company, and I'd love to contribute someting.
|| Any idea on the following issue, any link, paper, etc,
|| will be greatly appreciated.
||
|| pros and cons of
||
|| 1. Oracle vs Sybase
||
|| 2. Unix vs NT
||
||
|| Leslie
||
|| __________________________________________________
|| Do You Yahoo!?
|| Yahoo! Auctions - buy the things you want at great prices
|| http://auctions.yahoo.com/
|| --
|| Please see the official ORACLE-L FAQ: http://www.orafaq.com
|| --
|| Author: Leslie Lu
|| INET: [EMAIL PROTECTED]
||
|| Fat City Network Services -- (858) 538-5051 FAX: (858)
538-5051
|| San Diego, California -- Public Internet access /
|| Mailing Lists
||
--------------------------------------------------------------------
|| To REMOVE yourself from this mailing list, send an E-Mail message
|| to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
in
|| the message BODY, include a line containing: UNSUB ORACLE-L
|| (or the name of mailing list you want to be removed from). You
may
|| also send the HELP command for other information (like
subscribing).
||
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Streeter, Lerone A LBX
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing
Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Boivin, Patrice J
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
