POINTER: Oracle on Solaris connecting to SQL Server on Windows

LVL 13
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
davidlars99Author Commented:
thank you!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Unix OS

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.