Dump/Load (from ASE 12.5.4 to ASE 15.x) - VS.
We are in the process of planning the upgrade of our ASE
12.5.4 dataservers to ASE 15.x. What is the most
recommended way to upgrade ASE dataservers from ASE 12.5.4
to ASE 15.x?
1) Install new instances of ASE 15.x and load database
dumps from our ASE 12.5.4 dataservers to the newly installed
ASE 15.x dataservers.
- OR -
2) Use the ASE upgrade utility (sqlupgrade) to upgrade our
existing ASE 12.5.4 dataservers to ASE 15.x.
What are the Pros vs. Cons for loading a 12.5.4 database
into a 15.x ASE dataserver versus performing an ASE
dataserv...When upgrading from ASE 12.5.x to ASE 15.x, what is the best version to upgrade too?
When upgrading from ASE 12.5.x to ASE 15.x, what is the best
version to upgrade too?
I'm currently working on a ASE 15 upgrade project (upgrading
from ASE 12.5.x). I'm trying to decide what version of ASE
15 we should upgrade to.
What are your thoughts? Which version is the safest bet
(ASE 15.0, ASE 15.0.1, ASE 15.0.2, ASE 15.0.3 or ASE 15.5)?
Which ASE version is considered, at this time, the most
mature and reliable version (i.e. with the least amount of
known bugs, least amount of upgrade issues, etc.)?
If applicable, please also give the most recomm...Upgrade ASE 12.0/64 bit on AIX 4.3.3 to ASE 12.5.x/64 bit on AIX 5.2
Trying to find what is the supported upgrade path for the above. Going from
12.0/64bit on AIX 4.3.3 to 12.5 (or 12.5.x) 64bit on AIX 5.2.
If I put AIX 5.2 , the dataserver binary of 12.0 will not work which is used
during the upgrade.
If I put 12.5.x on 4.3.3, the dataserver binary will not work beacuse it is
new binary for 5.2.
Other than backup the databases and load them to the new server, is there a
supported how to upgrade?
...Upgrading from ASE 12.0 to ASE 12.5.2
I am basically thinking of upgrading ASE 12.0.x to ASE 12.5.2.
How would the migration process be. Is it straight dump and load or
> Hi everyone,
> I am basically thinking of upgrading ASE 12.0.x to ASE 12.5.2.
> How would the migration process be. Is it straight dump and load or
> otherwise ??
see the upgrade/installation guide
Senior Consultant Sybase Professional Services
New address per 21 November 2005:
Zo...upgrade from ASE 12.5.3 to ASE 15.0.2 ESD#4
What are the correct steps to upgrade from ASE 12.5.3 to 15.0.2#4?
1. Upgrade ASE 12.5.3 to ASE 15.0, then from ASE 15.0 to ASE 15.0.2#4
2. Upgrade ASE 12.5.3 to ASE 15.0.2 ESD#4
> What are the correct steps to upgrade from ASE 12.5.3 to 15.0.2#4?
> 1. Upgrade ASE 12.5.3 to ASE 15.0, then from ASE 15.0 to ASE 15.0.2#4
> 2. Upgrade ASE 12.5.3 to ASE 15.0.2 ESD#4
I did #2. At one point I considered upgrading to 15.0.2 GA
and then to ESD#4, but the $SYBASE/ASE/upgrade/upgrade program
looks to b...Are there any common errors / issues related to using the dump/load strategy vs. sqlupgrade utility for upgrade/migration to ASE 15.x (from ASE 12.5.x)?
Are there any common errors / issues related to using the
dump/load strategy vs. sqlupgrade utility for
upgrade/migration to ASE 15.x (from ASE 12.5.x)?
I've been reading posts on this discussion thread to try to
see if I can find any disadvantage of using the dump/load
strategy vs. using the sqlupgrade utility (i.e. common
errors / issues).
I noticed that some have run into errors after the
upgrade/migration when using system stored procedure(s). So
this sparked a few questions...
1) Is one upgrade/migration strategy prone to more errors
and issues than ...Upgrade ASE 12.5.3 to ASE 15.0
Can I upgrade my ASE Server 12.5.3 ESD #3 to ASE15.0
without any problems?
According to a ESD #2 notice, if I do this it may regress
the bug compatibility?. What exactly does that mean? What
should I do instead?
Deborah, Brown wrote:
> Can I upgrade my ASE Server 12.5.3 ESD #3 to ASE15.0
> without any problems?
> According to a ESD #2 notice, if I do this it may regress
> the bug compatibility?. What exactly does that mean? What
> should I do instead?
It means that most of the bugs fixed in 12.5.3 ESDs
haven't yet been forward-ported to 15.0....Upgrading from ASE (32-bit) 188.8.131.52 on Solaris 2.8 64-bit to ASE(64-bit) 12.5.1 on Solaris 64-bit
We are planning to upgrade our ASE servers from a 32-bit ASE 184.108.40.206 to
64-bit ASE 12.5.1 on Solaris 8. Could you please give what are the steps to
be taken care and how do I start with ( Do I have to first upgrade to
32-bit12.5.1 and then upgrade to 64-bit ASE 12.5.1, or directly upgrade from
32-bit 220.127.116.11 to 64-bit 12.5.1 ?).
Could you also please point to some documentation (about upgrading 32-bit
18.104.22.168 to 64-bit 12.5.1).
...Upgrade from ASE 22.214.171.124 to ASE 12.5.1
This is a multi-part message in MIME format.
Content-Type: text/plain; charset="iso-8859-1"
I've just upgraded from ASE 126.96.36.199 to ASE 12.5.1. I tried
to start the server, but it won't startup.
Here is the message:
sybase(ASE1250)328 /app/sybase/ASE-12_5/install -->
startserver -f RUN_AMXDB
sybase(ASE1250)329 /app/sybase/ASE-12_5/install -->
00:00000:00000:2004/01/05 21:37:44.10 kernel Use license
00:00000:00000:2004/01/05 21:37:44.10 ker...ASE 12.5 32bit to ASE 15.0 64bit upgrade
What are the steps to upgrade from 12.5 32bit to 15.0 64bit
on AIX 5.3? The 15.0.1 Installation Guide describes the
normal 15.0 upgrade process but then has a terse section
towards the end, "Migrating from 32-bit to 64-bit version",
that describes other steps. Are these steps in addition to
the normal upgrade process (sqlupgrade) or are they in place
of sqlupgrade? Do I really have to drop and re-create all
compiled objects (step 12 under Method #3: Replacing the
Keith Wonderly wrote:
> What are the steps to upgrade from 12.5 32bit to 15.0 64bit
>...Upgrade to ASE 15..0.3 from ASE 12.5.4
I'm currently planning to do an upgrade in place from ASE
12.5.4 to ASE 15.0.3 using sqlupgrade(res) utility.
Does it just run the installmaster and instmsgs.ebf scripts
Will I have to manually run the rest of the scripts i.e.
installsecurity, installdbccdb etc.?
Also in ran the preupgrade program against my old server -
the main errors it came up with were:
Stored Procedure '' uses deprecated builtin functions as:
'rowcnt', which should be changed to 'row_count'.
It doesn't show the stored procedures name - has anyone had
this problem ?
Re...Downgrading from ASE 15.0.2 to ASE 12.5.x...
Downgrading from ASE 15.0.2 to ASE 12.5.x...
I'm in the process of creating a roll-back / contingency /
downgrade plan for an ASE 15 upgrade project (upgrading from
ASE 12.5.x to ASE 15.0.2).
Just a quick note to confirm my understanding of the below
statement I found in Sybase ASE 15.0.2 installation /
Downgrading from ASE 15.0.2 release:
This section describes how to downgrade from Adaptive Server
to an earlier Adaptive Server ...ASE 188.8.131.52 to ASE 12.5.4 upgrade path
I would like to know if the migration from ASE 184.108.40.206 to
12.5.4 a direct migration or is there an intermediate
upgrade to be performed in between?
Take a look at the release bulletins and installation guides for your
platform. These are the first steps to any upgrade.
<passerby> wrote in message news:firstname.lastname@example.org...
>I would like to know if the migration from ASE 220.127.116.11 to
> 12.5.4 a direct migration or is there an intermediate
> upgrade to be performed in between?
...ASE 12.5.x to 15.0.x upgradation
Anyboday, can you please send me a link or document for step
by step approach with commands how to upgrade from sybase
12.5.x to 15.0.x.I have gone through the sybase
documents,still i am looking for some realtime approach(with
all the necessary pre upgrade and post upgrade tasks with
commands) in both windows and unix platform.My server
contains 50 databases from 2gb to 10 gb sizes.It will be
very helpful to me.
Thanks a lot in advance.
Here is thre link too the main page...
Here is the best doc.
http://...ASE 18.104.22.168 to ASE 15.02 EBF2 upgrade
I'm testing my upgrade from
Adaptive Server Enterprise/12.5.3/EBF 12600 ESD#3/P/Linux
Adaptive Server Enterprise/15.0.2/EBF 15101 ESD#2/P/x86_64/Enterprise
Linux/ase1502/2516/64-bit/FBO/Thu Dec 20 01:26:11 2007
OS: RHEL 5
so far some db are been upgraded nice some I have issues , here is one
of my error: ( mentioned this db has replicated tables from other site)
Any tips ?
1>online database hstspss
Started estimating recovery log boundaries for database 'hstspss'.