dbTalk Databases Forums  

Why SA11 won't upgrade some ASA9 databases. Solution Found!

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general


Discuss Why SA11 won't upgrade some ASA9 databases. Solution Found! in the sybase.public.sqlanywhere.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Glenn Barber
 
Posts: n/a

Default Why SA11 won't upgrade some ASA9 databases. Solution Found! - 09-22-2009 , 11:23 PM






I have been having issues upgrading customers ASA9 databases to SA11. In
many cases the instructions on how to upgrade the the Version 9 databases
failed with the database unable to start with the V11 dnunload.

After working with support for a hour or so we located the issue. We were
trying to upgrade the databases using the SQL Central Image Database Backups
from V9. In Version 9 these backsups look on disk and behave exactly like
the original.

However the V11 dbunload utility will not start them. The solution is to
startup the database file under ASA9 then stop it. Then the file can
be properly started and unloaded using the V11 dbunload.

This did not seem to be a problem in the V10 upgrade.


Glenn Barber
Gray Matter LLC

Reply With Quote
  #2  
Old   
Volker Barth
 
Posts: n/a

Default Re: Why SA11 won't upgrade some ASA9 databases. Solution Found! - 09-23-2009 , 03:58 AM






Glenn,

see my answer in the sybase.public.sqlanywhere NG.

HTH
Volker


Glenn Barber schrieb:
Quote:
I have been having issues upgrading customers ASA9 databases to SA11. In
many cases the instructions on how to upgrade the the Version 9 databases
failed with the database unable to start with the V11 dnunload.

After working with support for a hour or so we located the issue. We were
trying to upgrade the databases using the SQL Central Image Database Backups
from V9. In Version 9 these backsups look on disk and behave exactly like
the original.

However the V11 dbunload utility will not start them. The solution is to
startup the database file under ASA9 then stop it. Then the file can
be properly started and unloaded using the V11 dbunload.

This did not seem to be a problem in the V10 upgrade.


Glenn Barber
Gray Matter LLC


Reply With Quote
  #3  
Old   
Glenn Barber
 
Posts: n/a

Default Re: Why SA11 won't upgrade some ASA9 databases. Solution Found! - 09-23-2009 , 01:44 PM



Thanks for the confirmation.

I saw the note that this issue has already been addressed in a subsequent
build.

I changed my posting because it didn;t look like the
sybase.public.sqlanywhere forum was the correct one. the
sybase.public.sqlanywhere.general seemed to be getting the bulk of the
activity.


"Volker Barth" <No_VBarth (AT) Spam_GLOBAL-FINANZ (DOT) de> wrote

Quote:
Glenn,

see my answer in the sybase.public.sqlanywhere NG.

HTH
Volker


Glenn Barber schrieb:
I have been having issues upgrading customers ASA9 databases to SA11. In
many cases the instructions on how to upgrade the the Version 9 databases
failed with the database unable to start with the V11 dnunload.

After working with support for a hour or so we located the issue. We
were
trying to upgrade the databases using the SQL Central Image Database
Backups
from V9. In Version 9 these backsups look on disk and behave exactly
like
the original.

However the V11 dbunload utility will not start them. The solution is to
startup the database file under ASA9 then stop it. Then the file can
be properly started and unloaded using the V11 dbunload.

This did not seem to be a problem in the V10 upgrade.


Glenn Barber
Gray Matter LLC

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.