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.

SQLAnywhere to ASE

10 posts in ,  Windows NT General Discussion Last posting was on 1999-12-10 03:25:25.0Z
Robert Strigl Posted on 1999-12-06 07:30:01.0Z
From: "Robert Strigl" <rkstrigl@hekru.net>
Subject: SQLAnywhere to ASE
Date: Mon, 6 Dec 1999 02:30:01 -0500
Lines: 11
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <UGel$x7P$GA.203@forums.sybase.com>
Newsgroups: sybase.public.sqlanywhere.general,sybase.public.sqlserver.nt
NNTP-Posting-Host: host-217.accel.net 207.164.195.217
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlanywhere.general:2826 sybase.public.sqlserver.nt:504
Article PK: 880735

Hi,

is there a utility to convert my existing SQLA5.0 database into an ASE
version database. I'm attempting to upgrade and looking for a simply way to
do so, if of course there is one..

thanks in advance, rks...


Robert Waywell Posted on 1999-12-06 13:40:38.0Z
From: "Robert Waywell" <rwaywell@sybase.com>
References: <UGel$x7P$GA.203@forums.sybase.com>
Subject: Re: SQLAnywhere to ASE
Date: Mon, 6 Dec 1999 08:40:38 -0500
Lines: 30
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <HvPFh##P$GA.186@forums.sybase.com>
Newsgroups: sybase.public.sqlanywhere.general,sybase.public.sqlserver.nt
NNTP-Posting-Host: 172.31.141.35
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlanywhere.general:2825 sybase.public.sqlserver.nt:503
Article PK: 880736

No utility, but there is a good whitepaper that discusses the issues.

Migrating from Adaptive Server Anywhere to Adaptive Server Enterprise
http://techinfo.sybase.com/css/techinfo.nsf/DocID/ID=20227

Are you sure that you need to move to ASE? I'm not trying to discourage
you, but we occasionally find customers who underestimate ASA and think they
have to upgrade when their database is only a couple of gigabytes in size.

--
-------------------------------------------------------
Robert Waywell
Sybase
Please Respond to Newsgroups

Robert Strigl wrote in message ...
>Hi,
>
>is there a utility to convert my existing SQLA5.0 database into an ASE
>version database. I'm attempting to upgrade and looking for a simply way
to
>do so, if of course there is one..
>
>thanks in advance, rks...
>
>
>
>


Robert Strigl Posted on 1999-12-06 17:18:32.0Z
From: "Robert Strigl" <rkstrigl@hekru.net>
References: <UGel$x7P$GA.203@forums.sybase.com> <HvPFh##P$GA.186@forums.sybase.com>
Subject: Re: SQLAnywhere to ASE
Date: Mon, 6 Dec 1999 12:18:32 -0500
Lines: 21
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <hMFi86AQ$GA.88@forums.sybase.com>
Newsgroups: sybase.public.sqlanywhere.general,sybase.public.sqlserver.nt
NNTP-Posting-Host: host-246.accel.net 207.164.195.246
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlanywhere.general:2824 sybase.public.sqlserver.nt:502
Article PK: 880737

Hello,

> Are you sure that you need to move to ASE? I'm not trying to
discourage
> you, but we occasionally find customers who underestimate ASA and think
they
> have to upgrade when their database is only a couple of gigabytes in size.

I'm not sure.. I was just trying to find some way to gain a lot of
performance... That is not to say that I'm not pleased the way SQLA
performs... I just find it is slowing down.. It is commonly being pounded
by 8-10 users at a time. But for the most part I've been ver pleased with
it. I was just trying to explore alternative to my current solution. So
let me ask you then... will I notice a big increase in performance?

regards, rks...


Robert Waywell Posted on 1999-12-07 16:07:08.0Z
From: "Robert Waywell" <rwaywell@sybase.com>
References: <UGel$x7P$GA.203@forums.sybase.com> <HvPFh##P$GA.186@forums.sybase.com> <hMFi86AQ$GA.88@forums.sybase.com>
Subject: Re: SQLAnywhere to ASE
Date: Tue, 7 Dec 1999 11:07:08 -0500
Lines: 54
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <IAWtE1MQ$GA.204@forums.sybase.com>
Newsgroups: sybase.public.sqlanywhere.general,sybase.public.sqlserver.nt
NNTP-Posting-Host: 172.31.141.35
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlanywhere.general:2823 sybase.public.sqlserver.nt:501
Article PK: 880730

Okay, here are the standard performance questions:

1) how big is your database?
2) how big is your cache size?
- the rule of thumb is 10-15% of db size if you are not replicating and
15-20% if you are replicating
- in other words, the default cache size of 2 meg is suitable for
databases of up to 20meg in size
- if you are currently on SQL Anywhere 5.x, then upgrading to ASA 6.0.3
will give you dynamic cache sizing in which we can adjust the cache size for
you

3) 8-10 users is not an issue, how many transactions are they performing and
how complex are they? A single query doing a 14 table join without indexes
and a bunch of LIKE clauses can bring most servers to their knee's, while a
100 or a 1000 single table selects using a primary key may not be
noticeable.

