Archives of the TeradataForum
Message Posted: Mon, 13 Nov 2000 @ 21:18:28 GMT
Subj: | | Re: Moving objects from Oracle 7.3 to Teradata V2R3 |
|
From: | | Paul Johnson |
We migrated almost 3 billion rows from Oracle 7 to V2R3 earlier this year. All Oracle extracts, and Teradata DDL/pre-load
conditioning/loads were hand crafted with no real issues to report. Lack of an Oracle "Fastexport" style tool was a shame but a simple SQL
Plus unload to the Unix file system did the trick.
Manually creating tables, views and indexes should create no problems, nor should triggers with the later DBMS releases. The Oracle data
maintenance processes were analysed and re-written to make use of Teradata utilities such as Fastload, Multiload etc. Again, no real
problems to report.
I think it's a fundamentally flawed approach to point an off the shelf software app at Oracle and ask it to migrate to Teradata, or any
other DBMS for that matter. There are a multitude of physical design decisions to make when migrating from one platform to another. Simply
doing a drag-and-drop is an approach fraught with potential problems.
Paul Johnson
UK
|