Assembly Manager is a windows application aimed at both SQL CLR developers and SQL DBAs that solves the problems of trying to manage CLR assemblies using just Visual Studio or SSMS.
It allows you to see in a tree-structured view all installed CLR assemblies and the objects that they define (functions, stored procedures, aggregates, triggers, types) across multiple servers and databases. Within assemblies you can see all the defined objects whether they are installed in the database or not.
You can easily install, remove and configure these objects using drag/drop, cut/copy/paste and menu-based operations. You can copy assemblies between databases and servers, and store collections of assemblies in saved libraries. You can choose which functions to install, change the names and schemas they are installed with, and set parameter defaults. You can easily set the target objects and triggering events for both DDL and DML triggers.
You can set permission sets for assemblies, and it will automatically set up the required logins to allow EXTERNAL or UNSAFE assemblies on databases without having to set the TRUSTED flag (but you can also toggle this).
All changes are queued up into a set of change actions that can be executed straight away or saved for later use (you can see what the effect will be when run before actually committing the changes). All changes, once committed, can be rolled back using sets of rollback actions that can also be saved to files.
Alternatively both change actions and rollback actions can be generated as T-SQL scripts which can be run from within Assembly Manager, launched within SSMS or saved to file or clipboard.
||Free to try
||Requires .NET Framework 4.0 on client, SQL Server 2005 or later on server