Re: Cross platform replication (from solaris to linux) using dump and load
Solaris is on a SPARC processor
Linux is on an Intel x86 or similar
In this sceanario the answer is no for both ASE dump and load commands and binary bcp. This is because the SPARC and Intel CPUs represent multibyte values (int, shortint) differently. On SPARC the value of 256 is represeted as 0x0100. On an Intel platform this is 0x0001. SPARC is big endian and Intel is Little Endian. Refering to which byte comes first, either the Most Significant (SPARC) or Least Significant (Intel).
Sybase don't support copying binary data across platforms.
Character bcp may be used, but as you say this is not physically possible. Is is possible to compress the bcp files before transfering them.
You should be able to use Replication Server for this task, but you don't state whether that is available or not.
Proxy tables/database may be an option. Create a proxy database on the Linux based ASE and then create another database with the "select into/bulkcopy/pll sort" option swiched on and use select into to copy the data. I suspect this may also run into the same problem as bcp because of your ISP connection.