How I can publish tables wihout primary key in transactiona Replication?
Dave,
you can't If at all possible, just add the PK.
As a workaround, if schema changes are not allowed, I suppose you could
create an indexed view and transactionally replicate this, but this is not a
nice solution.
Equally not-nice is to use a trigger to synchronize another table (which
itself has a PK) and replicate that.
Finally, you could use snapshot or merge replication (EXCHANGETYPE to force
downloads only), but these may not be appropriate due to their nature of
replication.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Wednesday, March 21, 2012
Primary Key in Transactional Replication
Labels:
database,
key,
microsoft,
mysql,
oracle,
primary,
publish,
replication,
server,
sql,
tables,
transactiona,
transactional,
wihout
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment