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 Migration

7 posts in General Discussion Last posting was on 2002-10-02 17:35:51.0Z
Fred_Massey Posted on 2002-10-01 00:01:44.0Z
From: Fred_Massey
Date: Mon, 30 Sep 2002 20:01:44 -0400
Newsgroups: ianywhere.public.general
Subject: ASA to ASE Migration
Message-ID: <DF221390C918FE9E000028A885256C45.000028B885256C45@webforums>
Lines: 7
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:579
Article PK: 2393

We use SqlAnywhere (ASA 7.0), and have done substantial programing of the
database in WatcomSql as opposed T-SQL. We want to have the flexibility of
going either ASA or ASE.

Will the two languages converge at some point?
Thanks
Fred


Robert Waywell Posted on 2002-10-01 13:13:16.0Z
From: "Robert Waywell" <rwaywell@ianywhere.com>
References: <DF221390C918FE9E000028A885256C45.000028B885256C45@webforums>
Subject: Re: ASA to ASE Migration
Date: Tue, 1 Oct 2002 09:13:16 -0400
Lines: 40
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
Message-ID: <pWr3R5UaCHA.313@forums.sybase.com>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: 172.31.143.74
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.general:578
Article PK: 2394

ASE is continuing to improve it's support of ANSI standard syntax. ASA
also supports most of the the TSQL dialect. You can certainly write code
that will work equally well on either platform. However, if you have not
started out with that design goal then you should expect to treat any move
from ASA to ASE as a migration.

That said, under what conditions would you expect to move to ASE?

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

<Fred_Massey> wrote in message
news:DF221390C918FE9E000028A885256C45.000028B885256C45@webforums...
> We use SqlAnywhere (ASA 7.0), and have done substantial programing of the
> database in WatcomSql as opposed T-SQL. We want to have the flexibility of
> going either ASA or ASE.
>
> Will the two languages converge at some point?
> Thanks
> Fred


Fred_Massey Posted on 2002-10-01 21:48:29.0Z
From: Fred_Massey
Date: Tue, 1 Oct 2002 17:48:29 -0400
Newsgroups: ianywhere.public.general
Subject: Re: ASA to ASE Migration
Message-ID: <AF799252772C7C7F0077CBB185256C45.004D4C0185256C45@webforums>
References: <DF221390C918FE9E000028A885256C45.000028B885256C45@webforums> <pWr3R5UaCHA.313@forums.sybase.com>
Lines: 7
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:577
Article PK: 2395

We have some customers who have large installations with 80 users and
databases approaching 1GB.

Is there a point where number of users and size of database will
necessitate a ASE level solution? Your input is appreciated.
Thanks,
Fred


Robert Waywell Posted on 2002-10-02 13:23:25.0Z
From: "Robert Waywell" <rwaywell@ianywhere.com>
References: <DF221390C918FE9E000028A885256C45.000028B885256C45@webforums> <pWr3R5UaCHA.313@forums.sybase.com> <AF799252772C7C7F0077CBB185256C45.004D4C0185256C45@webforums>
Subject: Re: ASA to ASE Migration
Date: Wed, 2 Oct 2002 09:23:25 -0400
Lines: 38
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
Message-ID: <7GOQojhaCHA.198@forums.sybase.com>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: 172.31.143.74
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.general:576
Article PK: 2392

We have production customers with 60+ gigabyte databases. We also have
reference customers with 100's of users. You might want to take a look at
the sybase.public.sqlanywhere.general newsgroup which is more directly
focused on ASA. Questions of scalability have come up there fairly
regularly.

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

<Fred_Massey> wrote in message
news:AF799252772C7C7F0077CBB185256C45.004D4C0185256C45@webforums...
> We have some customers who have large installations with 80 users and
> databases approaching 1GB.
>
> Is there a point where number of users and size of database will
> necessitate a ASE level solution? Your input is appreciated.
> Thanks,
> Fred


Scott Kruer <skruer Posted on 2002-10-02 13:47:21.0Z
Subject: Re: ASA to ASE Migration
From: Scott Kruer <skruer@SPAM_SPAM_GO_AWAY_sybase.com>
References: <DF221390C918FE9E000028A885256C45.000028B885256C45@webforums> <pWr3R5UaCHA.313@forums.sybase.com> <AF799252772C7C7F0077CBB185256C45.004D4C0185256C45@webforums> <7GOQojhaCHA.198@forums.sybase.com>
Organization: iAnywhere
Message-ID: <Xns929B6126274ECskruersybasecom@199.93.177.77>
User-Agent: Xnews/L5
Newsgroups: ianywhere.public.general
Date: Wed, 02 Oct 2002 09:47:21 -0400
Lines: 47
NNTP-Posting-Host: 158.159.8.13
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.general:575
Article PK: 2396

In addition to Rob's comment... factor in the learning curve of moving
from ASA to ASE... two completely different animals with respect to
maintainability. We like happy customers.... and happy customers use ASE
;)

Scott Kruer
Senior Consultant
Certified ASA Developer Version 8
Sybase - iAnywhere Solutions
Professional Services
Please only post to the newsgroup


"Robert Waywell" <rwaywell@ianywhere.com> wrote in
news:7GOQojhaCHA.198@forums.sybase.com:

