Migration : ASE V12 (HP UX 11) to ASE V 12.5.3 (AIX 5.3)

Hi,


I have to migrate a DB ASE 12.0.0.8 from HP (HP UX 11) to ASE 12.5.3 
(IBM AIX 5.3)

here are the characteristics:

HP UX
------
The default Unix charset on the platform is Roman8.
The ASE/db Charset is UTF8

AIX (5.3)
---
The default Unix charset on the platform is Iso
The ASE/db Charset will be UTF8


Someone told me Cross-platform DUMP/RELOAD is not possible. note that I 
didn't try it yet, but i will. Does anyone know about that ?

If this is not possible i'll have to use 'bcp' IN/OUT i guess ? but i 
dont know exactly what syntax i should use with BCP.  I guess i should 
consider '-J' option but which charset should i use for the Bcp Out and 
the Bcp IN ?

should i only use '-Jutf8' for Bcp in/out ?  and Does the Unix platform 
charset interact ?

Thnx for any help

L.
0
LBaudet
5/22/2006 9:53:54 PM
sybase.ase.upgrades+migration 687 articles. 0 followers. Follow

2 Replies
891 Views

Similar Articles

[PageSpeed] 23

> Hi,
>
>
> I have to migrate a DB ASE 12.0.0.8 from HP (HP UX 11) to
> ASE 12.5.3  (IBM AIX 5.3)
>
> here are the characteristics:
>
> HP UX
> ------
> The default Unix charset on the platform is Roman8.
> The ASE/db Charset is UTF8
>
> AIX (5.3)
> ---
> The default Unix charset on the platform is Iso
> The ASE/db Charset will be UTF8
>
>
> Someone told me Cross-platform DUMP/RELOAD is not
> possible. note that I  didn't try it yet, but i will. Does
> anyone know about that ?

You have the same charset and sort order on the source and
destination servers, so as long as you have the same page
size on both servers you should be able to perform a dump
and load operation with no particular problems.

I've migrated from ASE 11.5.x HP-UX to 12.5.3 (AIX) via
dump/load successfully, so I can confirm that it works :-)

Michael
0
mpeppler
5/23/2006 9:30:55 AM
> > Hi,
> >
> >
> > I have to migrate a DB ASE 12.0.0.8 from HP (HP UX 11)
> > to ASE 12.5.3  (IBM AIX 5.3)
> >
> > here are the characteristics:
> >
> > HP UX
> > ------
> > The default Unix charset on the platform is Roman8.
> > The ASE/db Charset is UTF8
> >
> > AIX (5.3)
> > ---
> > The default Unix charset on the platform is Iso
> > The ASE/db Charset will be UTF8
> >
> >
> > Someone told me Cross-platform DUMP/RELOAD is not
> > possible. note that I  didn't try it yet, but i will.
> > Does anyone know about that ?
>
> You have the same charset and sort order on the source and
> destination servers, so as long as you have the same page
> size on both servers you should be able to perform a dump
> and load operation with no particular problems.
>
> I've migrated from ASE 11.5.x HP-UX to 12.5.3 (AIX) via
> dump/load successfully, so I can confirm that it works :-)
>
> Michael

Thnx Michael,

i contacted sybase support today, and they confirm that
cross-platform dump/load is working since ASE 12.5.3 :o)

Thnx you anyway for your answer :o)

L.
0
Lbaudet
5/23/2006 1:00:54 PM
Reply:

Similar Artilces:

Migration from ASE-64 bits 12.5.0.2 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 12.5.0.2 to ASE 12.5.3 on unix 5.3 ? (64 bits) Thank you kamel wrote: > Here there someone to indicate me the road tasks in order to > migrate an ASE 12.5.0.2 to ASE 12.5.3 on unix 5.3 ? (64 > bits) > > Thank you Apply 12.5.2 IR then 12.5.3 esd 5. -- Jason L. Froebe http://jfroebe.livejournal.com http://www.propsmart.com Team Sybase 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 12.5.0.2 ...

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? Thanks! ...

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 version? Fabien DUBOIS 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...

looking for recommendations about installing ASE 12.5.2 and ASE 12.5.3 on HP-UX IPF
Hi, We are about to install ASE 12.5.3 esd#7 64bit on HP-UX IPF server. Are they any recommendations regarding installing on HP Itanium 64bit servers? Is there a best practices document for ASE 12.5.3 ? thanks. Itzhak. izik_is@yahoo.com wrote: > > Hi, We are about to install ASE 12.5.3 esd#7 64bit on HP-UX IPF > server. > Are they any recommendations regarding installing on HP Itanium 64bit > servers? > Is there a best practices document for ASE 12.5.3 ? There's no specific document. There are comments and recommendations in the SAG (System Admi...

Migration from ASE 11.5 to ASE 12.5
Hello I am planning the migration from Sybase 11.5 to 12.5. Can someone point me to some documentation on the subject? I am particularly interested in documents that explain the best way to migrate database objects (tables, indexes, etc...) and data. Thanks in advance. Jorge Vergara Sispro S.A. Canoas - RS - Brasil jlvergara@sispro.com.br wrote... > Hello > > I am planning the migration from Sybase 11.5 to 12.5. Can someone point > me to some documentation on the subject? > I am particularly interested in documents that explain the b...

Upgrade from ASE 12.5.0.3 to ASE 12.5.1
This is a multi-part message in MIME format. ---=_forums-2-dub3ff97039 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hi, I've just upgraded from ASE 12.5.0.3 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 file /app/sybase/SYSAM-1_0/licenses/license.dat. 00:00000:00000:2004/01/05 21:37:44.10 ker...

