Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

SQL Server or SQL Anywhere ?

8 posts in ,  General DiscussionNetware Windows NT Last posting was on 1997-08-25 16:19:01.0Z
mck Posted on 1997-08-14 18:32:41.0Z
From: mck@iag.net
Subject: SQL Server or SQL Anywhere ?
Date: Thu, 14 Aug 1997 18:32:41 GMT
Message-ID: <33f34f0d.66907968@forums.powersoft.com>
X-Newsreader: Forte Agent 1.5/32.451
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlanywhere.general,sybase.public.sqlserver.netware,sybase.public.sqlserver.nt
Lines: 18
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlanywhere.general:2807 sybase.public.sqlserver.netware:187 sybase.public.sqlserver.nt:463
Article PK: 880720

I am looking for recommendations/opinions from Sybase types who have
use both SQL Server XI (Netware or NT) ad SQL Anyhwere, as a workgroup
database server. Our data set (current -> projected near future) is as
follows:

Single server, maybe SMP in future.

Tables: 35 -> 50
Records: 300K -> 2M (per table;large tables only - many are small)
DB Space: 500MB -> 2GB (this number may grow if system becomes used
for more business processes.)
Users: 30 -> 50 (maybe 100 in the far future)
Queries: Return 30-200 records on average, occasionally up to 2000.
Queries often involve selections from 4-6 tables.


Need more info? Let me know. Thanks for your help.


Jim Egan Posted on 1997-08-18 17:52:45.0Z
From: "Jim Egan" <eganjp@compuserve.com>
Subject: Re: SQL Server or SQL Anywhere ?
References: <33f34f0d.66907968@forums.powersoft.com>
Organization: Dealer Solutions, LLC
Message-ID: <01bcac08$e2decf60$3aa3b9ce@jegan.carman.com>
X-Newsreader: Microsoft Internet News 4.70.1155
Newsgroups: sybase.public.sqlanywhere.general,sybase.public.sqlserver.netware,sybase.public.sqlserver.nt
Date: Mon, 18 Aug 1997 13:52:45 -0400
Lines: 26
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlanywhere.general:2806 sybase.public.sqlserver.netware:186 sybase.public.sqlserver.nt:462
Article PK: 842523

Sounds like a real good fit for SQL Anywhere. I currently run on an NT SMP
machine with a 1.1 gig database and it runs quite well.
--
Jim Egan [TeamPS]
Dealer Solutions, LLC
Houston, TX

mck@iag.net wrote in article <33f34f0d.66907968@forums.powersoft.com>...
> I am looking for recommendations/opinions from Sybase types who have
> use both SQL Server XI (Netware or NT) ad SQL Anyhwere, as a workgroup
> database server. Our data set (current -> projected near future) is as
> follows:
>
> Single server, maybe SMP in future.
>
> Tables: 35 -> 50
> Records: 300K -> 2M (per table;large tables only - many are small)
> DB Space: 500MB -> 2GB (this number may grow if system becomes used
> for more business processes.)
> Users: 30 -> 50 (maybe 100 in the far future)
> Queries: Return 30-200 records on average, occasionally up to 2000.
> Queries often involve selections from 4-6 tables.
>
>
> Need more info? Let me know. Thanks for your help.
>
>


Pramono Purnadi Posted on 1997-08-19 01:46:04.0Z
Message-ID: <33F8FADC.6A86@dnet.net.id>
Date: Tue, 19 Aug 1997 08:46:04 +0700
From: Pramono Purnadi <purnadi@dnet.net.id>
Reply-To: purnadi@dnet.net.id
X-Mailer: Mozilla 3.01 (Win95; I)
MIME-Version: 1.0
Subject: Re: SQL Server or SQL Anywhere ?
References: <33f34f0d.66907968@forums.powersoft.com> <01bcac08$e2decf60$3aa3b9ce@jegan.carman.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlanywhere.general,sybase.public.sqlserver.netware,sybase.public.sqlserver.nt
Lines: 31
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlanywhere.general:2804 sybase.public.sqlserver.netware:184 sybase.public.sqlserver.nt:460
Article PK: 880715

Sound like SQL Anywhere an excellent database. When do we need to
upgrade to more expensive database such as Oracle or Sybase Server ?

