MS SQL Data Warehousing - DTS migration to Oracle

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

DTS migration to Oracle

Filipe Ganhão

2006-01-27, 7:23 am

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

Peter Nolan

2006-01-31, 1:23 pm

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

Sponsored Links