Is there another secured way to transfer data between 2 different SQL server instances residing in 2 separate boxes besides linking them? What if they are different versions and the OS in the boxes is different as well? For example:
Boxes OS SQL Server version
Box1 Windows Server 2008 SP1 SQL Server 2008
Box2 Windows Server 2012 SQL Server 2012
We need to pass data between one SQL server instance to another via triggers and stored procedures. Can this be done without linking them?