Good day! I'm somewhat stuck with this situation: My system works with certain tables that I copy exactly from another system (another SQL server). Currently I do it manually (I compare the records that were modified on a certain date and replace them in my table and add if there are new ones).
What I need is to make a script so that at a specific time of the day, make a complete replacement of the source-to-destination table, regardless of the existing data. (clarification: it is done through a VPN) I suppose that it is first a drop of my table but it is something that I also want to avoid, since if a cut occurs in the middle of the transfer I would be left without data.
I was reading several ways to do it, ( link ) but in all it does is a copy when the table still does not exist in the destination instance
Thank you very much in advance.