Connecting two databases in two different servers

Database
Enthusiast

Connecting two databases in two different servers

Hello,

 

I need to know please if there is any method to connect two databases existing on two different servers in order to copy table data from the DB on production server to the DB on DR server without using Import/export in sql assistant or fastexport/fastload.

The main goal is to SELECT from DB(Production server) and INSERT to DB(DR server).

Is there any tool to be used in Teradata?(SecureCRT,putty..)

 

Thank you