Altering CLR assemblies
pil0t
Posts: 14
1. I comapared two databases with different sql assemblies, and SDK generated migration script like this:
<drop depended objects>
<drop clr assembly>
<create assmbly>
Is there any way to generate migration like this:
ALTER ASSEMBLY [myAssembly]
FROM 0x4d5a9000030000000......?
2. I created "by hand" script (alter assmly ...) and execute it in sql server managment studio without any errors.
When i try to pack it in sql packager i got error
"SQL Error: ALTER ASSEMBLY for assembly 'myAssembly' failed because assembly 'myAssembly' is malformed or not a pure .NET assembly. "
3. in SQL compate 8 there is a checkbox "Do not use ALTER ASSEMBLY to change CLR objects" but when it is checked or not, i always got DROP ASSEBLY, CREATE ASSEMBLE statements.
<drop depended objects>
<drop clr assembly>
<create assmbly>
Is there any way to generate migration like this:
ALTER ASSEMBLY [myAssembly]
FROM 0x4d5a9000030000000......?
2. I created "by hand" script (alter assmly ...) and execute it in sql server managment studio without any errors.
When i try to pack it in sql packager i got error
"SQL Error: ALTER ASSEMBLY for assembly 'myAssembly' failed because assembly 'myAssembly' is malformed or not a pure .NET assembly. "
3. in SQL compate 8 there is a checkbox "Do not use ALTER ASSEMBLY to change CLR objects" but when it is checked or not, i always got DROP ASSEBLY, CREATE ASSEMBLE statements.
Comments
I hope someone will point out any wrong assumptions I've made, but I have had a look at the source code for SQL Compare and it looks to me as if the assembly will be rebuilt instead of altered if: