SQLCLRProject free download, SQLCLRProject download on software download

SQLCLRProject is a tool that allows you to deploy .NET assemblies to SQL Server (version 2005 and later). Under the covers it uses MSBUILD tasks. It deploys the assembly(ies) to the database as well as creating the T-SQL procedures/functions/triggers/etc. In addition, it also creates T-SQL scripts during the deployment process. The tool can be used both from command-line as well as by using a GUI and also as an add-in to Visual Studio 2005/2008 (with it’s own project type and item templates). Features Here follows some of the major features of the SQLCLRProject tool. * Automatically deploy an assembly to SQL Server and create the T-SQL methods from the .NET functions. This can be done from the command line, the DeployProperties GUI executable as well as from inside the Visual Studio IDE. * Automatic creation of T-SQL deployment scripts. * Automatic creation of T-SQL DML scripts to test the generated T-SQL methods. * Ability to alter an assembly and only deploy newly added methods from the assembly. * Ability to create objects in a non Default schema: “schemaname.objectname”. * Assigning of default values to parameters in the T-SQL generated objects. * When re-deploying a UDT, instead of dropping the whole table - the deploy task can create a new column in the table in question and transfer all the data from the original column over to the new column, and then drop the original column. * Debug facilities from inside the VS IDE. New features / fixes: * The VS project has Now support for the new spatial data types in SQL Server 2008 as well as HierarchyId. * SQL Serer 2008 supports CLR methods with nullabale value types as parameters and /or return types. The deployment tool can now deploy these methods.

SQLCLRProject Related Software