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
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
No comments:
Post a Comment