Dear Gurus,

How can I move all my stroed procedures from SQL Server to Oracle? If I
can do it using DTS then How Can?
Please also tell me Can Oracle Objects also migrate to SQL Server?

Thanks A lot


usman

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

AFAIK you can't. Oracle and SQL Server differ in their syntax and a
migration between the two in an automated manner like this is certainly not
possible in DTS.

Same the other way around also.

You can migrate definitions of tables and data sure but that is about that.

There is a tool that will asses the complexity of the migration + more
information here for Oracle --> SQL Server migration

http://www.microsoft.com/sql/evaluat...are/oracle.asp

--

----------------------------

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


"usman" <usman (AT) isf (DOT) com.pk> wrote