My guess at this point is that you probably don't need ASE, and that if
your hardware is sufficient to support ASE, then it is already big enough to
tweak your ASA database to support your current users and provide room for
growth.

--
-------------------------------------------------------
Robert Waywell
Sybase
Please Respond to Newsgroups

Robert Strigl wrote in message ...
>Hello,
>
>> Are you sure that you need to move to ASE? I'm not trying to
>discourage
>> you, but we occasionally find customers who underestimate ASA and think
>they
>> have to upgrade when their database is only a couple of gigabytes in
size.
>
>
>I'm not sure.. I was just trying to find some way to gain a lot of
>performance... That is not to say that I'm not pleased the way SQLA
>performs... I just find it is slowing down.. It is commonly being pounded
>by 8-10 users at a time. But for the most part I've been ver pleased with
>it. I was just trying to explore alternative to my current solution. So
>let me ask you then... will I notice a big increase in performance?
>
>regards, rks...
>
>
>
>


Geert Van Damme Posted on 1999-12-08 09:25:55.0Z
From: "Geert Van Damme" <Geert.vandamme@darling.be>
References: <UGel$x7P$GA.203@forums.sybase.com> <HvPFh##P$GA.186@forums.sybase.com> <hMFi86AQ$GA.88@forums.sybase.com> <IAWtE1MQ$GA.204@forums.sybase.com>
Subject: Re: SQLAnywhere to ASE
Date: Wed, 8 Dec 1999 10:25:55 +0100
Lines: 19
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <B$Ipt4VQ$GA.327@forums.sybase.com>
Newsgroups: sybase.public.sqlanywhere.general,sybase.public.sqlserver.nt
NNTP-Posting-Host: cable-195-162-202-125.customer.tvd.be 195.162.202.125
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlanywhere.general:2822 sybase.public.sqlserver.nt:500
Article PK: 842525


Robert Waywell wrote in message ...

> My guess at this point is that you probably don't need ASE, and that if
>your hardware is sufficient to support ASE, then it is already big enough
to
>tweak your ASA database to support your current users and provide room for
>growth.
>

Isn't this paradox true in most of the cases?

;-)

Geert 'Darling' Van Damme


Breck Carter Posted on 1999-12-08 12:37:54.0Z
From: NOSPAM__bcarter@bcarter.com (Breck Carter)
Subject: Re: SQLAnywhere to ASE
Date: Wed, 08 Dec 1999 12:37:54 GMT
Message-ID: <384e4f4c.56812035@forums.sybase.com>
References: <UGel$x7P$GA.203@forums.sybase.com> <HvPFh##P$GA.186@forums.sybase.com> <hMFi86AQ$GA.88@forums.sybase.com> <IAWtE1MQ$GA.204@forums.sybase.com> <B$Ipt4VQ$GA.327@forums.sybase.com>
X-Newsreader: Forte Free Agent 1.11/32.235
Newsgroups: sybase.public.sqlanywhere.general,sybase.public.sqlserver.nt
Lines: 15
NNTP-Posting-Host: trt-on2-07.netcom.ca 207.181.81.135
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlanywhere.general:2821 sybase.public.sqlserver.nt:499
Article PK: 880732

>Isn't this paradox true in most of the cases?

Yes.

If you're building an airline reservation system or a multinational
data warehouse then ASE may be appropriate.

However, most (almost all?) databases are significantly less
ambitious. Hardware and software has improved greatly in the past few
years, to the extend that ASA will perform satisfactorily if not
superbly for most applications.

As far as ease of development, maintenance and administration is
concerned, however, ASE wins hands down over ASE, Oracle, DB2 and
Informix.

Breck


Geert Van Damme Posted on 1999-12-08 21:03:09.0Z
From: "Geert Van Damme" <Geert.vandamme@darling.be>
References: <UGel$x7P$GA.203@forums.sybase.com> <HvPFh##P$GA.186@forums.sybase.com> <hMFi86AQ$GA.88@forums.sybase.com> <IAWtE1MQ$GA.204@forums.sybase.com> <B$Ipt4VQ$GA.327@forums.sybase.com> <384e4f4c.56812035@forums.sybase.com>
Subject: Re: SQLAnywhere to ASE
Date: Wed, 8 Dec 1999 22:03:09 +0100
Lines: 26
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <p$#oU#bQ$GA.204@forums.sybase.com>
Newsgroups: sybase.public.sqlanywhere.general,sybase.public.sqlserver.nt
NNTP-Posting-Host: cable-195-162-202-125.customer.tvd.be 195.162.202.125
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlanywhere.general:2820 sybase.public.sqlserver.nt:498
Article PK: 880731

Exactly, but how can we tell the world?

;-)

Geert 'Darling' Van Damme

