I previously posted this to the wrong forum. Sorry for the dupe.
I'm looking for input from any DBAs who have successfully copied whole Oracle Schemas (tables, indexes, views, etc) from Oracle 9i to SqlServer 2000 or 2005. I realize there are some Oracle objects that don't translate directly to SqlServer 2000, but if you have used a shareware or vendor tool to accomplish this task, I'm very interested in hearing about successful experiences and the toolkit(s). Thanks!