When SQL Compare modifies a CLR assembly in a database as part of deployment, 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 recreated
• 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