SQL Server Express 2014 Merge Replication

Paul Bill 66 Reputation points
2020-12-11T15:17:30.633+00:00

I have a address table that has a geography field in it that allows nulls. I have added a field to the table so the geography field is now second to last in the table. I can initially sync the mobile device without issues. However if I add a address to the table and try to sync I receive the following error:

The Merge Agent failed because the schema of the article at the Publisher does not match the schema of the article at the Subscriber. This can occur when there are pending DDL changes waiting to be applied at the Subscriber. Restart the Merge Agent to apply the DDL changes and synchronize the subscription.
The Merge Agent failed because the schema of the article at the Publisher does not match the schema of the article at the Subscriber. This can occur when there are pending DDL changes waiting to be applied at the Subscriber. Restart the Merge Agent to apply the DDL changes and synchronize the subscription.
Error converting data type varchar to geometry.

Both the server and the mobile device have 2014 SQL Server and their compatibility level is set to the same, the mobile device is SQL 2014 Express.

How do I fix this issue? Where do I fix this issue, on the server where the publication is or on the mobile device where the subscription is?

Any help is appreciated.

Thanks.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,654 questions
{count} votes