Insert data across different server from Trigger
I would like to know, which is the best method for data transfer across two different SQL servers. My requirement is, to get data from one server and populate tables on the other. is it okay if I use trigger on the first Server's table? Data flow is only one way. From first server to second.