I am attempting to get merge replication going between two SQL 2008 servers. So far, everything has gone off without a hitch with one exception. We use spatial data on a daily basis in my organization, so we implemented the geography data type.
This data type seems to be causing all of our replication issues. I can easily create publications and subscriptions for each article in the entire database except the geography field.
The error is as follows:
"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 real kicker is that the schemas are exactly the same. If I set the publication to drop and recreate the subscription article, then to convert the geography data type, it works without issue, but then we run into issues with our publication database
not matching exactly with our subscription database, which could cause many potential problems with our web front end.
Is there a known issue with replicating the geography data type? Any help is very much appreciated!
View Complete Post