Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Differences between ASE and SQL Anywhere

2,560 views
Skip to first unread message

Hassan

unread,
Feb 19, 2008, 2:03:52 AM2/19/08
to
When would I use ASE vs SQL Anywhere ? Is there any link to the differences
?


Josh Savill

unread,
Feb 19, 2008, 11:33:03 AM2/19/08
to
Hassan wrote:
> When would I use ASE vs SQL Anywhere ? Is there any link to the
> differences ?
>
>

ASE and SQL Anywhere have similarity in that they are both
high-performance database management systems.

SQL Anywhere databases are designed for a full range of functionality
including enterprise servers, embedded applications, desktop servers,
remote offices, and mobile applications. The SQL Anywhere database is
designed to be self managing, requiring no DBA to constantly maintain
the database system.

The SQL Anywhere database is light weight, but still offers full
enterprise features such as:
-High Availability
-Database Clustering
-Snapshot Isolation
-Materialized Views
-Built-in Web Services Server
-Self-tuning Query Optimizer

ASE is a fully featured enterprise database server designed specifically
for mission-critical data management systems for taming the
information explosion.

ASE offers features such as:
-High Availability
-Encrypted Columns
-Advanced Security
-Distributed Transactions
-Content Management
-Data Partitioning

ASE:
http://www.sybase.com/products/databasemanagement/adaptiveserverenterprise

SQL Anywhere: http://www.sybase.com/products/databasemanagement/sqlanywhere

--
Joshua Savill
Sybase iAnywhere - Product Manager

Breck Carter [sqlanywhere.blogspot.com]

unread,
Feb 20, 2008, 8:31:53 AM2/20/08
to
On Mon, 18 Feb 2008 23:03:52 -0800, "Hassan" <has...@test.com> wrote:

>When would I use ASE vs SQL Anywhere ? Is there any link to the differences
>?

Some more differences:

Everything is in the box with SQL Anywere. For example, if you want to
replicate data between Oracle and ASE, you have to buy ASE, then you
have to buy Replication Server, then you have to buy the Oracle
version of something call "Replication Server Options". With SQL
Anywhere, MobiLink is in the box, and so is the interface for Oracle.
And the docs are all in one Help file too.

SQL Anywhere is a lot cheaper: purchase price, licensing fees, AND the
price you won't have to pay for all the technical support. Especially
because (see above) you only have one thing to buy.

Breck

--
Breck Carter http://sqlanywhere.blogspot.com/

RisingRoad SQL Anywhere and MobiLink Professional Services
breck....@risingroad.com

Josh Savill

unread,
Feb 21, 2008, 11:29:05 AM2/21/08
to
Hassan wrote:
> When would I use ASE vs SQL Anywhere ? Is there any link to the
> differences ?
>
>

Breck Carter's written a good perspective on SQL Anywhere verses ASE
enterprise use here:
http://sqlanywhere.blogspot.com/2008/02/todays-client-question-sql-anywhere-vs.html

BlogSpot: http://sqlanywhere.blogspot.com/

0 new messages