Possible to replicate SQL Server data to Terdata?

• Express12

  SSCoach

  Points: 18514

  More actions

  July 16, 2020 at 2:17 pm

  #3770544

  Is it possible to replicate SQL Server data (using SQL Replication) over to Teradata?  If so, are there instructions available?

  thx in advance

  BT

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  July 17, 2020 at 3:10 pm

  #3770861

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736173

  More actions

  July 17, 2020 at 4:24 pm

  #3770893

  Not supported from MS: https://docs.microsoft.com/en-us/sql/relational-databases/replication/non-sql/non-sql-server-subscribers?view=sql-server-ver15

  This is deprecated in current versions, but it can run.

  Golden Gate had a product to do this, not sure if it is still available: https://grepora.com/2016/12/06/replication-data-sql-server-to-teradata-part-1/

  For most orgs, this would be an ETL job.