Assembly Manager Manage the installation and configuration of CLR assemblies in SQL Server
Download

Assembly Manager Ranking & Summary

Assembly Manager Tags

server connection Database Connection assembly Compare Server Configuration Server Configuration Comparer Server Configuration Manage Server Configuration SQL Configuration File Manage Configuration Server Installation manage multiple installation manage installation CLR Type Component CLR Type manage configuration file NET CLR CLR manage ST installation manage software installation CLR Object CLR Generic SQL Server Configuration manage IP configuration Manage PHP Configuration

Assembly Manager Description

Assembly Manager is an 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 will be able to install, remove or configure these objects via drag and drop, as well as cut, copy, paste and menu-located 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. Main features: 100% GUI-based management interface - all tasks can be accomplished with simple point & click operations Fully client-based - there is nothing to install on the servers that are being managed Full support for all CLR object types: scalar & table-valued functions, procedures, aggregates, types and triggers Import & export assembly files between SQL servers and disk-based storage Directly copy or move assemblies between databases on the same or different servers Drag & drop or cut, copy & paste assemblies and their child objects between databases and to/from disk Drop an assembly and all its child objects with one click - no need to remove them one by one Choose which objects from an assembly are to be installed within SQL by clicking checkboxes Give objects any name and any schema within SQL - they do not have to match the names in the assembly Parameter defaults can be set for functions and stored procedures Perform bulk schema changes over multiple assemblies and objects in one go View all objects inside an assembly that can be used by SQL and their internal class and method names Upgrade assemblies without having to drop them (so no need to drop dependent objects first) Full support for CLR triggers: clone them for multiple targets and select multiple trigger events Manage server & database settings needed for CLR operation (e.g. CLR ENABLED, TRUSTWORTHY etc.) Auto-create asymmetric keys and logins for code authentication with EXTERNAL or UNSAFE assemblies Full inter-assembly dependency checking - e.g. auto-add referenced assemblies; auto-drop dependent assemblies Maintain & share libraries of assemblies that can be used to enable a cookie-cutter installation approach Deferred execution: make multiple pending changes and see their effect before applying them live Smart execution ordering for actions - avoids clashes e.g. by installing types before functions that use them Save and load change actions as predefined change sequences for later execution (e.g. by DBA). For every action a rollback is automatically created: any sequence of changes can be rolled back in one go Roll back action sequences can be saved to disk for later use if needed

Assembly Manager Related Software