FantasticFreeware.com

Open DBDiff -MS-SQL schema compare and upgrade generator

http://www.codeplex.com/OpenDBiff

Open DBDiff is an open source database schema comparison tool for SQL Server 2005/2008.
It reports differences between two database schemas and provides a synchronization script to upgrade a database from one to the other.

Open DBDiff can synchronize

    * Tables (including Table Options like vardecimal, text in row, etc.)
    * Columns (including Computed Columns, XML options, Identities, etc.)
    * Constraints
    * Indexes (and XML Indexes)
    * XML Schemas
    * Table Types
    * User Data Types (UDT)
    * CLR Objects (Assemblies, CLR-UDT, CLR-Store Procedure, CLR-Triggers)
    * Triggers (including DDL Triggers)
    * Synonyms
    * Schemas
    * File groups
    * Views
    * Functions
    * Store Procedures
    * Partition Functions/Schemes
    * Users
    * Roles

I didn't found any tool like this 100% open source for SQL Server. It does not depend on any privative tool or component. I do its work without resorting to SMO.
We tested this tool with more than 100 distinct testing use cases

DbDiff – DbScripting (without dmo,smo) 

http://www.codeplex.com/DbDiff

Compare MSSql database structures. (Sql 7,Sql 2000,Sql 2005)
Features:

– compare database structure (sql2000 <-> sql2000 or sql2000 <-> sql2005 or sql2005 <-> sql2005)
– scripting without dmo or smo
– commandline scripting, commandline compare
– standalone dll-s for referencing from another .net project
– many compare options (and we can easily extend for new properties with option designer)
– easily extend for other sql databases
– and many more

next release will include a new project: scripting with sql for example: sql scripting inside sql server without smo (only in sql2005)

SSMS Tools Pack is an Add-In for Microsoft SQL Server Management Studio (Express)

http://www.ssmstoolspack.com/

It contains a few upgrades to the IDE that I thought were missing from it.

The current feature list is:
    * SQL Snippets
    * Window Connection Coloring
    * Query Execution History and Current Window History
    * Format SQL
    * Search Table, View or Database Data
    * Run one script on multiple databases
    * Copy execution plan bitmaps to clipboard or file
    * Search Results in Grid Mode or Execution Plans
    * Generate Insert statements from resultsets, tables or database
    * Regions and Debug sections
    * Running custom scripts from Object Explorer
    * CRUD stored procedure generation
    * New query template
    * General options

It is simply the best free SQL Server Management Studio Add-In on the web today!
And it's better than some non-free ones too. :)

Microsoft SQL Server Migration Assistant 2005 for MySQL

http://mcpmag.com/articles/2010/01/12/ms-woos-mysql-users-with-migration-tool.aspx

Microsoft SQL Server Migration Assistant (SSMA) 2005 is a toolkit that dramatically cuts the effort, cost, and risk of migrating from MySQL to SQL Server. SSMA 2005 for MySQL v1.0 CTP1 provides an assessment of migration efforts as well as automates schema and data migration.
 Top of page

System Requirements
Supported Operating Systems: Windows 7; Windows Server 2003; Windows Server 2008; Windows Server 2008 R2; Windows Vista; Windows XP
SSMA 2005 for MySQL v1.0 CTP1 is designed to work with MySQL 4.1, 5.0 and 5.1 and all editions of SQL Server 2005.

Requirements for the SSMA for MySQL client:
• Microsoft Windows Installer 3.1 or a later version
• The Microsoft .NET Framework version 2.0 or a later version. You can obtain it from the .NET Framework Developer Center.
• MySQL Connector/ODBC v5.1.
• Access to and sufficient permissions on the computer that hosts the target instance of SQL Server 2005.
• 1 GB RAM. 

ADO.NET 2.0 Provider for SQLite

http://sourceforge.net/projects/sqlite-dotnet2/files/

ADO.NET 2.0/3.5 Provider for SQLite. Supports Full and Compact Framework, Entity Framework, complete with full Visual Studio 2005/2008 design-time support.