> We have production customers with 60+ gigabyte databases. We also have
> reference customers with 100's of users. You might want to take a look
> at the sybase.public.sqlanywhere.general newsgroup which is more
> directly focused on ASA. Questions of scalability have come up there
> fairly regularly.
>
> --
> -----------------------------------------------
> Robert Waywell
> Sybase Adaptive Server Anywhere Developer - Version 8
> Sybase Certified Professional
>
> Sybase's iAnywhere Solutions
>
> Please respond ONLY to newsgroup
>
> EBF's and Patches: http://downloads.sybase.com
> choose SQL Anywhere Studio >> change 'time frame' to all
>
> To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm
>
> SQL Anywhere Studio Supported Platforms and Support Status
> http://my.sybase.com/detail?id=1002288
>
> Whitepapers, TechDocs, and bug fixes are all available through the
> iAnywhere Developer Community at www.ianywhere.com/developer
>
> <Fred_Massey> wrote in message
> news:AF799252772C7C7F0077CBB185256C45.004D4C0185256C45@webforums...
>> We have some customers who have large installations with 80 users and
>> databases approaching 1GB.
>>
>> Is there a point where number of users and size of database will
>> necessitate a ASE level solution? Your input is appreciated.
>> Thanks,
>> Fred
>
>


Scott Kruer <skruer Posted on 2002-10-02 15:28:35.0Z
Subject: Re: ASA to ASE Migration
From: Scott Kruer <skruer@SPAM_SPAM_GO_AWAY_sybase.com>
References: <DF221390C918FE9E000028A885256C45.000028B885256C45@webforums> <pWr3R5UaCHA.313@forums.sybase.com> <AF799252772C7C7F0077CBB185256C45.004D4C0185256C45@webforums> <7GOQojhaCHA.198@forums.sybase.com> <Xns929B6126274ECskruersybasecom@199.93.177.77>
Organization: iAnywhere
Message-ID: <Xns929B724F99BFCskruersybasecom@199.93.177.77>
User-Agent: Xnews/L5
Newsgroups: ianywhere.public.general
Date: Wed, 02 Oct 2002 11:28:35 -0400
Lines: 55
NNTP-Posting-Host: 158.159.8.30
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.general:574
Article PK: 2397

I meant to say ASA!!!!!

We like happy customers.... and happy customers use ASA ;)

I couldn't type to save my life.....

Scott Kruer <skruer@SPAM_SPAM_GO_AWAY_sybase.com> wrote in
news:Xns929B6126274ECskruersybasecom@199.93.177.77:

> In addition to Rob's comment... factor in the learning curve of moving
> from ASA to ASE... two completely different animals with respect to
> maintainability. We like happy customers.... and happy customers use
ASE
> ;)
>
> Scott Kruer
> Senior Consultant
> Certified ASA Developer Version 8
> Sybase - iAnywhere Solutions
> Professional Services
> Please only post to the newsgroup
>
>
> "Robert Waywell" <rwaywell@ianywhere.com> wrote in
> news:7GOQojhaCHA.198@forums.sybase.com:
>
>> We have production customers with 60+ gigabyte databases. We also have
>> reference customers with 100's of users. You might want to take a look
>> at the sybase.public.sqlanywhere.general newsgroup which is more
>> directly focused on ASA. Questions of scalability have come up there
>> fairly regularly.
>>
>> --
>> -----------------------------------------------
>> Robert Waywell
>> Sybase Adaptive Server Anywhere Developer - Version 8
>> Sybase Certified Professional
>>
>> Sybase's iAnywhere Solutions
>>
>> Please respond ONLY to newsgroup
>>
>> EBF's and Patches: http://downloads.sybase.com
>> choose SQL Anywhere Studio >> change 'time frame' to all
>>
>> To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm
>>
>> SQL Anywhere Studio Supported Platforms and Support Status
>> http://my.sybase.com/detail?id=1002288
>>
>> Whitepapers, TechDocs, and bug fixes are all available through the
>> iAnywhere Developer Community at www.ianywhere.com/developer
>>
>> <Fred_Massey> wrote in message
>> news:AF799252772C7C7F0077CBB185256C45.004D4C0185256C45@webforums...
>>> We have some customers who have large installations with 80 users and
>>> databases approaching 1GB.
>>>
>>> Is there a point where number of users and size of database will
>>> necessitate a ASE level solution? Your input is appreciated.
>>> Thanks,
>>> Fred
>>
>>
>


Fred_Massey Posted on 2002-10-02 17:35:51.0Z
From: Fred_Massey
Date: Wed, 2 Oct 2002 13:35:51 -0400
Newsgroups: ianywhere.public.general
Subject: Re: ASA to ASE Migration
Message-ID: <2DD6EC475A284A730060AAC485256C46.0058601685256C46@webforums>
References: <DF221390C918FE9E000028A885256C45.000028B885256C45@webforums> <pWr3R5UaCHA.313@forums.sybase.com> <AF799252772C7C7F0077CBB185256C45.004D4C0185256C45@webforums> <7GOQojhaCHA.198@forums.sybase.com> <Xns929B6126274ECskruersybasecom@199.93.177.77> <Xns929B724F99BFCskruersybasecom@199.93.177.77>
Lines: 5
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:573
Article PK: 2390

Okay I'm impressed.

I'm going to open a separate thread on some performance issues.
Thanks
Fred