Archives of the TeradataForum

Message Posted: Mon, 13 Nov 2000 @ 21:18:28 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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

	<Prev	Next>		<<First	<Prev	Next>	Last>>