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...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...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 220.127.116.11 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 18.104.22.168 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...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...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...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:firstname.lastname@example.org...
>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?
...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...ASE 184.108.40.206 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...Upgrading from ASE 12.5.x to ASE 15.0.2
I have been writing some checklists regarding the Upgrade from ASE12.5.x
version to ASE15.0.2 version, and I have to cover some different sceneries.
I would like to confirm with you guys, If my thoughts are correct
regarding the methods for each situation, and if not, would like some advice
from you please. Correct me please if I am wrong.
Follow the sceneries and the possible methods for each situation that I need
A) Migrating from ASE 12.5.x 32-bit to ASE 15.0.2 64-bit version of
Adaptive Server Enterprise (in this case the page size ...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...Performance Degradation after ASE 12.0 upgrade to ASE 12.5
There was a issue posted on 08/06/2002 by 'Bob' related to performance
degradation after upgrade of ASE 11.9.2 to ASE 12.5. I would like to know
whether anyone has found any solution/workaround
to resolve those issues without making any changes in the application code.
We are also facing the same problems here after upgrade of ASE 12.0 to ASE
12.5. The program which takes 10 mins. on ASE 12.0 is taking more than 3
hrs to finish on ASE 12.5 despite of using the same indexes and the program
which takes 3 hrs on ASE 12.0 is taking more than 24 hours on ASE 12.5. ...ASE 11.5 upgrade to ASE 12.0
Could someone lead me to find any documentation on how to upgrade
ASE 11.5 to ASE 12.0 running on HPUX. All your input is much appreciated.
All that I could find was the ASE 12 Installation Guide and Release
Bulletin. I know that there was a nice 'cookbook' document in the support
area of the web site for upgrading to 11.5, but I guess that wasn't very
helpful to many folks since there was no repeat done.
We are running HPUX 11.0, 64-bit ASE 12 and have ASE configured with 6GB of
TV Guide Networks, Inc.
Ano...Migration from ASE 12.5.3 (Win 32bit) to ASE 15.0.2 (Unix 64 bit) question
I would like to migrate an ASE 12.5.3 on a Microsoft 32-bit
server to an ASE 15.0.2 on Linux (or Solaris) 64-bit server.
What steps must I follow?
Is it a good idea to use a Replication Server 15 as
intermediate task (consultant advice)?
My current ASE has a total size of 350Gb , 2400 connections,
2.6 Gb of memory...
With ASE 12.5.3 you're suppose to be able to perform cross platform dump-n-loads (XPDL), where 'cross platform'
basically means different OS's and/or different endian hardware. This (obviously?) assumes you'll be using ...