C#-SQLite-independent reimplementation of the SQLite 3.6.16

http://code.google.com/p/csharp-sqlite/

It has been ported into managed code, written in C#

See the Wiki VersionHistory for details
Please keep in mind the following:

    * This is not an official version of SQLite
    * There is completely NO affiliation with SQLite.org
    * Bugs should not be reported to their ticket tracking system

DTM ODBC Manager-transfer ODBC Data Sources between computers

http://www.sqledit.com/odbc/

DTM ODBC Manager is a free simple and easy-to-use ODBC Data Sources manager. The program allows you to export data source definitions into a file and then restore it on a local or remote system.

ODBC Manager is an indispensable tool for DBAs or developers who have to transfer data source definitions between computers and is a perfect addition to the system ODBC Administrator. The program allows you to audit local and remote data source definitions, remove DSNs and import definitions created on one of the computers on a remote system right from your workplace. To do it, "Remote Registry Service" must be running on the system you work with and it must have all necessary drivers installed. The program works both with system DSNs and with user DSNs. DTM ODBC Manager allows you to operate not only with a single DSN, but also to export or import all existing items or those selected in the list. Online help. 

SQL Server Reporting Services Scripter-enables scripting and transfer utility

http://www.sqldbatips.com/showarticle.asp?ID=62

Reporting Services Scripter is a .NET Windows Forms application that enables scripting and transfer of all Microsoft SQL Server Reporting Services catalog items to aid in transferring them from one server to another. It can also be used to easily move items on mass from one Reporting Services folder to another on the same server. Depending on the scripting options chosen, Reporting Services Scripter can also transfer all catalog item properties such as Descriptions, History options, Execution options (including report specific and shared schedules), Subscriptions (normal and data driven) and server side report parameters.

SQLDoc Sharp-generate the SQL Server 2005/2008 documentation 

http://www.codeproject.com/KB/cs/SQLDoc.aspx

SQLDoc Sharp, an interactive tool designed to generate the SQL Server 2005/2008 documentation.
It allows you to export documentation to CHM format (Microsoft Compiled HTML Help).
And also, easy and interactive, which allows multiple database documentation.
For more details, please refer to http://www.amitchaudhary.com/
Background

Finding the answer to, "Is there any free tool for generating documention from SQL 2005/2008

SQL Encryption Assistant Basic Edition

http://www.devenius.com/SEABasic.aspx

SQL Encryption Assistant Basic Edition simplifies the creation, modification, and deletion of encryption keys and certificates inside SQL Server. SQL Encryption Assistant is an add-in utility to either SQL Server Management Studio or Microsoft Visual Studio.
Free BASIC Edition Download Free BASIC Edition 2008 Download
Features
    Create (Limit 5), Alter, Delete         Backup         Restore
      – Asymmetric Keys           – Certificates           – Certificates
      – Symmetric Keys           – Database Master Keys           – Database Master Keys
      – Certificates           – Service Master Keys           – Service Master Keys
      – Database Master Keys
      – Service Master Keys
System Requirements
    Operating Systems
          – Windows XP SP2
          – Windows Vista SP1
          – Windows Server 2003 SP1
          – Windows Server 2008
         
    Microsoft SQL Server 2005/2008
          – Express
          – Workgroup
          – Standard
          – Enterprise
         
    Visual Studio
          – Visual Studio 2005 SP1
          – Visual Studio 2008

Database Editor-Oracle, DB2, MS SQL SERVER, MySQL, Access

http://acid.110mb.com/

The program allows you to work with several databases simultaneously. Easy way for exports and imports datas to popular formats. Convenient connection manager provide the rapid switching between databases.

Support databases: Any. Oracle, DB2, MS SQL SERVER, MY SQL, Access etc

Features:

    * Object Browser
    * Import from csv,excel
    * Export to text,csv,excel
    * Work with BLOB fields (export/import)
    * SQL Editor with syntax
    * SQL History browser
    * SQL Templates
    * Web update
    * Plugins
    * Free
 

