Converting Oracle SQL*Loader scripts

General
Teradata Employee

Converting Oracle SQL*Loader scripts

I am migrating an Oracle DW to Teradata.

I need to load the same 40 files that are currently loaded.  I have their SQL*Loader control files.

Is there a tool, or a script, that will convert these CTL files to a Teradata script for any of the loading tools (TPT, FastLoad etc')?

2 REPLIES
Enthusiast

Re: Converting Oracle SQL*Loader scripts

I have never heard of any tool that converts sql loader control files to teradata scripts. You can replicate ctl files functionalities using tpt or fastload . Even if a tool exists also for converting-  for complex ctl files like changing data during upload, bad reject handling, complex sql functions etc, I doubt it  brings good results. The features and syntax of SQL Loader utility are different.There maybe issues. If they are not complex ones, then probably no issues.

Teradata Employee

Re: Converting Oracle SQL*Loader scripts

I dont think there exists any tool/script .... even if it does am sure writing 40 Fastload/TPT scripts would be much faster as commpared to converting, testing, finding issues and then re-doing scripts.