Search code examples
sql-servertype-conversiontransactional-replication

SQL server 2014 Transaction Replication

I am trying to replicate a column with data type char(10) to another column with datatype char(30)

While applying snapshot I get an error saying 

"Field Size too large"

As per my understanding Publisher has size smaller than the Subscriber so why would this error come up?

I tried looking over the internet but could not find much help either.

Solution

  • The MSDN forum has pointed a similar issue with a resolution:

    I had this same problem. In comparing the schema of the table in both the publisher and subscriber, they appeared to be identical. However, I had to drop the table on the subscriber and recreate it using a create table script generated on the publisher. Once I did that, the snapshot proceeded without any more errors. HTH.