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.

Upgrading from 5.5.05 to 9.x

7 posts in General Discussion Last posting was on 2006-10-30 14:31:05.0Z
Ron Wicks Posted on 2006-10-23 19:22:21.0Z
Sender: 4998.453d13da.1804289383@sybase.com
From: Ron Wicks
Newsgroups: ianywhere.public.general
Subject: Upgrading from 5.5.05 to 9.x
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <453d166d.49c9.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 23 Oct 2006 12:22:21 -0700
X-Trace: forums-1-dub 1161631341 10.22.241.41 (23 Oct 2006 12:22:21 -0700)
X-Original-Trace: 23 Oct 2006 12:22:21 -0700, 10.22.241.41
Lines: 3
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5684
Article PK: 1696

How do I upgrade from Sybase SQL Anywhere 5.5.05 to SQL
Anywhere Studio 9.x? Baby steps...from 5 to 6 to 7, etc.?
Or one giant leap for mankind...5 to 9?


Breck Carter [Team iAnywhere] Posted on 2006-10-23 20:03:23.0Z
From: "Breck Carter [Team iAnywhere]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: Upgrading from 5.5.05 to 9.x
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <1e7qj2to38ijg6358s00fea4qbnv6crvid@4ax.com>
References: <453d166d.49c9.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: bcarter.sentex.ca
X-Original-NNTP-Posting-Host: bcarter.sentex.ca
Date: 23 Oct 2006 13:03:23 -0700
X-Trace: forums-1-dub 1161633803 64.7.134.118 (23 Oct 2006 13:03:23 -0700)
X-Original-Trace: 23 Oct 2006 13:03:23 -0700, bcarter.sentex.ca
Lines: 41
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5685
Article PK: 1697


On 23 Oct 2006 12:22:21 -0700, Ron Wicks wrote:

>How do I upgrade from Sybase SQL Anywhere 5.5.05 to SQL
>Anywhere Studio 9.x? Baby steps...from 5 to 6 to 7, etc.?
>Or one giant leap for mankind...5 to 9?

One giant step, but... it is a huge step and fraught with peril. Many
behavior changes have been introduced over the years, and you should
read all the 'behavior change' sections in the What's New portion of
the V9 help.

Then...

1. Make a backup copy of the V5 database file.

2. Use the Version 9 engine to start the V5 database.

3. Use the V9 dbunload to unload the V5 database; the schema will go
in the reload.sql file and the data will go in various *.dat files.

4. Inspect the reload.sql file for peculiarities, and edit the file if
necessary. Skip this step if you want, but you may have to return to
it if Step 6 has problems.

5. Use the V9 dbinit to create a new V9 database, with -p 4096.

6. Use dbisql to run the reload.sql file to recreate the schema and
reload the data.

Using separate steps saves time, since Step 3 is time-consuming and
does not have to be repeated no matter how many problems are
encountered later on.

Breck

--
Breck Carter [Team iAnywhere]
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
The book: http://www.risingroad.com/SQL_Anywhere_Studio_9_Developers_Guide.html
breck.carter@risingroad.com


Justin Willey Posted on 2006-10-27 11:04:43.0Z
From: "Justin Willey" <gjw@nospamatall.iqx.co.uk>
Newsgroups: ianywhere.public.general
References: <453d166d.49c9.1681692777@sybase.com>
Subject: Re: Upgrading from 5.5.05 to 9.x
Lines: 35
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: i-83-67-79-29.freedom2surf.net
X-Original-NNTP-Posting-Host: i-83-67-79-29.freedom2surf.net
Message-ID: <4541e7cb@forums-1-dub>
Date: 27 Oct 2006 04:04:43 -0700
X-Trace: forums-1-dub 1161947083 83.67.79.29 (27 Oct 2006 04:04:43 -0700)
X-Original-Trace: 27 Oct 2006 04:04:43 -0700, i-83-67-79-29.freedom2surf.net
X-Authenticated-User: sa_beta
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5688
Article PK: 1700