>Jim Egan wrote:
>
> Sounds like a real good fit for SQL Anywhere. I currently run on an NT SMP
> machine with a 1.1 gig database and it runs quite well.
> --
> Jim Egan [TeamPS]
> Dealer Solutions, LLC
> Houston, TX
>
> mck@iag.net wrote in article <33f34f0d.66907968@forums.powersoft.com>...
> > I am looking for recommendations/opinions from Sybase types who have
> > use both SQL Server XI (Netware or NT) ad SQL Anyhwere, as a workgroup
> > database server. Our data set (current -> projected near future) is as
> > follows:
> >
> > Single server, maybe SMP in future.
> >
> > Tables: 35 -> 50
> > Records: 300K -> 2M (per table;large tables only - many are small)
> > DB Space: 500MB -> 2GB (this number may grow if system becomes used
> > for more business processes.)
> > Users: 30 -> 50 (maybe 100 in the far future)
> > Queries: Return 30-200 records on average, occasionally up to 2000.
> > Queries often involve selections from 4-6 tables.
> >
> >
> > Need more info? Let me know. Thanks for your help.
> >
> >


Jim Egan Posted on 1997-08-20 17:50:48.0Z
From: "Jim Egan" <eganjp@compuserve.com>
Subject: Re: SQL Server or SQL Anywhere ?
References: <33f34f0d.66907968@forums.powersoft.com> <01bcac08$e2decf60$3aa3b9ce@jegan.carman.com> <33F8FADC.6A86@dnet.net.id>
Organization: Dealer Solutions, LLC
Message-ID: <01bcad9a$682a4220$3aa3b9ce@jegan.carman.com>
X-Newsreader: Microsoft Internet News 4.70.1155
Newsgroups: sybase.public.sqlanywhere.general,sybase.public.sqlserver.netware,sybase.public.sqlserver.nt
Date: Wed, 20 Aug 1997 13:50:48 -0400
Lines: 13
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlanywhere.general:2801 sybase.public.sqlserver.netware:181 sybase.public.sqlserver.nt:457
Article PK: 842522

That's a difficult question to answer without knowing your application and
database. Any figures I would propose would be based on systems I have
constructed and could vary quite widely from what you have.
--
Jim Egan [TeamPS]
Dealer Solutions, LLC
Houston, TX

Pramono Purnadi <purnadi@dnet.net.id> wrote in article
<33F8FADC.6A86@dnet.net.id>...
> Sound like SQL Anywhere an excellent database. When do we need to
> upgrade to more expensive database such as Oracle or Sybase Server ?


Jim Kist Posted on 1997-08-19 12:17:38.0Z
From: "Jim Kist" <kist@buffnet.net>
Subject: Re: SQL Server or SQL Anywhere ?
References: <33f34f0d.66907968@forums.powersoft.com> <01bcac08$e2decf60$3aa3b9ce@jegan.carman.com> <33F8FADC.6A86@dnet.net.id>
Message-ID: <01bcaca2$af4e3970$09006480@dev>
X-Newsreader: Microsoft Internet News 4.70.1161
Newsgroups: sybase.public.sqlanywhere.general,sybase.public.sqlserver.netware,sybase.public.sqlserver.nt
Date: Tue, 19 Aug 1997 08:17:38 -0400
Lines: 39
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlanywhere.general:2803 sybase.public.sqlserver.netware:183 sybase.public.sqlserver.nt:459
Article PK: 880716

I read in the September 1997 issue of Windows magazine that SQL Anywhere
and Sybase System 11 cost the same per user. Is this information correct?

