SQL Compare 9

Help for older versions available.

SQL Compare may drop and create CLR assemblies

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

Didn't find what you were looking for?