dbTalk Databases Forums  

Loading a dump from Solaris to Linux

comp.databases.sybase comp.databases.sybase


Discuss Loading a dump from Solaris to Linux in the comp.databases.sybase forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Kennett
 
Posts: n/a

Default Loading a dump from Solaris to Linux - 05-14-2004 , 12:00 PM






Hi all,

I'd like to know if loading a dump from a Solaris box (64 bit Sparc,
running 12.5.0) can be loaded onto a box running Linux (32 bit Intel)
both using 4bit pages?

Thanks,

Kennett

Reply With Quote
  #2  
Old   
Michael Peppler
 
Posts: n/a

Default Re: Loading a dump from Solaris to Linux - 05-14-2004 , 02:23 PM






On Fri, 14 May 2004 17:00:28 +0000, Kennett wrote:

Quote:
Hi all,

I'd like to know if loading a dump from a Solaris box (64 bit Sparc,
running 12.5.0) can be loaded onto a box running Linux (32 bit Intel) both
using 4bit pages?
No, not at the moment. This capability is apparently being worked on, and
should be available either later this year, or early next year.

In the meantime you can use the sybmigrate tool, or write an ad-hoc bcp
out/bcp in script.

Michael
--
Michael Peppler Data Migrations, Inc.
mpeppler (AT) peppler (DOT) org http://www.peppler.org/
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or
long term contract positions - http://www.peppler.org/resume.html



Reply With Quote
  #3  
Old   
noone
 
Posts: n/a

Default Re: Loading a dump from Solaris to Linux - 05-14-2004 , 07:37 PM



Michael Peppler wrote:
Quote:
On Fri, 14 May 2004 17:00:28 +0000, Kennett wrote:


Hi all,

I'd like to know if loading a dump from a Solaris box (64 bit Sparc,
running 12.5.0) can be loaded onto a box running Linux (32 bit Intel) both
using 4bit pages?


No, not at the moment. This capability is apparently being worked on, and
should be available either later this year, or early next year.

In the meantime you can use the sybmigrate tool, or write an ad-hoc bcp
out/bcp in script.

Michael
What is it exactly in a dump from an 32-bit ASE on 64-bit Solaris that
prevents it from being loaded onto a 32-bit ASE on Linux, even if the
disk allocations are similar ?



Reply With Quote
  #4  
Old   
Bret Halford
 
Posts: n/a

Default Re: Loading a dump from Solaris to Linux - 05-17-2004 , 01:48 PM



noone <noone (AT) noone (DOT) org> wrote

Quote:
Michael Peppler wrote:
On Fri, 14 May 2004 17:00:28 +0000, Kennett wrote:


Hi all,

I'd like to know if loading a dump from a Solaris box (64 bit Sparc,
running 12.5.0) can be loaded onto a box running Linux (32 bit Intel) both
using 4bit pages?


No, not at the moment. This capability is apparently being worked on, and
should be available either later this year, or early next year.

In the meantime you can use the sybmigrate tool, or write an ad-hoc bcp
out/bcp in script.

Michael

What is it exactly in a dump from an 32-bit ASE on 64-bit Solaris that
prevents it from being loaded onto a 32-bit ASE on Linux, even if the
disk allocations are similar ?
The dump file mostly consists of page images. The main sticking point
is that Solaris (on Sparc) and Linux (on x86) are on opposite sides
of the big-endian / little endian divide; they store multibyte values
with the bytes in different orders.

-bret


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.