August 4, 2009 at 3:20 am
what are the differences between snapshot and transactional replications?
August 4, 2009 at 3:48 am
In simple
Snapshot replication
snapshot replication generates an initial snapshot of the schema and data from the publisher and applies them to the subscriber. Any subsequent changes like insertion of rows,deletion and updation of data does not reflect at subscriber after configuring snapshot replication.
transactional replication:
it generates an initial snapshot of the schema and data from the publisher and applies them to subscriber. after configuring the replicational if you add any rows/modify/delete at the publisher will get reflected at the subscriber.
[font="Verdana"]Thanks
Chandra Mohan[/font]
August 4, 2009 at 4:15 am
thanks.........
a table without primarykey.
i am trying to transactional replicate then it popup error as it is not possible to replicate without primarykey.
can u pls let me know the reason.
August 4, 2009 at 4:19 am
Primary Key is must for table Participating in Transaction Replication.
August 4, 2009 at 4:55 am
exact error is below....
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.
August 4, 2009 at 5:06 am
For table to be replicated in transactional replication it is must that it should have a primary key. Otherwise it cannot be part of transactional replication.
[font="Verdana"]Thanks
Chandra Mohan[/font]
August 4, 2009 at 5:31 am
charipg (8/4/2009)
thanks.........a table without primarykey.
i am trying to transactional replicate then it popup error as it is not possible to replicate without primarykey.
can u pls let me know the reason.
The reason is, the insert/update/delete are done in the subsciber one row at a time using the primary key.
August 4, 2009 at 6:03 am
thanks........
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply