| Author |
 Topic  |
|
|
angeloo
Starting Member
Mexico
1 Posts |
 Posted - 11/01/2012 : 11:49:34
|
Hi DBA´s, I need help with issue of transactional replication,
this issues is , when i want to create a transactional replication at time of select the articles to publicate, in the botton of the wizard appear a message that say, This table cannot be published because it does not have a primary key column. Primary key columns are required for all tables in transactional publications.
Someone to help fix this issue.
Thank for you help.  |
|
|
prett
Posting Yak Master
USA
161 Posts |
Posted - 11/05/2012 : 22:52:13
|
In transactional replication, it need a primary key for each table to replicate. It is a way to uniquely identify each row of a replicated table, so that, when changes to a row are replicated to the subscribers, there's no doubt as to which row the change must be applied.
Snapshot replication, since it just copies tables as they appeared at a specific point, does not have this requirement.
|
 |
|
|
sodeep
Flowing Fount of Yak Knowledge
USA
7173 Posts |
Posted - 11/16/2012 : 22:51:48
|
| Primary Key is important in Database world. |
|
|
| |
Topic |
|
|
|
Replication issue
