Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 208
  • Last Modified:

POINTER: Oracle on Solaris connecting to SQL Server on Windows

1 Solution
This question really has nothing to do with Solaris - literally nothing.  The vaguely closest thing is the endian architecture of the system the OS is running on - notice I said OS and not Solaris.  If Solaris is running on a SPARC chip, then the bits will be ordered within Oracle using Big Endian.  SQL server is running on a Little Endian machine and is probably Little Endian ordered.  From what I recall - and I'm not a DB - I'm almost positive to manually to get data from a Big Endian machine to a Little Endian machine you have to perform a database export on the Big Endian machine and then import the export into the Little Endian DB instance.  You can't just copy the files over like you can between say to SPARC servers.

But again, the *endian* nature of the data has nothing to do with Solaris - Solaris is bound by the Endian laws just like Windows is.  You can't go from Big Endian to Little Endian with a middle translation process.
davidlars99Author Commented:
thank you!

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now