Tips on Migrating to other Server

Asked By ann murray 0 points N/A Posted on - 11/29/2011

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.

• Status: Open
• Question Views: 908
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: File Servers

Answered By Thompson Locker 10 points N/A #105748

Tips on Migrating to other Server

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

 

About Thompson Locker

Questions
0

Answers
619

Best Answers
77

• Vote Up 0 Vote Down

• Posted on - 12/17/2011
• Question Category: File Servers