Icon of program: Assembly Manager

Assembly Manager for Windows

By TotallySQLTrial versionUser Rating

Key Details of Assembly Manager

  • Manage the installation and configuration of CLR assemblies in SQL Server.
  • Last updated on August 28, 2015
  • There have been 7 updates
  • Virus scan status:

    Clean (it's extremely likely that this software program is clean)


Developer's Description

Manage the installation and configuration of CLR assemblies in SQL Server.
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.

Explore More


Full Specifications

GENERAL
Release
May 25, 2011
Latest update
August 28, 2015
Version
1.0
OPERATING SYSTEMS
Platform
Windows
Operating System
Windows 10
Additional Requirements
Requires .NET Framework 4.0 on client, SQL Server 2005 or later on server
POPULARITY
Total Downloads
94
Downloads Last Week
0

Related Software