As well as the actual upgrade process (which Breck as covered) , you may
need to look at the SQL that your application runs. As Breck says, you need
to review the behaviour changes detailed in the help file for every version
(the lists aren't cumulative).

Things that have given us grief:

V5 allowed quite a lot of "wooliness" that has been tightened up on later,
so queries that ran fine in v5 may be regarded as potentially ambigous in v9
and may neeed rewriting. Normally you don't have to do much more than make
sure that columns are properly qualified by table name.

References to aliases in select lists must now appear after the definition
of the alias

Restrictions on the use of number(*)

I have also seen posts in the newsgroups about Character Translation /
Collation issues and also that while in the past you could rely on an
implicit ordering in tables, ie if you did an unordered select you could
rely on get rows back in the order they were inserted - that is no longer
the case, you must specify an order to get reliable (or repeatable) results.

Hope this helps

Justin Willey

<Ron Wicks> wrote in message news:453d166d.49c9.1681692777@sybase.com...
> How do I upgrade from Sybase SQL Anywhere 5.5.05 to SQL
> Anywhere Studio 9.x? Baby steps...from 5 to 6 to 7, etc.?
> Or one giant leap for mankind...5 to 9?


Greg Fenton Posted on 2006-10-27 14:17:56.0Z
From: Greg Fenton <greg.fenton@googles-mail-site>
User-Agent: Thunderbird 1.5.0.7 (Windows/20060909)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Upgrading from 5.5.05 to 9.x
References: <453d166d.49c9.1681692777@sybase.com> <4541e7cb@forums-1-dub>
In-Reply-To: <4541e7cb@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: wsp04839138wss.cr.net.cable.rogers.com
X-Original-NNTP-Posting-Host: wsp04839138wss.cr.net.cable.rogers.com
Message-ID: <45421514$1@forums-1-dub>
Date: 27 Oct 2006 07:17:56 -0700
X-Trace: forums-1-dub 1161958676 24.235.100.122 (27 Oct 2006 07:17:56 -0700)
X-Original-Trace: 27 Oct 2006 07:17:56 -0700, wsp04839138wss.cr.net.cable.rogers.com
Lines: 13
X-Authenticated-User: sa_beta
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5689
Article PK: 1701


Justin Willey wrote:
> V5 allowed quite a lot of "wooliness" that has been tightened up on later,
> so queries that ran fine in v5 may be regarded as potentially ambigous in v9
> and may neeed rewriting.

Just to clarify this statement, the queries *ran* in v5, but they were
ambiguous. They don't run in v9 because it doesn't allow for the
ambiguity. "Ran fine" is open to debate.

g.f
--
Greg Fenton
Some Random Dude


Justin Willey Posted on 2006-10-30 08:47:48.0Z
From: "Justin Willey" <gjw@nospamatall.iqx.co.uk>
Newsgroups: ianywhere.public.general
References: <453d166d.49c9.1681692777@sybase.com> <4541e7cb@forums-1-dub> <45421514$1@forums-1-dub>
Subject: Re: Upgrading from 5.5.05 to 9.x
Lines: 24
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: i-83-67-79-29.freedom2surf.net
X-Original-NNTP-Posting-Host: i-83-67-79-29.freedom2surf.net
Message-ID: <4545ca44@forums-1-dub>
Date: 30 Oct 2006 01:47:48 -0700
X-Trace: forums-1-dub 1162201668 83.67.79.29 (30 Oct 2006 01:47:48 -0700)
X-Original-Trace: 30 Oct 2006 01:47:48 -0700, i-83-67-79-29.freedom2surf.net
X-Authenticated-User: sa_beta
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5692
Article PK: 1703

Greg - agreed - "ran without an error message" would express it better.
Strangely enough though, when we looked at the the couple of queries that
were being complained, about v5 seemed to have been doing a pretty good mind
reading job on what was actually wanted!

Justin

"Greg Fenton" <greg.fenton@googles-mail-site> wrote in message
news:45421514$1@forums-1-dub...
> Justin Willey wrote:
>> V5 allowed quite a lot of "wooliness" that has been tightened up on
>> later, so queries that ran fine in v5 may be regarded as potentially
>> ambigous in v9 and may neeed rewriting.
>
> Just to clarify this statement, the queries *ran* in v5, but they were
> ambiguous. They don't run in v9 because it doesn't allow for the
> ambiguity. "Ran fine" is open to debate.
>
> g.f
> --
> Greg Fenton
> Some Random Dude


Greg Fenton Posted on 2006-10-30 14:31:05.0Z
From: Greg Fenton <greg.fenton@googles-mail-site>
User-Agent: Thunderbird 1.5.0.7 (Windows/20060909)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Upgrading from 5.5.05 to 9.x
References: <453d166d.49c9.1681692777@sybase.com> <4541e7cb@forums-1-dub> <45421514$1@forums-1-dub> <4545ca44@forums-1-dub>
In-Reply-To: <4545ca44@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: wsp04839138wss.cr.net.cable.rogers.com
X-Original-NNTP-Posting-Host: wsp04839138wss.cr.net.cable.rogers.com
Message-ID: <45461ab9$1@forums-1-dub>
Date: 30 Oct 2006 07:31:05 -0700
X-Trace: forums-1-dub 1162222265 24.235.100.122 (30 Oct 2006 07:31:05 -0700)
X-Original-Trace: 30 Oct 2006 07:31:05 -0700, wsp04839138wss.cr.net.cable.rogers.com
Lines: 26
X-Authenticated-User: sa_beta
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5693
Article PK: 1704


Justin Willey wrote:
> Greg - agreed - "ran without an error message" would express it better.
> Strangely enough though, when we looked at the the couple of queries that
> were being complained, about v5 seemed to have been doing a pretty good mind
> reading job on what was actually wanted!

I am not surprised by this. Most people would have caught problems if
their applications were giving definite errors. In fact, I suspect that
most developers do actually test their queries to some degree :-)

