I am working on a project which is intended to migrate our SQL Server DataBases to TeraData. We are using TD 13.10.
1. I have tried OleLoad. But using this we can only export one table at a time.
2. I have used EFS Tools. But data Conversion is wrong.
3. For using MultiLoad we have to write the script for all the table separately.
My requirement is that I will give the source database(from sql server) and then target as TeraData. Now it should happen that all the tables from the
source database should be migrated(With Schema if Table Doesn't exist) with data(if there), to the TeraData.
Kindly Provide solution for this.
Thank you in Advance :)
You can uses SSIS and Teradata connector to load data .. ou might have to do some transformation to support data types
I think you can write a procedure that will generate all the Teradata equalent DDL's for all the tables in SQL Server. Once the DDL's are deployed then you can copy data using the following options: