Azure User Management Console - AUMC

AUMC.zip (866 kB)
AUMC is a User Graphic Interface (GUI) that manages the users and logins of an Azure SQL database. The tool is simply convertin

AutoProc - The Stored Procedure Generator

autoproc.zip (35 kB)
AutoProc (The Stored Procedure Generator) is a (simple to use and compatible across multiple editions) set of stored procedures which generates getter and setter procedures for complex Sql Server 2000/2005/2008 (Express/Workgroup/Standard/Enterprise/Developer) tables.

Chinook Database

Chinook is a sample database available for SQL Server, Oracle, MySQL, etc. It can be created by running a single SQL script.

Dafuscator

dafuscator.zip (6,7 MB)
Dafuscator is a database data obfuscation system that allows you to tactically obfuscate or delete data out of your production database while leaving most of the data intact.

Contextual Database Content Viewer

The Database Content Viewer will help any developer working on a database oriented application. No longer creating complex SQL statements to inspect the complete data hierarchy of an object in the database.

Data Dictionary Creator

Data Dictionary Creator (DDC) is a simple application which helps you document SQL Server databases. It stores all the information in Extended Properties, so it's easier to keep the documentation in sync with the database as it changes.

Data Exporter for DNN (former DotNetNuke)

dataexport.zip (200 kB)
Data Exporter for DNN allows to export Data from the database into Excel, XML or CSV format. Its simple and fast way to export data.

The Database Build Tool

dbbuild.zip (64 kB)
There are lots of great applications to script out and find differences in SQL Server schemas. What I think is missing is a flexible tool to reassemble your scripts and deploy them easily. This tool provides a means of combining the scripts into a single SQL file or have them run against a database in an order you specify. There is also an option for keeping track of which scripts have been applied to a database to help deploy schema changes in a much easier way.

SQL Server Database Copy Tool

dbcopytool.zip (731 kB)
Simple tool to copy databases from one SQL Server to another.

DatabaseLint - find bugs in databases

dblint.zip (45,6 MB)
DBLint is an automated tool for analyzing database designs. DBLints ensures a consistent and maintainable database design by identifying bad design patterns.

Database Profiler

The Database Profiler project addresses daily problems of business intelligence or database migration projects. Simply in all projects that use foreign databases with an unknown content. Usually there are inconsitencies in source databases, which lead to an unpredictable implementation effort. In such projects it is nearly impossible to do an exact effort estimation. So you need to know these problems before they occur. The Database Profiler enables you to analyze (profile) these unfamiliar databases, to get an overview about the data quality, and to highlight predictable problems before they appear. All this is done by checking consistency rules, that are defined by the system - as far as possible - and the user. Finally you get a profiling report, that you can use for your effort estimation.

DB Script Runner

Utility to run multiple scripts in a specified order against a database. It's developed in VB.net.

Database Searcher

dbsearcher.zip (428 kB)
This is a small tool for searching a typed value inside all type matching columns and rows of a database. For connecting the database a .NET data provider for the server is required. The code is written in C# 3.0

DEWD

dewd.zip (14,0 MB)
DEWD is an Umbraco 4.0 extension used to edit sequential data such as rows in a SQL server database table. It's meant to allow developers to quickly set up user friendly table editing in Umbraco (eg. for editors) without having to write custom code. Written in C#/ASP.NET 3.5.

Employee Info Starter Kit

eisk.zip (57,3 MB)
Employee Info Starter Kit is an open source project that is highly influenced by the concept ‘Pareto Principle’ or 80-20 rule, where it is targeted to enable a web developer to gain 80% productivity with 20% of effort with respect to learning curve and production.

Load Excel Files Into SQL Server. No schema changes requiered!

Excel2Sql.zip (5,0 MB)
Load Excel files into SQL Database for further processing, analysis and validation. Without schema changes!

ExpressMaint

eyeArchive - Database Archiving Tool for Microsoft SQL Server

eyeArchive.zip (1,7 MB)
eyeArchive is a tool that should help DBA's to archive their MS-SQL databases (2000+). Generated scripts create stored procedures (called by a single job) that will automatically move "old" records (based on custom conditions) to an archive database. It is written in C# 2.0

eyeLog - Database Audit Tool for Microsoft SQL Server

eyeLog.zip (2,9 MB)
Most of the time, you focus on the implementation of the business requirements. There are a lot of follow up tasks that are not directly asked by the business. Monitoring the activity of a system is one of the tasks that is implictly asked. The goal of eyeLog is to monitor the a

IQ.DbA

iqDbA.zip (2,3 MB)
IQ.DbA is a light weight database management tool. - Easily browse through your table's data, run queries. - Compare schema / meta data. - Compare & synchronize table data (schema must be the same). - Create, Backup & Restore Db. - View & kill connections. - Added, sync indexes