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...ASE 22.214.171.124 to ASE 12.5.4 upgrade path
I would like to know if the migration from ASE 126.96.36.199 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:email@example.com...
>I would like to know if the migration from ASE 188.8.131.52 to
> 12.5.4 a direct migration or is there an intermediate
> upgrade to be performed in between?
...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?
...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...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....Upgrade from ASE 184.108.40.206 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 220.127.116.11 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 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'.
Database 'hst...Migration from ASE-64 bits 22.214.171.124 to ASE 64 bits 12.5.3 for AIX 5.3
Here there someone to indicate me the road tasks in order to
migrate an ASE 126.96.36.199 to ASE 12.5.3 on unix 5.3 ? (64
> Here there someone to indicate me the road tasks in order to
> migrate an ASE 188.8.131.52 to ASE 12.5.3 on unix 5.3 ? (64
> Thank you
Apply 12.5.2 IR then 12.5.3 esd 5.
Jason L. Froebe
On Tue, 31 Jan 2006 07:18:22 -0800, kamel wrote:
> Here there someone to indicate me the road tasks in order to migrate an
> ASE 184.108.40.206 ...Logins + passwords when migrating from ASE 12.5.4/Linux x86 32bit to ASE 15.0.3/Solaris SPARC 64bit
I'd like to migrate one of our databases from ASE 12.5.4 to ASE 15. Source server is running on Linux x86 32bit, target server is Solaris SPARC 64bit. Cross-plattform dump and load works fine.
The problem arises with logins/passwords. I've copied the contents of syslogins from the old server to the new one, but I can't log in using one of the manually migrated logins.
Checking syslogins, I noticed that the password hashes on ASE 15 look different. Old hashes are just 60 characters long, the new ones 84 characters.
According to Michael Peppler's ASE on Linux FAQ...Upgrading ASE 11.9.2 to ASE 12.5 on Aix 4.3.3
After migration from ASE 11.9.2 to ASE 12.5, the following error appears
when I try to execute a strore procedure :
Size of row in the worktable for grouped aggregate, 16542 bytes, exceeds the
maximum row size (1962 bytes). Cannot run this query (return status = -6).
Is it a bug on ASE 12.5? Why could I run correctly this procedure on the old
Fabien DUBOIS wrote:
> After migration from ASE 11.9.2 to ASE 12.5, the following error appears
> when I try to execute a strore procedure :
> Size of row in the worktable for grouped aggr...Exception: SQLException Error After Upgrade from ASE 220.127.116.11 to 12.5.4
After we upgraded ASE on SUN Solaris from 18.104.22.168 to
12.5.4, our web application gives us the following error...
Exception: SQLException: Fail on select Invalid column name
It appears to me that the sql is being interpreted wrong.
We have a database table that all the users are stored in
for the app. As you can see by the error message, it seems
to be treating the user as a column name???
The only thing in our environment that changed is the ASE
version. DId sql syntax change between these versions?
Thanks for the help,
SQL syntax do...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
>...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...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: