Synchronization failure!

Dbguru

I have been using SQL Compare for Database Schema comparison and synchronization.
when i try to sync two databases i get the following error upon sync failure!

"Data exceeds the maximum allowable table row size of 8060 bytes.Synchronization failed"

Please assist

Thanks

Brian Donahue

Hello,

The problem sounds like it's caused by a table rebuild required to synchronize the schema is inserting rows of data that are larger than the page size of SQL Server. This can happen, for instance, if the table has many columns of considerable length and the amount of data from one row would be more than 8060 bytes. This amount of data would be larger than one SQL Server page and the insert would fail.

I don't know of any workaround for this, except possibly preventing the table from being rebuilt (for instance, changing the 'force column order to be identical' option to OFF).