I had three servers(server1, server2, server3) in availability group. And the listener name is "Production". I have a server name "Acceptance". I need to run a script that which will copy the tables from acceptance to production. Unfortunately, due to some reasons the only option left with me is running the script by linking the acceptance server with production.
1.How can I link the "acceptance" with "Production"?
2.Is it same as just linking 2 servers or is there anything different to link a server with the listener of the availability group?
3.If we copy the tables by linking server with listener, is these tables gonna save in all the three servers which are in availability group?