Moving Table to another SQL server using Linked Server

Question

Hi,

I can't seem to find any information on how exactly to do this. Basically I want to move a particular table on my DB to a remote SQL server, and have write operations (destined for that table) to be written directly to the table on the remote server.

How is this done?

Thanks in advance.

Answer 1

If you have set up one server as a linked server, you should be able to set up one of your tables just as a view, so that operations that happen to it actually happen on the underlying one (on the remote server).

That's the theory at least, and it ought to work, but you should be wary of network latency and things like that. You may find it just doesn't perform well enough, and that you need some sort of a process which polls the table on your database for changes that need to be written back. But then the tables won't be perfectly in sync (for obvious reasons).

Rob