Is it possible to simply

* dump my Unix based 11.5.1 databases to the unix filesystem
* ftp the dumps over to intel
* load them into a intel-based 12.x sybase server ?

(the data/log segments are idential on both ends)
--
h3ctic

"h3ctic" <h3ctic (AT) notsohotmail (DOT) com> wrote in
news:gp4Xb.3607$_c4.51172 (AT) news4 (DOT) e.nsc.no:

This depends on the endianness of the two boxes. If they're both
the same, it'll work.
--
Pablo Sanchez - Blueoak Database Engineering, Inc
http://www.blueoakdb.com

Thanks for the very fast reply Pablo.

Could you please elaborate what you mean by:

"This depends on the endianness of the two boxes"

(English is not my first language)
--
h3ctic

On Fri, 13 Feb 2004 15:19:53 +0100, h3ctic wrote:

Intel machines are little-endian, meaning that the 32bit number 1 is
stored as 01 00 00 00 in the machine. SPARC processors are big-endian,
meaning that the same number is stored as 00 00 00 01. Sybase's database
dumps are binary copies of the database, and as such can only be used on
architectures that use the same binary representation for various
datatypes (integers and float, in particular).

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

<snip>
Thanks Michael,

Im not sure how I can verify this tho. We're running HPUX:

/ #sys_info
hostname = xxxxx
model = 9000/899/K570
OS release level= B.11.00 (32-bit)
processor count = 4
CPU type = PA20
clock speed = 200 MHz
memory = 2.5 GB
/ #

is there another command I can run to get more info (if needed) ?
--
h3ctic