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.

ASA to ASE

3 posts in General Discussion Last posting was on 2012-03-08 07:03:07.0Z
Larry Combs Posted on 2010-02-05 16:33:25.0Z
Sender: 72b9.4b6c475a.1804289383@sybase.com
From: Larry Combs
Newsgroups: ianywhere.public.general
Subject: ASA to ASE
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4b6c4855.72ca.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 5 Feb 2010 08:33:25 -0800
X-Trace: forums-1-dub 1265387605 10.22.241.41 (5 Feb 2010 08:33:25 -0800)
X-Original-Trace: 5 Feb 2010 08:33:25 -0800, 10.22.241.41
Lines: 7
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7884
Article PK: 6917

We are currently running SQL Anywhere 11 and our
organization will soon require us to modifiy our
PowerBuilder application to use Common Access Cards and PKI.
We have been told by our DBA's that ASA will not support PKI
and we would have to go to ASE. What problems, if any, will
we have migrating to ASE and what difficulties, if any, will
we run into?


Breck Carter [TeamSybase] Posted on 2010-02-06 11:13:22.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__breck.carter@gmail.com>
Newsgroups: ianywhere.public.general
Subject: Re: ASA to ASE
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__breck.carter@gmail.com
Message-ID: <ooiqm59gptcfvi6kr4u56vth7cf5gm52ct@4ax.com>
References: <4b6c4855.72ca.1681692777@sybase.com>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 6 Feb 2010 03:13:22 -0800
X-Trace: forums-1-dub 1265454802 10.22.241.152 (6 Feb 2010 03:13:22 -0800)
X-Original-Trace: 6 Feb 2010 03:13:22 -0800, vip152.sybase.com
Lines: 52
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7885
Article PK: 6916


On 5 Feb 2010 08:33:25 -0800, Larry Combs wrote:

>We are currently running SQL Anywhere 11 and our
>organization will soon require us to modifiy our
>PowerBuilder application to use Common Access Cards and PKI.
>We have been told by our DBA's that ASA will not support PKI
>and we would have to go to ASE. What problems, if any, will
>we have migrating to ASE and what difficulties, if any, will
>we run into?

May I have a word with your DBAs? That word would be, try reading the
Help before answering life-altering questions.

http://dcx.sybase.com/1101en/dbadmin_en11/ml-tls-s-5814428.html

Yes, SQL Anywhere has public key encryption, and has had it for many
years.

In fact, most claims that "ASE has feature X but SQL Anywhere does
not" are completely false... SQL Anywhere is far more feature-rich
than ASE has ever been or ever will be. New features usually come to
SQL Anywhere years before ASE. This fact comes as a complete surprise
to most ASE DBAs who, like Oracle DBAs or Microsoft SQL Server DBAs,
generally live in cocoons of product-specific ignorance.

Now, to answer your actual question...

>What problems, if any, will
>we have migrating to ASE and what difficulties, if any, will
>we run into?

...depending on which features of SQL Anywhere you have used, that are
NOT SUPPORTED by ASE, you may have enormous problems. It's far easier
to go in the other direction, SQL Anywhere has built-in features for
migrating from ASE.

But... you may have no problems, without knowing a lot more about your
application it is impossible to tell. What version of ASE are you
using? New versions are slowly getting better but older versions are
truly awful, feature-wise.

Breck


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

SQLA questions and answers: http://sqla.stackexchange.com

RisingRoad helps SQL Anywhere developers make better databases
http://www.risingroad.com/
Breck.Carter at gmail


°²ÓÚÏÖ×´ Posted on 2012-03-08 07:03:07.0Z
From: "°²ÓÚÏÖ×´" <wxf596380084@sina.com>
Newsgroups: ianywhere.public.general
References: <4b6c4855.72ca.1681692777@sybase.com>
Subject: Re: ASA to ASE
Lines: 11
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3598
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4f5859ab$1@forums-1-dub>
Date: 7 Mar 2012 23:03:07 -0800
X-Trace: forums-1-dub 1331190187 10.22.241.152 (7 Mar 2012 23:03:07 -0800)
X-Original-Trace: 7 Mar 2012 23:03:07 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:8165
Article PK: 7178

you are tolking about access?
<Larry Combs> дÈëÏûÏ¢ÐÂÎÅ:4b6c4855.72ca.1681692777@sybase.com...

> We are currently running SQL Anywhere 11 and our
> organization will soon require us to modifiy our
> PowerBuilder application to use Common Access Cards and PKI.
> We have been told by our DBA's that ASA will not support PKI
> and we would have to go to ASE. What problems, if any, will
> we have migrating to ASE and what difficulties, if any, will
> we run into?