All Forums General
BenBor 1 post Joined 01/14
21 Apr 2014
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')?

Raja_KT 1246 posts Joined 07/09
22 Apr 2014

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.

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

Adeel Chaudhry 773 posts Joined 04/08
24 Apr 2014

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.

-- If you are stuck at something .... consider it an opportunity to think anew.

You must sign in to leave a comment.