SQL Server Performance

identity not transfered in snapshot replication

Discussion in 'Performance Tuning for SQL Server Replication' started by shreesoft00, Feb 28, 2003.

  1. shreesoft00 New Member

    Hi
    i 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?
  2. satya Moderator

    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

Share This Page