SQL Server 2005 - Syncronising Tables
Posted on 2009-12-18
I have two machines running SQL server 2005. One (lets call this machine A) has many databases and contains data which is requied by the other machine (machine B). On a nightly basis i want to update a table in a database stored on machine B. The table will be updated from 2 different tables (in different tables) from machine A. The two tables in A also contain different fields from one another....some of these fields also need to be sync'd with the table on machine B (these are nullable fields....so when getting synd with a table not containing these fields then it would have a null).
What is the best way to get this synconisation to work?