Monday, October 31, 2011

DBScripter library on CodePlex

Today I have created project on CodePlex called DB Scripter.

This project is library that allows users to script SQL Server database objects. Library uses dynamic management views for extracting data about databases objects.

This library could be used in various situations. The most interesting areas are comparing database objects and generation database documentation. For both cases examples have been prepared.
This library can be used only for databases with compatibility levels 90 (MS SQL Server 2005) and 100 (MS SQL Server 2008). Here is a list of supported objects:
  • Tables
  • Indexes
  • Ddl triggers
  • Dml triggers
  • Clr triggers
  • Stored procedures
  • Views
  • Application roles
  • Database roles
  • Users
  • Assemblies
  • Aggregates
  • Defaults
  • Synonyms
  • Xml schema collections
  • Message types
  • Contracts
  • Partition functions
  • Service queues
  • Full text catalogs
  • Full text stop lists
  • Full text indexes
  • Services
  • Broker priorities
  • Partition schemes
  • Remote service bindings
  • Rules
  • Routes
  • Schemas
  • Sql user defined functions
  • Clr user defined functions
  • User defined data types
  • User defined types
  • User defined table types
More about library you can find here.