Welcome, new member!
It must be possible.
Maybe to shortest route is to use a tool that can acces both databases. (i used something like SmartModeler, which could create data-schemas for a multiple of databases. It could do reverse enginering aswell). Use that tool to read the MS SQL schema. Then let the tool create a Oracle script that builds the tablespaces, schemas, tables, indexes, etc, etc. If you don't have the tool, than you maybe have to manually create the objects in Oracle.
The data.
Let MS SQL create a Comma Separated Value-file with all the data. You can load that into Oracle with SQLLoader.
Good luck!
Last edited by efrijters; 12-11-2003 at 11:04 AM.
An expert is one who knows more and more about less and less until he knows absolutely everything about nothing.
Reply With Quote