SQL Server Performance Forum – Threads Archive
identity not transfered in snapshot replication
Hii am tryin g to replicate a database its working fine but the problem is the identity columns are replicated but not the properties like primary keys are replicated as int but not as identity anyone have any idea?
Try creating the subscription table manually using the IDENTITY property and the NOT FOR REPLICATION option. You can have SQL Server execute a custom script to perform this action before the snapshot is applied. To specify a custom script, create the publication, create the script, and enter the script name on the Snapshot tab of the publication properties. Set the name conflicts article property so that SQL Server does not drop an existing table when applying the snapshot at the Subscriber. This property is on the Snapshot tab of article properties. For more information refer to books online. HTH Satya SKJ
]]>