Which type of Replication is it called ??
Hi
I had prepared two environments for data replication.
Both have the same database structure but with different DB Names.
I need only to replicate two tables between the databases. One table is users, which have user ID as a primary key. The second table is userImg, which is referencing the userid image.
From the first site , it should store user IDs from 1 to 10000 , where the second site it should start storing user ids from 10001 till 20000.
I need to know which type of replication that I should use to replicate from site A the userID and its references in table userImgs from 1-10000 to Site B , at the same time Site B should replicate the same from userID 10001, so almost the two sites have almost the same data ?