Yes, but not necessarily "all objects". Use OLE DB to connect to Oracle.
Some objects don't translate well, there are data type issues, and some
stored procedures are not going to be compatible with SQL Server.

I know the people at DBBest have tools and expertise migrating from Oracle
to SQL Server:

http://www.dbbest.com/

You might check them or follow up with me.

Tom Spitzer
EC Wise, Inc.
tspitzer (AT) ecwise (DOT) com

"Matias" <Matias (AT) discussions (DOT) microsoft.com> wrote

Hi,

You can try SwisSQL oracle to SQL Server migration tool. it offers
upto 70% automated migration.

Download a 30 day evaluation copy
-------------------------------------
Migrate 1000 line of Oracle PL/SQL to SQL Server Transact SQL.

http://www.swissql.com/oracle-to-sql-server.html

100 lines of Online migration
------------------------------
Visit http://www.swissql.com and click on the Try it Online button to
migrate 100 lines.

Cheers

Alex Paul

SwisSQL Team
www.swissql.com



"Tom Spitzer" <tkspitzer_snip (AT) snip_ecwise (DOT) com> wrote