Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Data: 32-bit to 64-bit during version upgrade?

3 posts in General Discussion Last posting was on 2011-08-24 18:26:16.0Z
Paul Fenstermacher Posted on 2011-08-19 21:45:34.0Z
Sender: 22f8.4e4ece88.1804289383@sybase.com
From: Paul Fenstermacher
Newsgroups: sybase.public.ase.general
Subject: Data: 32-bit to 64-bit during version upgrade?
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4e4ed97e.4002.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 19 Aug 2011 14:45:34 -0700
X-Trace: forums-1-dub 1313790334 10.22.241.41 (19 Aug 2011 14:45:34 -0700)
X-Original-Trace: 19 Aug 2011 14:45:34 -0700, 10.22.241.41
Lines: 15
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30481
Article PK: 72660

If I upgrade ASE on a single Solaris host from 32-bit Sybase
15.0.3 to 64-bit Sybase 15.5, as described in
http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc35889.1550/doc/pdf/aseinstallsun.pdf
, is it necessary to use one of the 3 methods described in
section "Migrating from 32-bit to 64-bit Versions on
Different Computers" to upgrade/migrate the data?
In other words, I am already running 32-bit Sybase ASE
15.0.3 on a 64-bit Solaris 10 host, and want to upgrade to
64-bit Sybase ASE 15.5, on the same machine, not different
machines. It's not clear to me from reading the
Installation Guide and Utility Guide whether sqlupgrade will
upgrade the databases "in place" or whether I must use one
of the "Migrating from 32-bit to 64-bit Versions on
Different Computers" approaches.
Thank you in advance for any help you can provide.


Cory Sane [TeamSybase] Posted on 2011-08-23 02:06:10.0Z
From: "Cory Sane [TeamSybase]" <cory!=sane>
Newsgroups: sybase.public.ase.general
References: <4e4ed97e.4002.1681692777@sybase.com>
In-Reply-To: <4e4ed97e.4002.1681692777@sybase.com>
Subject: Re: 32-bit to 64-bit during version upgrade?
Lines: 26
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6002.18197
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6002.18463
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4e530b12$1@forums-1-dub>
Date: 22 Aug 2011 19:06:10 -0700
X-Trace: forums-1-dub 1314065170 10.22.241.152 (22 Aug 2011 19:06:10 -0700)
X-Original-Trace: 22 Aug 2011 19:06:10 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30489
Article PK: 72668

It has been several years since i've done this in the 12.5 world but i'm 99% sure that you can do an upgrade inplace...
But definitely keep both program libraries available until you are done.

I ways did the server shutdown and restart method.


--
Cory Sane
[TeamSybase]
Certified Sybase Associate DBA for ASE 15.0

"Paul Fenstermacher" wrote in message news:4e4ed97e.4002.1681692777@sybase.com...
> If I upgrade ASE on a single Solaris host from 32-bit Sybase
> 15.0.3 to 64-bit Sybase 15.5, as described in
> http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc35889.1550/doc/pdf/aseinstallsun.pdf
> , is it necessary to use one of the 3 methods described in
> section "Migrating from 32-bit to 64-bit Versions on
> Different Computers" to upgrade/migrate the data?
> In other words, I am already running 32-bit Sybase ASE
> 15.0.3 on a 64-bit Solaris 10 host, and want to upgrade to
> 64-bit Sybase ASE 15.5, on the same machine, not different
> machines. It's not clear to me from reading the
> Installation Guide and Utility Guide whether sqlupgrade will
> upgrade the databases "in place" or whether I must use one
> of the "Migrating from 32-bit to 64-bit Versions on
> Different Computers" approaches.
> Thank you in advance for any help you can provide.


Paul Fenstermacher Posted on 2011-08-24 18:26:16.0Z
Sender: 6675.4e526096.1804289383@sybase.com
From: Paul Fenstermacher
Newsgroups: sybase.public.ase.general
Subject: Re: 32-bit to 64-bit during version upgrade?
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4e554247.75b0.1681692777@sybase.com>
References: <4e530b12$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 24 Aug 2011 11:26:16 -0700
X-Trace: forums-1-dub 1314210376 10.22.241.41 (24 Aug 2011 11:26:16 -0700)
X-Original-Trace: 24 Aug 2011 11:26:16 -0700, 10.22.241.41
Lines: 32
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30499
Article PK: 72678

Thank you, Cory.
Paul

> It has been several years since i've done this in the 12.5
> world but i'm 99% sure that you can do an upgrade
> inplace... But definitely keep both program libraries
> available until you are done.
>
> I ways did the server shutdown and restart method.
>
>
> --
> Cory Sane
> [TeamSybase]
> Certified Sybase Associate DBA for ASE 15.0
> "Paul Fenstermacher" wrote in message
> > news:4e4ed97e.4002.1681692777@sybase.com... If I upgrade
> > ASE on a single Solaris host from 32-bit Sybase 15.0.3
> > to 64-bit Sybase 15.5, as described in
>
http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc35889.1550/doc/pdf/aseinstallsun.pdf
> > , is it necessary to use one of the 3 methods described
> > in section "Migrating from 32-bit to 64-bit Versions on
> > Different Computers" to upgrade/migrate the data?
> > In other words, I am already running 32-bit Sybase ASE
> > 15.0.3 on a 64-bit Solaris 10 host, and want to upgrade
> > to 64-bit Sybase ASE 15.5, on the same machine, not
> > different machines. It's not clear to me from reading
> > the Installation Guide and Utility Guide whether
> > sqlupgrade will upgrade the databases "in place" or
> > whether I must use one of the "Migrating from 32-bit to
> > 64-bit Versions on Different Computers" approaches.
> > Thank you in advance for any help you can provide.