Hi, I need to configure this scenario
Part 1: Transactional publication configured in database A, the
subscriber is database B.
Part II: Configure a transactional publication in database B and send it
to database C and D.
I already configure the part 1 of the scenario. But when i try to
configure part B, i have the problem that the tables in database b Dont
have primary key, I try changing this option on each article:
"Delete all data in the the existing table". Assuming that if i already
create the tables with primary key, it will work, but it didnt.
Do somebody know how to configure it?
Thanks a lot for your help.
*** Sent via Developersdex http://www.codecomments.com ***
Maria,
on the article properties, select to take the declarative referential
integrity. This'll ensure that PKs don't become just unique indexes on the
subscriber, and the PKs will be created there.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Sunday, 19 February 2012
Configuring subscription database as publication.
Labels:
configure,
configured,
configuring,
database,
microsoft,
mysql,
oracle,
publication,
scenariopart,
server,
sql,
subscription,
thesubscriber,
transactional
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment