I have 2 different database (A and B) in a sql server 2008. Databse A has around 100 tables out of which i want to synchronize 15 tables from database A to database B. So if any addition/deletion/updation happens on those 15 tables then those entries should be updated on database B.
But here the challenge is i will have different Primary key data in source and target, i.e. lets say one row is added to Database A-Table A with pk value as 10 then when i will copy that row to Database B- Table A, PK might be auto generated and can have any value other than 10. And there might be case wheere target table will not have all the fields as of source table.
Same way i need to keep track of update and delete.
Can anybody suggest me what will be the best solution?