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?
Sql-server – Partial SQL Server database synchronization
data synchronizationsql server
Related Question
- SQL Server – Schema Unusable After Deleting Another Database
- SQL Server 2012 – How to Replicate Data Between Two Servers
- How to Write a Trigger to Change Table Name Automatically in SQL Server
- SQL Server – Cross Database or Server References Using Relative Path
- SQL Server – Replication and Mirroring Stuck in LOG_BACKUP
- Sql-server – Query on Linked Server in SQL Active-Passive
Best Answer
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.