other replication question

  • Thread starter Thread starter Lloyd Dupont
  • Start date Start date
L

Lloyd Dupont

is it possible to have 2 database slave replicating with the same server ?
of course all my table should have a 'locationid' primary key column to
avoid primary key collision.

so I could have, for example, an Item table in to different database and a
master database with items from both database, perfectly up-to date ?
 
Yes. But you will need to use uniqueidentifier for your primary key columns.
See my other post to your replication question.
 
Back
Top