DTS migration to Oracle

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Filipe Ganhão - 27 Jan 2006 10:49 GMT

Hi!

Do you know any tool ou method to help the migration of an entire DW
repository in SQL Server 2000 to Oracle? And I mean the Dtata Transformation
Services too... I think it is veru difficult to migrate DTS to DML in
Oracle, but who knows there is some tool that transforms DTSs into PL/SQL (I
doubt it, but...).

thanks.

FPG

Reply to this Message

Peter Nolan - 31 Jan 2006 18:26 GMT

Hi Filipe,
you are out of luck as far as I am aware.....there are few tools to
convert etl from one thing to another.....I always recommend to my
clients to use ETL tools that can move from one database to another
with zero changes....and I liked the idea so much I wrote one for
myself...LOL!

At least if you can move your entire ETL/BI subsystem from one OS/RDBMS
platform to another you can push the vendor for a better deal on
maintenance...if you are lucky...

Best Regards

Peter Nolan
www.peternolan.com

Reply to this Message