I have 2 SQL Server databases and they have somewhat different schemas. But there is a table with person attributes. Name, address, city, email, etc... And an account key. on both tables. Can SQL Server be set up to sync just these attributes. On this table? And not the entire database? And, is there a way to log when data is overwritten from db1 to db2. or db2 to db1?
closed as too broad by mustaccio, Colin 't Hart, Tom V, joanolo, Marco Jun 13 '17 at 9:34
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
If you want a real-time sync you can use replication and select only that table as an article. If you don't need real-time sync and let's say you only need to sync the table once a day, you can create a job scheduled as you need and this job will execute an SSIS package that will move the data from one table to the other.