1

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?

1

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.