SQLBackupAndFTP-runs scheduled backups

http://sqlbackupandftp.com/

SQLBackupAndFTP is a software program that runs scheduled backups  of SQL Server or SQL Server Express databases, zips the backups, stores them on a network or on a FTP server, removes old backups, and sends an e-mail confirmation on job's success or failure. It has to be installed on the server.

SQL Server 2005 Driver for PHP

http://www.microsoft.com/

Download the SQL Server 2005 Driver for PHP, a PHP 5 extension that allows for the reading and writing of SQL Server data from within PHP scripts.

Query Express-query tool for MSDE and SQL Express

http://www.albahari.com/queryexpress.html

Query Express is a simple Query Analyzer look-alike, but being small and free it can be run where the SQL Server client tools are not installed or licensed. This makes it especially useful as a query tool for MSDE and SQL Express. It also connects to Oracle and other OLE-DB compliant databases.Query Express requires no installation and is packaged as a single 100KB executable. This is more than 300 times smaller than SQL Server Management Studio!Query Express Screenshot. Query Express is ideal for those not yet ready for the LINQ Challenge.Query Express has a fully permissive free license with no conditions attached. Full source code is included, which you can use in commercial software. Compatible with the .NET Framework versions 1.1, 2.0 and above—no additional downloads are required if you have Windows XP SP2 or Windows Vista.

Microsoft Source Code Analyzer for SQL Injection

http://www.microsoft.com/

Community Technology Preview (July 2008)
Microsoft Source Code Analyzer for SQL Injection is a static code analysis tool for finding SQL Injection vulnerabilities in ASP code. Customers can run the tool on their ASP source code to help identify code paths that are vulnerable to SQL Injection attacks.

LINQPad is a fantastic freeware application that lets you interactively query SQL databases using LINQ (Language Integrated Query).

In this brave new world where LINQ will become more popular an will be broadly adopted by the .NET community it will become very important to become fluent with your use of LINQ. One way to accomplish this is by replacing your use of  SQL Management Studio for interactively querying SQL databases with LINQPad.

According the the LINQPad website you can "Kiss goodbye to SQL Management Studio !".  Does LINQPad replace SQL Management Studio for interactively querying SQL databases? 

Until I found Matt Perdeck's LINQ to CSV library an easy to use library to read and write CSV and tab delimited files with LINQ queries,  I would have said LINQPad is not ready.

In my opinion there are only two reasons not to use LINQPad and both problems are solved by LINQtoCSV.

1. LINQPad lacks the ability to export query results to a csv file.
2. LINQPad's output is limited to 1000 Records.\

Here's how to configure LINQPad to use LINQtoCSV.

Step 1: Download LINQtoCSV and copy to the folder of you choice.

Step 2: Add "LINQtoCSV.dll" Assembly Reference to Tab called "Additional References"  (Query >> Advanced Properties) or (F4)

Step 3: Add "LINQtoCSV" Namespace Reference to Tab called "Additional Namespace Imports"

Step 4: Press the Set as default for new queries button and close the window.

Step 5: Set Query Type to C# Statement(s)

Step 6: Add standard LINQtoCSV code to your Query.

About This Website

Welcome to FantasticFreeware.com's .NET Blog .  This Blog is dedicated to Fantastic .NET Framework Freeware Applications and Technology.  The .NET technologies that you will find here are C#, VB.NET, ASP.NET, .NET 2.0, 3.0, & 3.5 Frameworks, LINQ, WCF, WPF, Silverlight just to name a few.

Subscribe to the FantasticFreeware.com .Net Blog RSS feed here:

FantasticFreeware – is my personal Library of every freeware program that I have found useful.

I have cataloged over 2700+ of only the best hand picked freeware programs since 2003.  To make the list it must be a true freeware application. No demos, trial, shareware, and etc. I continually add to the collection and add about half dozen new freeware applications every week.  The current size of my personal catalog is 50GB and growing. The programs a categorized by major groupings. (Disk, Internet, Security, Development, and etc)

