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) 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 is a sample database available for SQL Server, Oracle, MySQL, etc. It can be created by running a single SQL script.
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.
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 (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 allows to export Data from the database into Excel, XML or CSV format. Its simple and fast way to export data.
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.
Simple tool to copy databases from one SQL Server to another.
DBLint is an automated tool for analyzing database designs. DBLints ensures a consistent and maintainable database design by identifying bad design patterns.
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.
Utility to run multiple scripts in a specified order against a database. It's developed in VB.net.
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 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 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 Database for further processing, analysis and validation. Without schema changes!
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
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 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