Transaction replication identity propery question
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
Hi all,
What are some of the pros and cons of NOT transferring the identity column
to the subscriber when using transactional replication?
I am wondering if it is worth the trouble to fix this issue?
Also, if I change can the identity column to "Yes (not for replication)"
will this solve the problem?
Thank you.
JN
.
Relevant Pages
- Re: Identity error in replication
... >From the name of the sp, it appears you are using transactional replication. ... Is this TR with updating subscribers or non-updating. ... case there shouldn't be an identity column on the subscriber. ...
(microsoft.public.sqlserver.replication) - Re: question regarding replication
... that will be inserted via replication and those by other means. ... However, if replication is the only thing doing DML at the subscriber, ... should get you through your identity column issue. ... snapshot and generate new snapshot. ...
(microsoft.public.sqlserver.replication) - identity value is not reseeding in subscriber
... Setup distributor. ... Restored full backup followed by T-Log backups (from publisher db to ... subscriber db) until the production maintenance window started. ... Now transactional replication has been running successfully and data in both ...
(microsoft.public.sqlserver.replication) - Re: Identity columns
... and then on the subscriber. ... The NFR property is necessary when a replication process is doing inserts on ... Create table idTest ... It also fails if you have an identity column existing on a table ...
(microsoft.public.sqlserver.replication) - Re: Identity columns
... subscriber machine the column is not marked as an identity column.. ... involved in replication but this means that the column on the subscriber ... (your failover server) ...
(microsoft.public.sqlserver.replication) |
|
