DBScripter - Library for scripting SQL Server database objects

DBScripter.zip (29,0 MB)
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.

Microsoft SQL Server Product Samples: Engine

This project contains Engine samples released with Microsoft SQL Server product.

Open DBDiff

OpenDBDiff.zip (54,2 MB)
A GPL2 database comparison tool for Microsoft SQL Server 2005+ that reports schema differences and creates a synchronization script.

ScriptDB

ScriptDB.zip (114 kB)
ScriptDb is a simple console app written in C# that uses SQL Management Objects (SMO) to script all the objects in a database. It will work against any SQL Server 2000 or 2005 database. It creates a directory tree structure with a similar hierarchy to that in Object Explorer in SSMS, with a separate file for each object. It will also (optionally) script the data using bcp.exe. You can also (optionally) specify to script the extended properties for each object along with the DDL.

Scriptio - A SQL Server Object Scripting Utility

scriptio.zip (207 kB)
A utility for generating object scripts for Microsoft SQL Server. It is specifically designed to script DROPs and CREATEs in the same script.

Script SQL Server Configuration

Script SQL Server configuration information in a format suitable for DR purposes or checking into a source control system.

SQL Scriptz Runner

Features are : Drag And Drop script files Run a directory of script files Sql Script out put messages during execution Script passed or failed that are colored green and red (yellow for running) Stop on error option Open script on error option Run report with time taken for each

Using SMO in SQL Server with Service Broker

How to use SMO from TSQL using Service Broker.

SQL Data Capture - Black Box Application Testing

A tool for capturing and analyzing data modifications; an audit trail generator with a data modifications viewer. Helps with testing, troubleshooting and exploring application functionality. ASP.NET 3.5 C#, SMO application. Audit and CRUD generators are included.

SQL Deploy Tool

SQL Deploy tool is a command-line utility that executes all sql scripts in the current directory. All actions are logged.

SQL Server PowerShell Extensions

SQLPSX.zip (102,3 MB)
The primary goal of SQL Server PowerShell Extensions (SQLPSX) is to provide intuitive functions around the SMO objects which are backward compatible with SQL 2000. A secondary goal is to provide an application which reports flatten/effective security settings.

SQL Server Runner

sqlrunner.zip (12,6 MB)
A GUI and command line application that helps executing scripts against SQL Server databases. Scripts can be executed within a transaction and automatically rollback if exceptions are found. Written in C# using the SMO and Log4net libraries.

Support Vector Machines Data Mining Plug-in in Analysis Services

svmplugin.zip (8,5 MB)
The datamining Support Vector Machine (SVM) plug-in in MS SQL Server Analysis Services 2008. This plug-in is the SVM classification algorithm in addition to the shipped data mining algorithms with SQL Server.

SQL Management Objects Versioning Control (xSMO)

xsmo.zip (1,2 MB)
script TO and FROM a SQL server database with a command line tool