by dotnetpete
27. March 2009 16:35
Seems that XML data type columns are not replicated (via merge replication anyway) between sites. Bummer!
My table with the XML data type column had data at one site, not at the other and vice versa.
Luckily I'm not doing anything XMLy on the data (I didn't create the column but I wouldn't have forseen any concequences like this either), so I was able to create a new varchar(max) column and populate at each site. The data is the replicated to each site ok.
Would nice to have a pre-replication utility to rip through a database and warn for these types of situtations. In a previous post I ran into a similar issue with transactional replication and update of text columns at a subscriber.
Subscribe