Hello!

We have an app written for Access97 and now we want to scale to a
server. We are looking for a database with optimal perfomance and a
nice price. We have choose two databases, SQL Anywhere and Interbase.
SQL Anywhere is cheaper than Interbase but Interbase looks like more
robust.
We want to know your opinions and what is better database (perfomance,
scalability, etc).

It will be running on a P-II 300Mhz with 128MB, HD 4,1 GB with NT
Server 4.0. There will be 8 users (maybe more) and the database size
will be of 500Mb (aprox).

Thanks!

Hi, David!

I can't speak for interbase, as I have not used it, but SQL Anywhere is
working great for me.  I am upgrading an old Dbase IV app to C/S with SQLA,
and outside of bonehead problems due to my newness to the environment, it's
going great.  I'm using Delphi 3 with InfoPower components.  It's quick,
easy to use & configure, and their newsgroup is very helpful when I ask
stupid questions (this one is also, for that matter! : - >).

HTH,
Cyd

David Sancho <dsan...@databasedm.es> wrote in article
<35583b03.2663...@forums.borland.com>...

What is SQL Anywhere ?, is it the same as Sybase SQL Server ?

Later,
Paul

Paul,

No.  SQL Anywhere is Sybase's el-cheapo Client/Server package.  It is
"the-database-formerly-known-as-Watcom-SQL".  My company is just
starting to use it also (chosen over Interbase because of lower cost and
more reasonable liscencing) and we are very pleased with it thus far.
It is a step between an MS Access-type database and a full blown
enterprise class (like Oracle or Sybase SQL (Adaptive) Server) - but
closer to the enterprise.

HTH - Mike

Upsizing any application should work fairly well -- Access in particular
speaks SQL to begin with -- and I suspect that almost any server will
work as a target.  The best advice I can give you is to stick very close
to what MS says about upsizing.

Rumor also has it that Access is going to be jettisoning JET in an
upcoming release and using a true server on the back-end.  Can't say
that I blame them.  That's where I'm taking all my apps...

The only server I know about that really -doesn't- change, from the
smallest scale to the largest, is Interbase.  "Interbase is Interbase."

In article <35590E73.1...@primenet.com>,

--
|| Bjorn K. Nilssen      // http://home.sol.no/~bjoernk/  // mainly old 3D ||

Sundial Services

SQL Anywhere is SQL Anywhere.  Doesn't matter if you have a single user
on a single machine or 20 plus users on a distributed network (and/or
using remote access capability).  Database format is always the same.

You get all the "big boys" toys - ie procedures, updateable views,
remoting, triggers etc, etc, etc.

The thing you don't get is complexity. (Or fine-tuning ability as DBAs
would prefer to call it <g>).

I've used Oracle, InterBase and SQL Anywhere and for 90% of projects I've
been involved in I'd choose SQL Anywhere every time (the remaining 10%
would now be Sybase SQL Server - I HATE Oracle)

Thing is, when InterBase runs out of puff - you're stymied.  Upsizing is
difficult.  There is no "big brother" to turn to (and PLEASE don't try to
tell me that InterBase is a big brother - it's not)

When SQL Anywhere runs out of puff, you can upsize to Sybase SQL Server
(indeed, SQL Anywhere has had a whole load of extensions put in it to
emulate Sybase SQL Anywhere functionality and to make upsizing a simple
step)

In conclusion therefore, unless I misunderstand you, your quoted
statement is either misleading or incorrectly stated.

Derek Davidson
Get a FREE copy of DK's Audit Components for Delphi from my web site:
http://freespace.{*word*269}.net/d.davidson
Now Includes INFOPOWER Derived components and a demo

(Remove the x to EMail me : der...@mksoft.com)