Requires Free Membership to View
If using HS isn't an option for you or you can't handle the limitations of
that solution, or if you just need to move data one time, then:
-- investigate generation of a flat file (using isql's bcopy feature probably)
that could be loaded with SQL*Loader on Oracle.
-- investigate using an ODBC driver to connect to Oracle and SQL at the same
time via a front-end like MS Access or similar tool and transfer the data
directly using that tool.
This was first published in June 2004

Join the conversationComment
Share
Comments
Results
Contribute to the conversation