Pramono Purnadi <purnadi@dnet.net.id> wrote in article
<33F8FADC.6A86@dnet.net.id>...
> Sound like SQL Anywhere an excellent database. When do we need to
> upgrade to more expensive database such as Oracle or Sybase Server ?
>
>
> >Jim Egan wrote:
> >
> > Sounds like a real good fit for SQL Anywhere. I currently run on an NT
SMP
> > machine with a 1.1 gig database and it runs quite well.
> > --
> > Jim Egan [TeamPS]
> > Dealer Solutions, LLC
> > Houston, TX
> >
> > mck@iag.net wrote in article
<33f34f0d.66907968@forums.powersoft.com>...
> > > I am looking for recommendations/opinions from Sybase types who have
> > > use both SQL Server XI (Netware or NT) ad SQL Anyhwere, as a
workgroup
> > > database server. Our data set (current -> projected near future) is
as
> > > follows:
> > >
> > > Single server, maybe SMP in future.
> > >
> > > Tables: 35 -> 50
> > > Records: 300K -> 2M (per table;large tables only - many are small)
> > > DB Space: 500MB -> 2GB (this number may grow if system becomes used
> > > for more business processes.)
> > > Users: 30 -> 50 (maybe 100 in the far future)
> > > Queries: Return 30-200 records on average, occasionally up to 2000.
> > > Queries often involve selections from 4-6 tables.
> > >
> > >
> > > Need more info? Let me know. Thanks for your help.
> > >
> > >
>


Bruce Milton Posted on 1997-08-19 17:40:29.0Z
From: "Bruce Milton" <bmilton@sybase.com>
Subject: Re: SQL Server or SQL Anywhere ?
References: <33f34f0d.66907968@forums.powersoft.com> <01bcac08$e2decf60$3aa3b9ce@jegan.carman.com> <33F8FADC.6A86@dnet.net.id> <01bcaca2$af4e3970$09006480@dev>
Organization: Sybase Inc.
Message-ID: <01bcaccf$1aba8390$768c1fac@bmilton-pc>
X-Newsreader: Microsoft Internet News 4.70.1161
Newsgroups: sybase.public.sqlanywhere.general,sybase.public.sqlserver.netware,sybase.public.sqlserver.nt
Date: Tue, 19 Aug 1997 13:40:29 -0400
Lines: 51
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlanywhere.general:2802 sybase.public.sqlserver.netware:182 sybase.public.sqlserver.nt:458
Article PK: 880713

This information is incorrect.

SQL Anywhere Base is $299 US
Per seat license is $119 US

SQL Server Base is $995 US
Per seat is $195 US

So as you can see there is a difference. The other costs would be
attributed to hardware.
--
Bruce Milton
Sybase Workplace Technical Support
bmilton@sybase.com

Jim Kist <kist@buffnet.net> wrote in article
<01bcaca2$af4e3970$09006480@dev>...
> I read in the September 1997 issue of Windows magazine that SQL Anywhere
> and Sybase System 11 cost the same per user. Is this information correct?
>
>
> Pramono Purnadi <purnadi@dnet.net.id> wrote in article
> <33F8FADC.6A86@dnet.net.id>...
> > Sound like SQL Anywhere an excellent database. When do we need to
> > upgrade to more expensive database such as Oracle or Sybase Server ?
> >
> >
> > >Jim Egan wrote:
> > >
> > > Sounds like a real good fit for SQL Anywhere. I currently run on an
NT
> SMP
> > > machine with a 1.1 gig database and it runs quite well.
> > > --
> > > Jim Egan [TeamPS]
> > > Dealer Solutions, LLC
> > > Houston, TX
> > >
> > > mck@iag.net wrote in article
> <33f34f0d.66907968@forums.powersoft.com>...
> > > > I am looking for recommendations/opinions from Sybase types who
have
> > > > use both SQL Server XI (Netware or NT) ad SQL Anyhwere, as a
> workgroup
> > > > database server. Our data set (current -> projected near future) is
> as
> > > > follows:
> > > >
> > > > Single server, maybe SMP in future.
> > > >
> > > > Tables: 35 -> 50
> > > > Records: 300K -> 2M (per table;large tables only - many are small)
> > > > DB Space: 500MB -> 2GB (this number may grow if system becomes used
> > > > for more business processes.)
> > > > Users: 30 -> 50 (maybe 100 in the far future)
> > > > Queries: Return 30-200 records on average, occasionally up to
2000.
> > > > Queries often involve selections from 4-6 tables.
> > > >
> > > >
> > > > Need more info? Let me know. Thanks for your help.
> > > >
> > > >
> >
>