VistaDB 3.3 Express Edition-managed database you can XCopy deploy

http://www.vistadb.net/blog/vistadb-news/vistadb-express-release/

VistaDB is a 100% managed database you can XCopy deploy. In fact this site is powered by VistaDB (even this blog).

VistaDB Express is a free edition of VistaDB for non commercial use.  This includes hobbysts, mono developers, open source projects, personal websites, user groups, sample application, schools, and much much more.Why an Express Edition?We get asked quite a bit about distribution with free and open source projects (especially mono developers), we needed  a license to specifically help these developers use all the cool features of VistaDB in their community as well.Microsoft decided a long time ago that the Express Development tool (VB Express, C# Express, C++ Express) editions are not allowed to load third party plugins.  These editions were specifically aimed at the non professional developer community.  Since they can't load the GUI plugins for Visual Studio 2005 and 2008 anyway, we decided to simplify the offering for these users.Where do I get it? Get VistaDB Express here or the VistaDB 30 day trial.VistaDB Express HighlightsDesigned for use with Mono and Microsoft Express builds for personal projects, there are no Visual Studio plugins.    * No Server Explorer or Data Binding (Express Editions cannot load them anyway)    * May not be used for commercial purposes    * No in memory databases
    * No Isolated storage support
    * Database files may not be renamed (must be VDB3)
    * No Compact Framework support. No Sync Services. No LINQ. No Client / Server support.

Even with those restrictions it still has a lot of things you can't get from SQL CE:

    * Shared Hosting Support
    * ASP.Net websites with connection pooling support
    * CLR Procs
    * TSQL Procs
    * UDF Functions
    * Updatable Views
    * SQL Exception Handling
    * Data Builder GUI for managing your database
    * 64 Bit Windows Support

For a full review of VistaDB vs SQL CE see our comparison page on the VistaDB.net website.

For a full list of restrictions view the EULA for VistaDB.

Scrawlr-analyze website for sql injection bugs

https://download.spidynamics.com/Products/scrawlr/

Scrawlr, developed by the HP Web Security Research Group in coordination with the MSRC, is short for SQL Injector and Crawler. Scrawlr will crawl a website while simultaneously analyzing the parameters of each individual web page for SQL Injection vulnerabilities. Scrawlr is lightning fast and uses our intelligent engine technology to dynamically craft SQL Injection attacks on the fly. It can even provide proof positive results by displaying the type of backend database in use and a list of available table names. There is no denying you have SQL Injection when I can show you table names!

Technical details for Scrawlr

    * Identify Verbose SQL Injection vulnerabilities in URL parameters
    * Can be configured to use a Proxy to access the web site
    * Will identify the type of SQL server in use
    * Will extract table names (verbose only) to guarantee no false positives

Scrawlr does have some limitations versus our professional solutions and our fully functional SQL Injector tool

    * Will only crawls up to 1500 pages
    * Does not support sites requiring authentication
    * Does not perform Blind SQL injection
    * Cannot retrieve database contents
    * Does not support JavaScript or flash parsing
    * Will not test forms for SQL Injection (POST Parameters)

SQL Excel Add-in -SQL Excel adds easy database access

http://www.sqldrill.com/

Easy to import data to Excel from SQL Server, MYSQL, Oracle, Sybase, Microsoft Access, DB2 etc.     * Works with Excel XP, 2003 and 2007 Genuine Freeware! NO Ads, NO Spyware, NO Viruses  NO Time limits, NO "Phone Home"… Small Add-in Size – has small disk and memory footprint.  At the moment slightly less than 200k.  It wont bog down your Excel like add-ins can sometimes.. Fast Add-in user interface is implemented via  a small toolbar which will be added to your excel.  The toolbar wont take up too much space in Excel and you can move it to where you want it.

Vlinq-Visual Linq-query builder for Linq to Sql

http://code.msdn.microsoft.com/vlinq

Visual LINQ Query Builder is an add-in to Visual Studio 2008 Designer that helps you visually build LINQ to SQL queries. Functionally it provides the same experience as, for instance the Microsoft Access Query Builder, but in the LINQ domain. The entire UI of this add-in uses Windows Presentation Foundation. The goal of this tool is to help users become more familiar with the LINQ syntax. The tool may also demonstrate to users how to create their own Visual Studio 2008 add-in using Windows Presentation Foundation.

This academic project was developed by two students during an internship at Microsoft France, under the supervision of one of our Developer Evangelists. The project was in full collaboration with the STB International CPE team in Redmond.

GURA OLE DB Data Gate-simplfy ado.net db access

http://www.gura.com.au/TabloidSheet.aspx?p=P564221  

The GURA OLE DB Data Gate reduces the hassles associated with coding ADO.NET. It Provides the tools to retrieve and update data from OLE DB compatible databases. The Data Gate's role is to provide the common data access methods required for communicating with a data source. The Data Gate implements a standard interface that provides communication channels for an Object Director to perform data processes. As well as this, it implements standard CRUD functionality available for any calling application to access the raw data source data. 

BaseX is a native XML database

http://www.basex.org/  

BaseX is a native XML database. It features compact storage structures, a very efficient XPath and XQuery implementation and a visual frontend, facilitating visual access to the stored data. BaseX is written in Java and freely available for download. It is developed by the Database and Information Systems Group at the University of Konstanz.

Features:

    * Support of XQuery 1.0, reaching 99.3% of the W3C XQuery Test Suite
    * Partial support of XQuery Full-Text, based on the W3C Working Draft
    * Several Indexes, including a full-text index (currently only applied by the XPath 1.0 implementation)
    * GUI interactions for XML Updates
    * A Query Panel for entering XPath and XQuery
    * A Table View for a flat view of regular XML documents
    * A Help View for interactive feedback on the GUI features
    * A revised command syntax (try ´help´ in the console or the GUI command mode)

LINQPad lets you interactively query SQL databases in a modern query language

http://www.linqpad.net/  

LINQPad lets you interactively query SQL databases in a modern query language: LINQ.  Kiss goodbye to SQL Management Studio!

LINQPad supports everything in C# 3.0 and Framework 3.5:

    * LINQ to SQL
    * LINQ to Objects
    * LINQ to XML

LINQPad is also a terrific tool for learning LINQ: it comes preloaded with 200 examples from the recently released C# 3.0 in a Nutshell.  There's no better way to experience the coolness of LINQ and functional programming.

LINQPad is free and needs no installation: just download and run.  The executable is under 2MB and is self-updating. 

Database .NET – managing multi-databases

http://s630417.myweb.hinet.net/Database.htm

Database Reader is simple program for managing multi-databases. You can simply create / insert / select / update / delete table data and use SQL console.

Supports: MS Access / Access 2007 / Firebird / MySQL / SQL Server / SQL Server CE / SQLite/PostgreSQL.

Requires: Microsoft .NET Framework 2.0 or later.

DBSlayer – lightweight database abstraction layer suitable for high-load websites

http://code.nytimes.com/projects/dbslayer 

The DBacesslayer aka DBSlayer aka Släyer (as we like to call it when we're feeling ironically heavy metal) is a lightweight database abstraction layer suitable for high-load websites where you need the scalable advantages of connection pooling. Written in C for speed, DBSlayer talks to clients via JSON over HTTP, meaning it's simple to monitor and can swiftly interoperate with any web framework you choose.

The DBSlayer originated as an internal tool at the New York Times. The typical LAMP strategy for scaling up data-driven applications is to replicate slave databases to every web server, but this approach can hit scaling limitations for high-volume websites, where processes can overwhelm their given backend DB's connection limits. Quite frankly, we wanted to scale the front-end webservers and backend database servers separately without having to coordinate them. We also needed a way to flexibly reconfigure where our backend databases were located and which applications used them without resorting to tricks of DNS or other such "load-balancing" hacks. Plus, it just seemed really cool to have a JSON-speaking DB layer that all our scriptable content could talk to. Thus, the DBSlayer was born