Hi

I've move databases with master, msdb with all replication settings (generate script) to new server.

now I execute replication script which I was created in old server until to reach sp_addmergesubscription procedure.

when I execute this procedure, I'm facing this error :

Msg 20086, Level 16, State 1, Procedure sp_addmergesubscription, Line 471
Publication '002-Base' does not support the nosync type because it contains a table that does not have a rowguidcol column.

it works on old server before this!!! where is the problem and how to solve it ?

thanks in advance

Msg 20086, Level 16, State 1, Procedure sp_addmergesubscription, Line 471
Publication '002-Base' does not support the nosync type because it contains a table that does not have a rowguidcol column.

Hi Hamed,

As the error indicates, please check that if there is a rowguid column in the table(s) of the publication. If there is no rowguid column, you can manually create the rowguid column, and ensure that the column has the following properties.

Should be of Uniqueidentifier datatype

Should have the ROWGUIDCOL property set

Should not allow NULLs

Should have a default of newid()

In addition, as you are creating a no- sync subscription, please make sure that the Subscriber already has the schema and initial data for published tables.

Reference:
Merge Replication
sp_addmergesubscription (Transact-SQL)


Thanks,
Lydia Zhang