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...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 ...Dump & Load (DB Migration from ASE 12.5 to ASE 15)
What are the important points we need to take care while performing Dump &
Load Migrations from Windows to Linux.
We need to ensure logins, users, roles, and device fragments. Pleaes let me
have expert views.
Does Linux supports RAW Devices ?
> Dear All,
> What are the important points we need to take care while performing Dump &
> Load Migrations from Windows to Linux.
> We need to ensure logins, users, roles, and device fragments. Pleaes let me
> have expert views.
In the past, I've bcp...Dump on ASE 12.5.2 and Load on ASE 12.5.3
Is possible to make one dump database in ASE 12.5.2 and
later making one load of this archive in ASE 12.5.3?
It is possible to dump a database in 12.5.2 and load it onto 12.5.3.
> Is possible to make one dump database in ASE 12.5.2 and
> later making one load of this archive in ASE 12.5.3?
I recently dumped from 12.0 & loaded to 12.5, was pleasantly surprised the
load process upgraded the database automatically.
<Leandro> wrote in message news:email@example.com...
> Is possible to make one dump database in ASE 12...problems loading ASE 12.5 dump into ASE 15.0 DB
I'm having problems loading a 12.5 database dump into a 15.0 database.
On the 12.5 database I do the following:
dump database xxxxxx to "c:\temp\xxxxxxxxx.bkp"
Then on the 15.0 database I load the database:
load database xxxxxx from "c:\temp\xxxxxxxxx.bkp"
The first strange thing here is the following:
Jun 09 12:31:19 2006: Backup Server: 22.214.171.124: Database xxxxxxxxx: 655484
kilobytes (58%) LOADed.
Jun 09 12:31:20 2006: Backup Server: 126.96.36.199: LOAD is complete (database
...dump/load from ASE 12.5.1 Tru64 to ASE 12.5 HPUX
Do you know if there is a way to load on ASE 12.5.1 HP-UX a dump from ASE
12.5.1 Tru64 ? or a dump from ASE 12.5.1 linux RHEL3 ?
nb: support send me a patch 12.5..3 only for backupserver on Tru64 with the
one I can make dump from Tru64 12.5.1 to linux 12.51.
12.5.3 provides for database dump and loads across platforms with different OS and/or hardware (ie, different endianess).
However, there are a few prerequisites ... see the 'New Features' manual for 12.5.3 for details about dumping and
loading between different OS/hardware pl...Migration from ASE-64 bits 188.8.131.52 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 184.108.40.206 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 220.127.116.11 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 18.104.22.168 ...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 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...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...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?
...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?
...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...Loading a 15.5 dump into ASE 15.0.3
I'm trying to insert 30 GB into an existing table in an ASE
15.0.3 database as fast as possible. I want to try using
'insert .. select from ' into a ASE 15.5 minimally logged
database, dump the database and load it into an ASE 15.0.3
Does anyone know I can do the load and will it be faster
than a slow bcp?
Thanks in advance.
Le 18/06/2010 16:14, Andrei R. a �crit :
> I'm trying to insert 30 GB into an existing table in an ASE
> 15.0.3 database as fast as possible. I want to try using
> 'insert .. select from ' into...