Results 1 to 5 of 5
  1. #1
    Join Date
    May 2003

    Unanswered: upgrade from 11.5 to 12.0

    Hi all

    I am in the process of preapre upgrade for Sybase from 11.5 to 12.0,

    My question is I am going to upgrade the same ASE, it is mean I will run sqlupgraders script on my ASE, after the script execution finish do I need to load my user database again or sqlupgraders has already upgrade all the databases inside the ASE.

    As you know when we build new separeate ASE on 12.0, then we need to take db dump on 11.5 and then load it on 12.0 in order to upgrade teh database.

    Thanks in advance.

  2. #2
    Join Date
    Feb 2002
    Willy is on vacation
    Hiya tech2000,

    The purpose of sqlupgrade is to upgrade the ASE server from previous versions to a destination version, which in your case is ASE 12.0.

    Once you have used sqlupgrade and completed upgrade means you don't have to load those old user databases on again. Using sqlupgrade itself is a complete upgrade and no loading of user databases is required. If you do, then you are effectively doing an upgrade twice.


  3. #3
    Join Date
    Jun 2003
    Willy is correct . you should have a variable OLDSYBASE pointing to the old database which will be upgraded by sqlupgrade.


  4. #4
    Join Date
    Apr 2003
    I think it better that you install ASE 12 first and load the dump form 11.5.
    Because you have recover the system or install ASE if sql upgrade fails

  5. #5
    Join Date
    Jun 2003

    We have been throught this upgrade on several very large systems, so
    i thought i might pass on some tips

    1) take the backup - goes without saying
    2) you can happily run the upgrade on the database as is - if it fails THEN you can restore back to 11.5 that way you only restore if there is a problem, the other way round just adds time
    3) it takes a while on large databases, especially if you all of the recommended dbcc steps as well!
    4) TAKE a copy of your interfaces file if you have more than one entry
    as it only upgrades the first entry - the rest have to be reapplied by hand
    5) take the time to apply the EBF's this saves further heartache later
    6) Make sure that you get the operating system up to date as well - there are some operating system dependancies for these upgrades

    Good luck

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts