Tips on Migrating to other Server

Asked By 0 points N/A Posted on -
qa-featured

I am planning to transfer data from SQL Server 2008 to Teradata 13.10. Is there any available list of migration tips and traps and data type comparisons? So I can review the worth of transferring to another server.

SHARE
Answered By 0 points N/A #105748

Tips on Migrating to other Server

qa-featured

If you need to transfer data from an SQL server to teradata server, then you can use  a Teradata utility that is known as OLE Access Module, and with it you will be able to go directly from the SQL server to the Teradata. What this utility does is that  it will skip the export to flat file step, and then it will use the Fastload in loading the data  to the table.  

You can get the newer version of teradata which has some added some functionalities, for it will generate Multiload and BTEQ scripts too. You can be able to run Fastexport to the flatfile on only about 70 minutes which a tremendous speed, while the DTS Teradata will take about 180 minutes to be moved to from the SQL server.

Regards
Thompson Locker

 

Login/Register to Answer

Related Questions