Merge Replication issue with the data type geography

Question

Merge Replication issue with the data type geography

Alfie B. Larioza 6

looking for help about our problem in merge replication in sql 2019.

CathyJi-MSFT 22,426 Reputation points Microsoft External Staff

2022-04-04T09:43:33.663+00:00

Hi @Alfie B. Larioza ,

Any update for this thread? Did the reply could help you? If the response helped, do "Accept Answer". If it is not work, please let us know the progress.
CAPPELLI Fabio 0 Reputation points

2026-03-27T15:04:10.14+00:00

The replies are not helpful, they only suggest to check for the schema, but schema is identical and the error message is misleading.
As soon as there is a geometry object in a table the replication does not work

2 answers

Your answer

CathyJi-MSFT 22,426 Reputation points Microsoft External Staff

2022-04-04T09:43:33.663+00:00

Hi @Alfie B. Larioza ,

Any update for this thread? Did the reply could help you? If the response helped, do "Accept Answer". If it is not work, please let us know the progress.
CAPPELLI Fabio 0 Reputation points

2026-03-27T15:04:10.14+00:00

The replies are not helpful, they only suggest to check for the schema, but schema is identical and the error message is misleading.
As soon as there is a geometry object in a table the replication does not work

Answer 1

Hi @Alfie B. Larioza ,

> 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.

Please restart the sync process. From the client in a pull situation, or restart from the publisher in a push situation.

In short the application of DDL changes ran into a conflict but restarting the sync will usually resolve the issue. And no, it doesn't start from the beginning, it should just pick up from the point of failure.

Refer to this similar thread.

> Error converting data type varchar to geography

Please check data type of values that changed in articles. Did you enter the wrong data type?

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Answer 2

Olaf Helper 47,616

Read the error message: Schema definition Publisher/Subscriber mismatch. The tables on both side must have the same definition.

Alfie B. Larioza 6 Reputation points

2022-03-30T09:39:12.457+00:00

Hi OlafHelper-2800, thank you for your response, what should i check about the same definition?

Share via

Merge Replication issue with the data type geography

2 answers

Your answer