Assembly Manager logo

Assembly Manager

By TotallySQL Free to try

Developer's Description

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.

Full Specifications

What's new in version 1.0

General

Date Added May 25, 2011
Version 1.0

Operating Systems

Additional Requirements Requires .NET Framework 4.0 on client, SQL Server 2005 or later on server

Popularity

Total Downloads 94
Downloads Last Week 0
Report Software

Related Software

Windows Installer (Windows XP/2003) logo

Windows Installer (Windows XP/2003)

Free
Windows Installer (Windows XP/2003)
Windows Installer (Windows 95/98/Me) logo

Windows Installer (Windows 95/98/Me)

Free
Windows Installer (Windows 95/98/Me)
Serial Key Generator logo

Serial Key Generator

Free to try
Serial Key Generator
CD Key Generator logo

CD Key Generator

Free to try
CD Key Generator
Promo image for CNET Shopping

Get the best price on everything

Shop your favorite products and we’ll find the best deal with a single click. Designed to make shopping easier.