Vulnerability of ASE 12.5.2 vs ASE 12.5.3 ESD#3
Recently, Application Security, Inc. has run a vulnerability test on our ASE12.5.2. The program gave a 'high risk' on the ASE12.5.2 and suggested we install the latest Sybase patch 12.5.3 ESD#3. I have some question on the recommendation. 1. The latest patch is definitely not 12.5.3 ESD#3. Why did the program recommend 12.5.3 ESD#3? Isn't 12.5.4 better than 12.5.3? 2. Is it practical to keep up with the latest releases or patches? Now if we upgrade to 12.5.4 and then rerun the vulnerability test, will the program suggest that newer version is better with respect to s...

ASE 12.5.0.3 to ASE 12.5.4 upgrade path
I would like to know if the migration from ASE 12.5.0.3 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. http://sybooks.sybase.com/nav/detail.do?docset=1287 <passerby> wrote in message news:484e9ca8.3f0d.1681692777@sybase.com... >I would like to know if the migration from ASE 12.5.0.3 to > 12.5.4 a direct migration or is there an intermediate > upgrade to be performed in between? ...

ASE 12.5 to ASE 12.5.3
One of our client is having 3 no license for ASE 12.5 on Win2K (running 3 production servers) and not in the support/AMC with Sybase.. is client eligible to use ASE 12.5.3 ? Thanks KRV ...

Same machine: ASE 12.5.3 Linux vs ASE 12.5.3 Windows
We had a report from one of our clients recently that our Sybase ASE-based app was running slowly on their new Linux box. As we develop internally against ASE on Windows we thought it would be an interesting test to install both the Windows and Linux flavors of ASE 12.5.3 onto the same server and look at the relative performance. We used a Dell PowerEdge 1950 with 2 x Intel Xeon 3.73GHz dual core processors. On one drive we put SuSE Enterprise Linux Server 10 x86-64, and on the other we put Windows Server 2003 Std R2 64-bit edition. Both were fresh-off-the-CD OS installs. ...

ASE 12.5.0.3 -> 12.5.3 Upgrade
Hi, I may have to upgrade my ASE 12.5.0.3 64-bit Solaris server to ASE 12.5.3. I am curious if I can download the latest EBF for ASE 12.5.3 and do a srvupgrade or what do I do exactly? Thanks in advance, Shahryar -- Shahryar G. Hashemi | Sr. DBA Consultant InfoSpace, Inc. 601 108th Ave NE | Suite 1200 | Bellevue, WA 98004 USA Mobile +1 206.459.6203 | Office +1 425.201.8853 | Fax +1 425.201.6150 shashem@infospace.com | www.infospaceinc.com This e-mail and any attachments may contain confidential information that is legally privileged. The information is...

How do I upgrade/migrate from AS 11.5.1 to ASE 12.4.3
Hi, I'm looking to upgrade from Adaptive Server 11.5.1 (running on Solaris 2.6) to Adaptive Server Enterprise (I think) 12.4.3 (running on Solaris 2.6). I have a couple of queries: a) Can I do a straight-forward update of the database software or do I have to do a formal data migration ? b) Is there any documentation out there that I can use to assess the impact of having to do this upgrade/migration ? - in particular I am worried that I will have to update all of the stored procedures/code etc. Thanks for your help. Rob_Scurr wrote... > Hi, > > I'...

Does the secondary truncation point in the Adaptive Server need to be dsiable when upgrading ASE 12.5.03 to ASE 12.5.3
This is a multi-part message in MIME format. ------=_NextPart_000_0006_01C5C408.CA053AD0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Does the secondary truncation point in the Adaptive Server need to be = disabled when upgrading ASE 12.5.03 to ASE 12.5.3? Thanks ------=_NextPart_000_0006_01C5C408.CA053AD0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <...

Web resources about - Migration : ASE V12 (HP UX 11) to ASE V 12.5.3 (AIX 5.3) - sybase.ase.upgrades+migration

Migration - Wikipedia, the free encyclopedia
Text is available under the Creative Commons Attribution-ShareAlike License ;additional terms may apply. By using this site, you agree to the ...

EU-Turkey summit to center on stemming migration flow
EU-Turkey summit to center on stemming migration flow

Security is a major concern for cloud migrations
... Moreover, 40 percent worry about the loss of physical control over data in the cloud. In particular, 69 percent of companies fear migration ...

THE US EMV MIGRATION REPORT: What new chip cards mean for consumers, issuers, and merchants
... includes cards that store user information on a chip rather than a magnetic stripe — to make card-present payments more secure. The migration, ...

Migration to Windows 10 to be fastest yet, says Gartner
Windows 10 is poised to become the most widely installed version of Windows ever, following on the path of Windows XP and Windows 7 before it, ...

Huawei, Telefonica Partner on Enterprises Cloud Migration
The first countries where the enterprise cloud service will be deployed are Brazil, Mexico and Chile during the first quarter of 2016.

Africa-Europe: The politics of migration
While Western eyes have recently focused on the east and arrivals from Syria and Afghanistan, people from a dozen or so African countries continue ...

High skilled migration and global innovation
... using a multi-country endogenous growth model. The proposed framework introduces and quantifies a “frontier growth effect” of skilled migration: ...

MarTech Today: Google’s Rich Snippets, Dynamic Number Insertion & Site Migration
Here’s our daily recap of what happened in marketing technology, as reported on Marketing Land and other places across the web. From Marketing ...

6 ways to cut the cost and pain of a Windows 10 migration
... past two years, the cost and frustration was not only high, the resources required were crippling. But ready or not, chances are a new migration ...

Resources last updated: 12/10/2015 8:33:52 PM