These pages cover SQL Compare 9, which is not the latest version. Help for other versions is also available.
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