Migration of LOB data from Teradata to SQLDW

General
Enthusiast

Migration of LOB data from Teradata to SQLDW

We need to migrate data of tables including Teradata to SQL Datawarehouse in Azure cloud.

The tables will also include BLOB/CLOB columns.We are thinking of offloading using 2 steps:

1)Export the data using from Teradata.

2)Upload the data into SQL Datawarehouse

 

 

I would like to know if TPT is the best option to achieve point 1 or is there any other option.

If the data is exported from Teradata using TPT will  it be  possible for the downstream system to process and load the same into  SQLDW? 

1 REPLY
Enthusiast

Re: Migration of LOB data from Teradata to SQLDW

Yes. TPT EXPORT/SELECTOR operator can be used to offload the data from Teradata depending on which downstream tool you are planning to Use.