SQL Compare may drop and create CLR assemblies
Published 19 June 2013
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