I have an application where i have to download data from Teradata into SQL Server, update data in SQL Server and push it back to Teradata server.
I am able to import data from Teradata into SQL server using SQL Bulk Copy. I am trying to see how to push data to Teradata.
I have tried multiple ways but nothing seems to be working for me. I want to Bulk load data into Teradata from SQL.
1. Should i export the data from SQL Server to file and then Bulk load into Teradata?
2. If I want to open a reader and push the data directly to Teradata, what are my options?
Which option would be faster?
Thanks in advance
You can use Teradata OLE DB Access Module to bulk copy data from Teradta to SQL Server or reverse. You can use GUI tool to setup batch process too.