When you say you need to do it in SQL Server and Oracle does this mean you are migrating from One to the other or that you have two systems that need to be migrated to the same RDBMS on another box. By far the simplest way for the former is BACKUP
and RESTORE. For the latter your problem comes when you have RDBMS specific code to export. Sure DTS will move data and structure between the two RDBMS's but not Relationships, Functions, Indexes, etc etc

You may get some ideas here

http://search.microsoft.com/search/r...u=oracle&na=30

but it won't be as easy as BACKUP RESTORE


--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org