Archives of the TeradataForum

Message Posted: Fri, 20 Aug 1999 @ 12:20:44 GMT

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

Angela Maria,

Ora2td is very good. I have used it and it works fine. If you have access to a UNIX machine (your Teradata machine will do) you can use it to generate the SQLPlus scripts to extract the Oracle data; the DDLs to create the Teradata tables and the Fastloads to run the loads. If you wanted to run it all from NT you could move the scripts down there and strip the shell script stuff out. Ora2td does make some assumptions about data types - check the documentation

Alternatively, if this is a one off, you could get a 90 day trial of SQL Server 7 (if you do not have it already) and use DTS (data transformation services). The good news about DTS is that you can do it all from wizards - including data type conversions. The bad news is that it is not going to be very fast - basically row a time. It is excruciating if you have a slow network and a lot of data. Someone (maybe me eventually) will get around to writing a Fastload plug in for DTS - it would not be too hard. Maybe someone has already? Maybe they'd like to share it?

Adios,

Bob Doss

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