Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2008
    Location
    India
    Posts
    96

    Unanswered: upgrading sybase 12.5.4 to 15

    All,

    As a developer, what are all the things that i have to analysis?
    As a DBA, what they will do?

    is there any documents available? How it will impact the current system?

  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    Make sure you do extensive testing as the optimizer is totally new and is not as tolerant with badly written queries.
    Ensure you update statistics of all your tables after the upgrade
    You might have to play with different settings for
    sp_configure 'optimization goal'
    See upgrade to ASE 15

  3. #3
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    Make sure you do extensive testing as the optimizer is totally new and is not as tolerant with badly written queries.
    Ensure you update statistics of all your tables after the upgrade
    You might have to play with different settings for
    sp_configure 'optimization goal'
    See upgrade to ASE 15

  4. #4
    Join Date
    Jun 2008
    Location
    India
    Posts
    96
    How this upgrade will affect the existing objects?

    say for example, tables, procedures, triggers etc.,

Posting Permissions

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