Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
amsqlguy
Yak Posting Veteran
89 Posts |
 Posted - 2008-07-23 : 09:26:09
|
| Guys,I have to replicate a database, should all the tables in the Parent database have primary keys?Thanks |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-23 : 09:30:24
|
| Yes only for Transactional replication. |
 |
|
|
BALLA
Starting Member
2 Posts |
Posted - 2008-07-23 : 16:56:30
|
quote:
Originally posted by sodeep
Yes only for Transactional replication.
hey i think constraints and triggers are not for replication, |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-07-23 : 17:27:33
|
| Primary key constraints are required on each of the tables that you'd like to replicate with transactional replication. So it's not just "should" but "required".Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
|
|
|
Replication - Primary Key