Category: Troubleshooting & error messages
Date: 05 Jun 2009
Product: SQL Compare
Whenever SQL Compare must modify a CLR assembly in a database as part of a synchronization, it will run an ALTER ASSEMBLY query whenever possible. However, there are some circumstances where an assembly must be dropped and re-created.

SQL Compare will drop an assembly and create a new one in the following circumstances:

• The assembly depends on another assembly that needs to be re-created
• The assembly metadata is different between the assembly in either database
• The assembly metadata is invalid or otherwise could not be compared
• Either assembly contains no files
• Either assembly is less than 96 bytes in size