Breck Carter wrote in message <384e4f4c.56812035@forums.sybase.com>...
>>Isn't this paradox true in most of the cases?
>
>Yes.
>
>If you're building an airline reservation system or a multinational
>data warehouse then ASE may be appropriate.
>
>However, most (almost all?) databases are significantly less
>ambitious. Hardware and software has improved greatly in the past few
>years, to the extend that ASA will perform satisfactorily if not
>superbly for most applications.
>
>As far as ease of development, maintenance and administration is
>concerned, however, ASE wins hands down over ASE, Oracle, DB2 and
>Informix.
>
>Breck


Jim Egan Posted on 1999-12-10 03:25:25.0Z
From: eganjp@compuserve.com (Jim Egan)
Subject: Re: SQLAnywhere to ASE
Date: Thu, 9 Dec 1999 21:25:25 -0600
Message-ID: <MPG.12ba2e9fa08d298098a41f@forums.sybase.com>
References: <UGel$x7P$GA.203@forums.sybase.com> <HvPFh##P$GA.186@forums.sybase.com> <hMFi86AQ$GA.88@forums.sybase.com> <IAWtE1MQ$GA.204@forums.sybase.com> <B$Ipt4VQ$GA.327@forums.sybase.com> <384e4f4c.56812035@forums.sybase.com> <p$#oU#bQ$GA.204@forums.sybase.com>
Reply-To: eganjp@compuserve.com
X-Newsreader: MicroPlanet Gravity v2.11
Newsgroups: sybase.public.sqlanywhere.general,sybase.public.sqlserver.nt
Lines: 14
NNTP-Posting-Host: dal-qbu-zon-vty58.as.wcom.net 216.192.246.58
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlanywhere.general:2818 sybase.public.sqlserver.nt:496
Article PK: 880728

Well, there for a while we weren't doing it with the stock price. That's
changed a bit.
Get John Chen on TV. The stock price seems to have shot up that last
time this happened.
Sybase can advertise more. (They are doing better at this though)
Press releases are always a good idea.
Write a product evaluation for a trade magazine.
Lead by example (but it's lonely so far out if front)

--
Jim Egan [TeamSybase]
Houston, TX

Sybase Developers Network
http://sdn.sybase.com/sdn/mec/mec_home.stm


Breck Carter Posted on 1999-12-09 15:44:05.0Z
From: NOSPAM__bcarter@bcarter.com (Breck Carter)
Subject: Re: SQLAnywhere to ASE
Date: Thu, 09 Dec 1999 15:44:05 GMT
Message-ID: <384fcdd5.12876925@forums.sybase.com>
References: <UGel$x7P$GA.203@forums.sybase.com> <HvPFh##P$GA.186@forums.sybase.com> <hMFi86AQ$GA.88@forums.sybase.com> <IAWtE1MQ$GA.204@forums.sybase.com> <B$Ipt4VQ$GA.327@forums.sybase.com> <384e4f4c.56812035@forums.sybase.com> <p$#oU#bQ$GA.204@forums.sybase.com>
X-Newsreader: Forte Free Agent 1.11/32.235
Newsgroups: sybase.public.sqlanywhere.general,sybase.public.sqlserver.nt
Lines: 8
NNTP-Posting-Host: trt-on30-58.netcom.ca 207.181.80.58
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlanywhere.general:2819 sybase.public.sqlserver.nt:497
Article PK: 880729

On Wed, 8 Dec 1999 22:03:09 +0100, "Geert Van Damme"

<Geert.vandamme@darling.be> wrote:

>Exactly, but how can we tell the world?

It's hopeless <g>... "the world" is run by The Pointy-Haired Boss who
wants more dancing skeletons on the home page, and we're Ming - "How
do you spell @#$%#?"

Breck


Kris Vorwerk Posted on 1999-12-07 01:40:57.0Z
From: "Kris Vorwerk" <vorwerk@uwaterloo.ca>
References: <UGel$x7P$GA.203@forums.sybase.com> <HvPFh##P$GA.186@forums.sybase.com> <hMFi86AQ$GA.88@forums.sybase.com>
Subject: Re: SQLAnywhere to ASE
Date: Mon, 6 Dec 1999 20:40:57 -0500
Lines: 21
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
Message-ID: <usJtcRFQ$GA.313@forums.sybase.com>
Newsgroups: sybase.public.sqlanywhere.general
NNTP-Posting-Host: 172.31.131.1
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlanywhere.general:45060
Article PK: 912745


> I'm not sure.. I was just trying to find some way to gain a lot of
> performance... That is not to say that I'm not pleased the way SQLA
> performs... I just find it is slowing down.. It is commonly being pounded
> by 8-10 users at a time. But for the most part I've been ver pleased with
> it. I was just trying to explore alternative to my current solution. So
> let me ask you then... will I notice a big increase in performance?

I've never used ASE -- I know that it is a fast, enterprise-level database, but I think you can still get pretty good speed out of ASA with 8 to 10 users. Also, ASE's price can be somewhat prohibitive. (Heck, if cash is not an issue, try out Sybase's IQ 12 -- just make sure your Sun Enterprise 3500 with 4 GB of RAM is up and running okay :)

FYI, you may want to consider purchasing ASA 7 (or trying out its demo) when it becomes publically available.

-k