Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Sybase ASA vs MS Access vs MS SQL Server

Re: Sybase ASA vs MS Access vs MS SQL Server

From: Terry Dykstra [TeamPS] <no_spam_tdykstra_at_cfol.ab.ca>
Date: 1998/09/01
Message-ID: <35ec0a1a.0@news.cadvision.com>

Go the Sybase newsgroups. 5.5 offers stored procedures. 6 is Java enabled. forums.powersoft.com: sybase.public.sqlanywhere.general

--
Terry Dykstra [TeamPS]
Canadian Forest Oil Ltd.

Hatheway, Darwin L wrote in message <6sep23$3um$1_at_sulu.mmm.com>...

>Does it support (take advantage of) SMP?
>
>I installed SQL Anywhere and tinkered with it a while back and liked it
>reasonably well.
>
>It does seem to be about as easy as MS SQL Server to set up (more difficult
>to do the install but no DB "device" mgmt evens the score). I thought it
>was a little more difficult to configure the clients. It was very
>trouble-free. I was using V5.5. V6, if it offers stored procedures and
>simplifies client configuration, would be very attractive to me.
>
>Before I bought in, though, I'd like to know if it would take advantage of
a
>quad-SMP system (easiest way to "scale" in the NT world) and how big a DB
it
>would support. I did check their web site but saw no mention of SMP
>support, so you might want to ask one of their sales reps or consultants.
>
>HTH
>
>PS: The feature I liked best was the ability to read a .SQL file into
the
>command processor and do parameterized substitution into the SQL in the
>file. That's a feature I'd really like to see in MS' toolset (sure, Stored
>Procedures are great but SP's require more DBA time and attention to
>manage).
>
>Terry Dykstra wrote in message <35e6217f.0_at_news.cadvision.com>...
>>It's very stable. I have SQLAnywhere (which now is called ASA) running
on
>>a NT server. I basically don't have to do any maintenance on it. It just
>>runs and runs and runs. And the memory footprint is absolutely minimal.
>>The latest version is going Java. It doesn't have all the bells &
whistles
>>of System 11. But you have all your 'regular' sql, stored procedures,
>>triggers etc.
>>
>>Terry Dykstra (TeamPS)
>>Canadian Forest Oil Ltd.
>>
>>Ng K C Paul wrote in message <6s51ds$nmo$2_at_imsp009a.netvigator.com>...
>>>Sybase ASA is much scalable than Microsoft Products at present moment.
>>>It can run from Windows CE to Windows 9x to Windows NT to UNIX.
>>>
>>>Information Anywhere!! Mobile and Embedded Computing Server!!
>>>
>>>Scott Hodson (shodson_at_home.com) wrote:
>>>: This is a multi-part message in MIME format.
>>>:
>>>: ------=_NextPart_000_0016_01BDD1A9.46E20E20
>>>: Content-Type: text/plain;
>>>: charset="iso-8859-1"
>>>: Content-Transfer-Encoding: quoted-printable
>>>:
>>>: I am consulting with a client and we've been using MS SQL Server on his
=
>>>: project. I am very comfortable with MS SQL Server and Sybase System XI
=
>>>: but he comes from a MS Access background and finds SQL Server very =
>>>: confusing and frustrating (transaction logs, segments, etc.) having =
>>>: become accustomed to Access's ease of use and very GUI-based DB =
>>>: management tools. We moved to SQL server because his data volume and =
>>>: activity will increase 10-fold in the next year and it is more
scaleable =
>>>: and reliable than Access.
>>>:
>>>: He head about Sybase ASA and how easy to use it was from some friends =
>>>: but I want to know where does it fall short compared to say System XI
or =
>>>: MS SQL Server. It sounds like a MS Access on steroids but I'm not
sure. =
>>>: Is the DB stable, does it corrupt? Is it fast? Scalable?=20
>>>:
>>>: I was wondering how ASA compares with Access and MS SQL Server. I have
=
>>>: a feeling it's somewhere in between the two. It seems easier to use =
>>>: than SQL Server but I'm not sure how scalable it is.
>>>:
>>>: ------=_NextPart_000_0016_01BDD1A9.46E20E20
>>>: Content-Type: text/html;
>>>: charset="iso-8859-1"
>>>: Content-Transfer-Encoding: quoted-printable
>>>:
>>>: <!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
>>>: <HTML>
>>>: <HEAD>
>>>:
>>>: <META content=3Dtext/html;charset=3Diso-8859-1 =
>>>: http-equiv=3DContent-Type>
>>>: <META content=3D'"MSHTML 4.72.3110.7"' name=3DGENERATOR>
>>>: </HEAD>
>>>: <BODY bgColor=3D#ffffff>
>>>: <DIV><FONT color=3D#000000 size=3D2>I am consulting with a client and =
>>>: we've been=20
>>>: using MS SQL Server on his project.&nbsp; I am very comfortable with MS
=
>>>: SQL=20
>>>: Server and Sybase System XI but he comes from a MS Access background
and =
>>>: finds=20
>>>: SQL Server very confusing and frustrating (transaction logs, segments,
=
>>>: etc.)=20
>>>: having become accustomed to Access's ease of use and very GUI-based
DB=20
>>>: management tools.&nbsp; We moved to SQL server because his data volume
=
>>>: and=20
>>>: activity will increase 10-fold in the next year and it is more
scaleable =
>>>: and=20
>>>: reliable than Access.</FONT></DIV>
>>>: <DIV><FONT color=3D#000000 size=3D2></FONT>&nbsp;</DIV>
>>>: <DIV><FONT color=3D#000000 size=3D2>He head about Sybase ASA and how =
>>>: easy to use it=20
>>>: was from some friends but I want to know where does it fall short =
>>>: compared to=20
>>>: say System XI or MS SQL Server.&nbsp; It sounds like a MS Access on =
>>>: steroids but=20
>>>: I'm not sure.&nbsp; Is the DB stable, does it corrupt?&nbsp; Is it =
>>>: fast?&nbsp;=20
>>>: Scalable? </FONT></DIV>
>>>: <DIV><FONT color=3D#000000 size=3D2></FONT><FONT color=3D#000000=20
>>>: size=3D2></FONT>&nbsp;</DIV>
>>>: <DIV><FONT color=3D#000000 size=3D2>I was wondering how ASA compares =
>>>: with Access and=20
>>>: MS SQL Server.&nbsp; I have a feeling it's somewhere in between the =
>>>: two.&nbsp;=20
>>>: It seems easier to use than SQL Server but I'm not sure how scalable
it=20
>>>: is.</FONT></DIV></BODY></HTML>
>>>:
>>>: ------=_NextPart_000_0016_01BDD1A9.46E20E20--
>>>:
>>
>>
>
>
>
>
>Opinions expressed herein are my own and may not represent those of my
employer.
>
Received on Tue Sep 01 1998 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US