Total transparency and control over assemblies in SQL Server.
Assembly Manager is a Windows application for Microsoft SQL database administrators and developers that greatly simplifies the task of managing CLR (Common Language Runtime) assemblies in a live database environment. CLR integration - first released with SQL 2005 - offers a rich, powerful and safe way to extend native SQL functionality that delivers high performance and flexibility compared with conventional scripted T-SQL functions and other objects. However, the native administration capabilities provided within SQL Server Management Studio make it difficult to manage and control significant numbers of CLR-defined objects across multiple databases and servers. Assembly Manager provides a much higher degree of visibility and control - making it very easy to add and remove CLR-defined objects, perform upgrades, maintain consistency between databases, enforce policy, implement and manage security schema, generate change and rollback scripts and so on.
Assembly Manager is ideal for database administrators, it gives immediate visibility and control over which assemblies and assembly-defined-objects are installed on which databases, whether any of the assemblies are marked with EXTERNAL or UNSAFE permission sets, and which security schema are in use. It substantially reduces the effort required to carry out changes, allows changes to be scripted out and inspected before execution, and provides a roll-back mechanism for changes so that they can be backed out. It also provides non-administrators with the ability to safely define the changes required in the form of a series of change actions, and pass them over to you in an actions file that can be loaded up to allow you to see the effect the changes will have before they are applied.
For database developers and solutions architects TotallySQL Assembly Manager makes the use of MS SQL's powerful CLR integration features a viable and worthwhile option for your organization, by taking away the headache associated with CLR assembly administration. It provides total visibility and control over the CLR assemblies and the functions, aggregates, stored procedures, types and triggers that are defined in them. By just pointing and clicking you can easily choose which features to install in which databases, and you can copy assemblies and programming objects between databases by simply dragging and dropping or cutting and pasting. You can define change scripts and hand them over to your DBA for review and implementation - or if you have the appropriate permissions you can apply the changes yourself.
Assembly Manager benefits
TotallySQL are specialists in application development centered around Microsoft SQL Server, and in particular in creating CLR-based function libraries that enable advanced processing to be carried out within the database itself. They provide a range of off-the-shelf function libraries and can also build bespoke libraries to your specification. They also provide a range of database and data management services - including database design, ETL services, data cleansing and data migration.
Published in Development Tool News & Software Component News, July 26, 2011