Igor Rass Posted on 1997-08-25 16:19:01.0Z
Message-ID: <3401B075.14BA2DA6@ops.digitalnet.com>
Date: Mon, 25 Aug 1997 12:19:01 -0400
From: Igor Rass <igor@ops.digitalnet.com>
Organization: Digital Technologies Inc.
X-Mailer: Mozilla 4.01 [en] (Win95; I)
MIME-Version: 1.0
Subject: Re: SQL Server or SQL Anywhere ?
X-Priority: 3 (Normal)
References: <33f34f0d.66907968@forums.powersoft.com> <01bcac08$e2decf60$3aa3b9ce@jegan.carman.com> <33F8FADC.6A86@dnet.net.id> <01bcaca2$af4e3970$09006480@dev> <01bcaccf$1aba8390$768c1fac@bmilton-pc>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlanywhere.general,sybase.public.sqlserver.netware,sybase.public.sqlserver.nt
Lines: 21
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlanywhere.general:2800 sybase.public.sqlserver.netware:180 sybase.public.sqlserver.nt:456
Article PK: 880714

You should also add Sybase Technical Support fee for SQL Server! I don't
know current prices, but as far as I remember, 1 year ago it was 10% of
your license or $3000/year, whatever is greater...

Igor

Bruce Milton wrote:

> This information is incorrect.
>
> SQL Anywhere Base is $299 US
> Per seat license is $119 US
>
> SQL Server Base is $995 US
> Per seat is $195 US
>
> So as you can see there is a difference. The other costs would be
> attributed to hardware.
> --
> Bruce Milton
> Sybase Workplace Technical Support
> bmilton@sybase.com
>
> Jim Kist <kist@buffnet.net> wrote in article
> <01bcaca2$af4e3970$09006480@dev>...
> > I read in the September 1997 issue of Windows magazine that SQL
> Anywhere
> > and Sybase System 11 cost the same per user. Is this information
> correct?


Bruce Milton Posted on 1997-08-19 05:23:21.0Z
X-Newsreader: Microsoft Outlook Express 4.71.0544.0
From: "Bruce Milton" <bmilton@sybase.com>
References: <33f34f0d.66907968@forums.powersoft.com> <01bcac08$e2decf60$3aa3b9ce@jegan.carman.com>
Subject: Re: SQL Server or SQL Anywhere ?
Date: Tue, 19 Aug 1997 01:23:21 -0400
Lines: 43
X-MimeOLE: Produced By Microsoft MimeOLE Engine V4.71.0544.0
Message-ID: <ARohgdFr8GA.168@forums.powersoft.com>
Newsgroups: sybase.public.sqlanywhere.general,sybase.public.sqlserver.netware,sybase.public.sqlserver.nt
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlanywhere.general:2805 sybase.public.sqlserver.netware:185 sybase.public.sqlserver.nt:461
Article PK: 880717

Although SQL Anywhere is not SMP a-where, you will gain some benefit from
the operating system running in an SMP environment. Running SA in an SMP
environment has been identified as something that will be address in future
releases.

I agree with Jim, SA will be a nice fit for your projected size and use.
--
Bruce Milton
Sybase Workplace Technical Support
bmilton@sybase.com
Jim Egan wrote in article <01bcac08$e2decf60$3aa3b9ce@jegan.carman.com>...

>Sounds like a real good fit for SQL Anywhere. I currently run on an NT
SMP
>machine with a 1.1 gig database and it runs quite well.
>--
>Jim Egan [TeamPS]
>Dealer Solutions, LLC
>Houston, TX
>
>mck@iag.net wrote in article <33f34f0d.66907968@forums.powersoft.com>...
>> I am looking for recommendations/opinions from Sybase types who have
>> use both SQL Server XI (Netware or NT) ad SQL Anyhwere, as a workgroup
>> database server. Our data set (current -> projected near future) is as
>> follows:
>>
>> Single server, maybe SMP in future.
>>
>> Tables: 35 -> 50
>> Records: 300K -> 2M (per table;large tables only - many are small)
>> DB Space: 500MB -> 2GB (this number may grow if system becomes used
>> for more business processes.)
>> Users: 30 -> 50 (maybe 100 in the far future)
>> Queries: Return 30-200 records on average, occasionally up to 2000.
>> Queries often involve selections from 4-6 tables.
>>
>>
>> Need more info? Let me know. Thanks for your help.
>>
>>
>