Skip to Content
Former Member
Oct 20, 2016 at 02:05 AM

Recommended upgrade method from ASE 15.0 to 15.7 on Linux RHEL7


As a proof of concept I installed 15.7 (SP137) onto our Dev system using the binary overlay method (./setup), but it didn't quite install as expected, using the updatease method, so to be safe I ran the install scripts as per the manual (SP100), post upgrade tasks. This method was used, as due to history, we have no real idea of what may have been modified, nor what settings were applied by the many before us.

However, in the next phase, a new virtual RHEL7 server will be used so we have to start from scratch. Of the multiple methods what is the best one to use to ensure all the necessary items are restored, especially users/passwords, etc which would be in the old master and system db's. The manual's can be quite confusing and contradictory so I have also referred to a few geek sites/blog's to see what the normal installs look like.

I would ideally like to restore the 15.0.2 system onto that server, so it would find everything as before, but this is not ideal, as we should reorganise devices/LUN's (and possibly migrate from the 2K default, from the original 12.5 db).

So is there a good reference website(blog) which lays out common upgrade options like this, and recommendations for dba's new to Sybase, and the common pitfalls beginners make.