Let me open by saying that I am no MSSQL expert. I'm a linux admin, so please forgive me if I should know this.
I've been asked to syncronise a view or a table from one MSSQL database to another. I've been told it's a bit like MySQL replication, except that instead of the whole database, it's just one table. Or in the case of MSSQL, the results of a particular search, or whatever, basically a subset of the data in the main database.
I understand the concept, I just do not know the MS way of doing things. Any hints and tips to point me in the right direction would be great. Starting with maybe the correct terminology!
Thanks for helping out a newbie!