• Yes, the SWITCH requires partitioning.

    Linked Servers do allow separate db servers to connect to one another. Other approaches such as replication and log shipping are used to keep the data the same in both tables which is not what you are trying to do, so linked servers is probably the best approach for you.

    Zach Mided
    www.AllianceGlobalServices.com