We are planning to replicate data from MS SQL Server databases to Teradata RDBMS using SQL Server Replication, and we would like to know whether it is possible or not? if it is possible then what tools we need to have from Teradata side? odbc, tpump or ole load etc.. Please let me know.
Thanks for your time on this!
I dont think we can replicate directly from SQL Server to Teradata.
One of the way it can be done it by using replication tools like Active Mirror to generate flatfiles and load flatfiles into teradata using teradata utilities like fload/mload, odbc or tpt
Another way this can be ( if volume isnt huge and real time feed isnt needed) done by using ETL tool to load the data into Teradata Staging tables.