InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comThu, 04 Dec 2008 02:20:41 GMT20http://www.teradata.com/teradataforum/Topic3257-10-1.aspxHi<br><br>We just converted some of our DB2 to TeraData and we had to use and ETL tool for this process. <br><br>You could also try but you have to be careful, downloading from DB2 usning the UNLOAD or DSNTIAUL, then exporting (FTP - BIN) the SYSREC to your machine. Then you need to create the exact structure i.e. DDL on Teradata (remember to convert any DB2 SQL to TeraData, there are not manny),and use MLOAD to load the data into TeraData. <br><br>I have done it once but it is a major trail and erro process before you get it right. It is fast easier with an ETL tool.<br><br>Divvy<br><br>Tue, 03 Jan 2006 01:18:01 GMTDivvyhttp://www.teradata.com/teradataforum/Topic3257-10-1.aspxHi..<br>How r u frnz ?<br>currently am using Mload to Load data from Flat files to Teradata.<br>I wanna know the Process of loading the data from DB2 to Teradata.<br>IS thr any Special tools for dat ?<br>Can plz send me some Sample script?<br>Thanks & Regards<br>satyaWed, 28 Dec 2005 07:58:00 GMTsatya