These pages cover SQL Compare 13, which is not the latest version. Help for other versions is also available.
SQL Compare may drop and create CLR assemblies
Published 04 June 2013
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