The problem of ambiguous queries can be a subtle one, and often might
not be triggered until certain conditions occur (a large amount of data
added, the overall size of the database, new objects being added to the
db, etc...).

There are lots of v5 apps out there that are using constraints that are
no longer allowed in v8, v9 or newer. They aren't *necessarily* wrong,
but it is hard to prove that they are right either...since what does
"right" mean when you are looking at an ambiguous query?

;-)

g.f
--
Greg Fenton
Some Random Dude


Glenn Paulley Posted on 2006-10-27 14:44:08.0Z
Newsgroups: ianywhere.public.general
Subject: Re: Upgrading from 5.5.05 to 9.x
From: Glenn Paulley <paulley@ianywhere.com>
References: <453d166d.49c9.1681692777@sybase.com> <4541e7cb@forums-1-dub>
Organization: iAnywhere Solutions
Message-ID: <Xns98696C66FF165paulleyianywherecom@10.22.241.106>
User-Agent: Xnews/5.04.25
NNTP-Posting-Host: paulley-t41.sybase.com
X-Original-NNTP-Posting-Host: paulley-t41.sybase.com
Date: 27 Oct 2006 07:44:08 -0700
X-Trace: forums-1-dub 1161960248 10.25.99.149 (27 Oct 2006 07:44:08 -0700)
X-Original-Trace: 27 Oct 2006 07:44:08 -0700, paulley-t41.sybase.com
Lines: 73
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5690
Article PK: 1702

"Justin Willey" <gjw@nospamatall.iqx.co.uk> wrote in
news:4541e7cb@forums-1-dub:

> Things that have given us grief:
>
> V5 allowed quite a lot of "wooliness" that has been tightened up on
> later, so queries that ran fine in v5 may be regarded as potentially
> ambigous in v9 and may neeed rewriting. Normally you don't have to do
> much more than make sure that columns are properly qualified by table
> name.
>

Issues with table expressions in the FROM clause that yield syntax errors
in version 9.x are likely due to references in an ON condition to other
tables in a different table expression; this is solved through the use of
the LATERAL keyword.

> References to aliases in select lists must now appear after the
> definition of the alias
>

This was only true for a very brief period of time with version 9 - we
subsequently altered the alias lookup algorithm to remove this
restriction.

> Restrictions on the use of number(*)
>

I am unaware of any restrictions (syntax errors) added to the server
concerning NUMBER(*) that are not addressing an issue where NUMBER(*)
would return an incorrect answer.

> I have also seen posts in the newsgroups about Character Translation /
> Collation issues and also that while in the past you could rely on an
> implicit ordering in tables, ie if you did an unordered select you
> could rely on get rows back in the order they were inserted - that is
> no longer the case, you must specify an order to get reliable (or
> repeatable) results.
>

Implicit row ordering was never supported in any release, and is not
supported in version 10 either. There is no guarantee that the physical
order of rows in a table matches their insertion order.


> Hope this helps
>
> Justin Willey
>
>
>
> <Ron Wicks> wrote in message
> news:453d166d.49c9.1681692777@sybase.com...
>> How do I upgrade from Sybase SQL Anywhere 5.5.05 to SQL
>> Anywhere Studio 9.x? Baby steps...from 5 to 6 to 7, etc.?
>> Or one giant leap for mankind...5 to 9?
>
>



--
Glenn Paulley
Research and Development Manager, Query Processing
iAnywhere Solutions Engineering

Register now for TechWave 2006 August 6-10 in Las Vegas. New! 2-day
and 4-day options for SQL Anywhere technical training. Sessions will
focus on data management, data movement, and SQL Anywhere 10. Visit
www.sybase.com/techwave

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