N/APosted 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.
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,