I have a general question regarding loading Sybase database dumps into
Sybase servers which are at a higher version level.

Is this possible? What are the limitations involved?

I am currently working on a short term contract for a company I had dealing
with about 7 years. My Sybase knowledge ground to a halt at the end of 2000
due to a job change at the time, and I am current contract involves working
with ver 11.5. I the last 3 years my Sybase admin knowledge has faded and
dates to 11.9.2 anyway.

My current employer plans to upgrade the hardware and Sybase server versions
at the same time, as both are out of support.

I wondered if they could do the installation of the new Unix box and
database upgrade by importing a database dump from the old box into the new
Sybase server on the new box. I vaguely remember this being possible, but
with alot of caveats and limitiations. Or am I suffering from premature
senility ;-)

Can anyone enlighten me on this? Or point me at a web site when I can read
up on this? Thanks.

Tom.

"Tom Brehony" <tombrehony.nospam (AT) eircom (DOT) nospam.net> wrote


Yes, this is generally possible - providing there is no change
in platform (Solaris->HPUX, for instance).

A common issue is having a mismatch in suids for logins between
the master..syslogins tables in the old and new servers. The
sysusers table in each user database maps the suid from master..syslogins
to a particular user.


-bret

I recently moved a system using AIX 4.3 , ASE 11.9.2 to a system on AIX 5.1,
ASE 12.5. The syslogins table was dumped from the original system using bcp
and a view. The output was then loaded to the target system with bcp. A
database dump was used to migrate the data. The database owners were then
corrected.

create view dti_logins

as

select

suid

, status

, accdate

, totcpu

, totio

, spacelimit

, timelimit

, resultlimit

, dbname

, name

, password

, language

, pwdate

, audflags

, fullname

, srvname

, '0' logincount

, '0' pcid

from master..syslogins

where name not in ( 'sa' ,

'probe' )

go

"Bret Halford" <bret (AT) sybase (DOT) com> wrote