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.

db upgrades

4 posts in General Discussion Last posting was on 2005-11-30 14:42:42.0Z
Greg Wallace Posted on 2005-11-29 20:44:12.0Z
Sender: 6cf2.438cb9ec.1804289383@sybase.com
From: Greg Wallace
Newsgroups: ianywhere.public.general
Subject: db upgrades
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <438cbd9c.6d63.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 29 Nov 2005 12:44:12 -0800
X-Trace: forums-1-dub 1133297052 10.22.241.41 (29 Nov 2005 12:44:12 -0800)
X-Original-Trace: 29 Nov 2005 12:44:12 -0800, 10.22.241.41
Lines: 5
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5000
Article PK: 17477

I am upgrading my databases (and file formats) from 8.02 to
the current 9.02. Did it two ways: hop to v9 and then 9.02
as well as one leap to 9.02. How can I tell that it was
successful? The all the new databases seems work fine, but
I have no confirmation one way or the other.


Breck Carter [TeamSybase] Posted on 2005-11-29 21:08:52.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: db upgrades
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <26gpo19j0c9l72109jdl3gmok2b3tjpnif@4ax.com>
References: <438cbd9c.6d63.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: 29 Nov 2005 13:08:52 -0800
X-Trace: forums-1-dub 1133298532 64.7.134.118 (29 Nov 2005 13:08:52 -0800)
X-Original-Trace: 29 Nov 2005 13:08:52 -0800, bcarter.sentex.ca
Lines: 31
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5001
Article PK: 17475

The one-hop straight-to-9.0.2 is recommended, simply as a time saver.

The dbunload-dbinit-reload via dbisql approach is recommended, using
all-9.0.2 software. If you just did a dbupgrade, I suggest you go back
and do the unload-reload to get the full benefits of a version 9
database file.

Whatever process you did use, if it didn't produce any error
conditions you can assume it worked. However, there are behavior
changes that probably require testing of your application; at the very
least, you should review the "Behavior change" sections in the Help,
all the way from 8.0.3 to 9.0.2.

And run dbvalid.

Breck

On 29 Nov 2005 12:44:12 -0800, Greg Wallace wrote:

>I am upgrading my databases (and file formats) from 8.02 to
>the current 9.02. Did it two ways: hop to v9 and then 9.02
>as well as one leap to 9.02. How can I tell that it was
>successful? The all the new databases seems work fine, but
>I have no confirmation one way or the other.

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/ASIN/1556225067/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com


Greg Wallace Posted on 2005-11-29 21:50:18.0Z
Sender: 6cf2.438cb9ec.1804289383@sybase.com
From: Greg Wallace
Newsgroups: ianywhere.public.general
Subject: Re: db upgrades
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <438ccd1a.6e5a.1681692777@sybase.com>
References: <26gpo19j0c9l72109jdl3gmok2b3tjpnif@4ax.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 29 Nov 2005 13:50:18 -0800
X-Trace: forums-1-dub 1133301018 10.22.241.41 (29 Nov 2005 13:50:18 -0800)
X-Original-Trace: 29 Nov 2005 13:50:18 -0800, 10.22.241.41
Lines: 50
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5002
Article PK: 17476

I like simple.

The first test runs I did last week used Sybase Central. I
will be doing another test run today using the command lines
dbupgrad and dbunload since I have many db's to do.

Users will be logging on onto the upgraded db's for testing
once I script out the upgrade process. Reviewed the
behavior changes and did not find anything that would effect
me. Keeping my figures crossed.

Thanks
Greg

> The one-hop straight-to-9.0.2 is recommended, simply as a
> time saver.
>
> The dbunload-dbinit-reload via dbisql approach is
> recommended, using all-9.0.2 software. If you just did a
> dbupgrade, I suggest you go back and do the unload-reload
> to get the full benefits of a version 9 database file.
>
> Whatever process you did use, if it didn't produce any
> error conditions you can assume it worked. However, there
> are behavior changes that probably require testing of your
> application; at the very least, you should review the
> "Behavior change" sections in the Help, all the way from
> 8.0.3 to 9.0.2.
>
> And run dbvalid.
>
> Breck
>
> On 29 Nov 2005 12:44:12 -0800, Greg Wallace wrote:
>
> >I am upgrading my databases (and file formats) from 8.02
> to >the current 9.02. Did it two ways: hop to v9 and then
> 9.02 >as well as one leap to 9.02. How can I tell that it
> was >successful? The all the new databases seems work
> fine, but >I have no confirmation one way or the other.
>
> --
> SQL Anywhere Studio 9 Developer's Guide
> Buy the book:
>
http://www.amazon.com/exec/obidos/ASIN/1556225067/risingroad-20
> bcarter@risingroad.com
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com


Breck Carter [TeamSybase] Posted on 2005-11-30 14:42:42.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: db upgrades
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <u0ero19jcdc1crjjvd50kkt5f90ijp1taf@4ax.com>
References: <26gpo19j0c9l72109jdl3gmok2b3tjpnif@4ax.com> <438ccd1a.6e5a.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: 30 Nov 2005 06:42:42 -0800
X-Trace: forums-1-dub 1133361762 64.7.134.118 (30 Nov 2005 06:42:42 -0800)
X-Original-Trace: 30 Nov 2005 06:42:42 -0800, bcarter.sentex.ca
Lines: 66
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5005
Article PK: 17479

I generally don't recommend it, BUT if you have a large number of
databases to upgrade, and they are all similar in the fact they don't
cause any grief when upgrading (errors etc), then dbunload offers some
"unload and reload in-place" options: dbunload -an and -ar

Breck

On 29 Nov 2005 13:50:18 -0800, Greg Wallace wrote:

>I like simple.
>
>The first test runs I did last week used Sybase Central. I
>will be doing another test run today using the command lines
>dbupgrad and dbunload since I have many db's to do.
>
>Users will be logging on onto the upgraded db's for testing
>once I script out the upgrade process. Reviewed the
>behavior changes and did not find anything that would effect
>me. Keeping my figures crossed.
>
>Thanks
>Greg
>
>
>> The one-hop straight-to-9.0.2 is recommended, simply as a
>> time saver.
>>
>> The dbunload-dbinit-reload via dbisql approach is
>> recommended, using all-9.0.2 software. If you just did a
>> dbupgrade, I suggest you go back and do the unload-reload
>> to get the full benefits of a version 9 database file.
>>
>> Whatever process you did use, if it didn't produce any
>> error conditions you can assume it worked. However, there
>> are behavior changes that probably require testing of your
>> application; at the very least, you should review the
>> "Behavior change" sections in the Help, all the way from
>> 8.0.3 to 9.0.2.
>>
>> And run dbvalid.
>>
>> Breck
>>
>> On 29 Nov 2005 12:44:12 -0800, Greg Wallace wrote:
>>
>> >I am upgrading my databases (and file formats) from 8.02
>> to >the current 9.02. Did it two ways: hop to v9 and then
>> 9.02 >as well as one leap to 9.02. How can I tell that it
>> was >successful? The all the new databases seems work
>> fine, but >I have no confirmation one way or the other.
>>
>> --
>> SQL Anywhere Studio 9 Developer's Guide
>> Buy the book:
>>
>http://www.amazon.com/exec/obidos/ASIN/1556225067/risingroad-20
>> bcarter@risingroad.com
>> RisingRoad SQL Anywhere and MobiLink Professional Services
>> www.risingroad.com

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/ASIN/1556225067/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com