Moving data from SQL Server 2008 to Teradata 13.10 safely

Asked By Victoria Castro 0 points N/A Posted on - 01/21/2012

I need to move data from SQL Server 2008 to Teradata 13.10. But before I do that I need some information on how to ascertain the correctness of the moved data. Is there anyone willing to provide me with a data type comparison list? Do you know of any tips to follow and traps to evade when carrying out the data move. Please assist me so I can avoid mistakes when moving the data.

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

• Answer Accepted: No
• Question Category: Content Management

Answered By ELM_Steve 0 points N/A #109206

Moving data from SQL Server 2008 to Teradata 13.10 safely

Hi Victoria Castro,

If you need to move data from SQL Server 2008 to Teradata 13.10, then I will suggest using SSIS (SQL Server Integration Services). If your intentions are just to move data from one database (SQL Server) to another (Teradata 13.10) then this is the best choice. Just for your ease, Microsoft and some other people already wrote these kinds of scripts, you just have to use those scripts, change connection strings and that’s it. Your data will start migrating. SSIS is actually an Extraction, Transforming and Loading tool. Through this you can Extract data, Transform this (This will handle your data type issues) and can load it into another database.

Best of Luck,

Regards,          

ELM_Steve

About ELM_Steve

Questions
0

Answers
27

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 01/23/2012
• Question Category: Content Management