|
|
CA Database Management for Distributed Databases
Price: Free.
|
Microsoft SQL Server Management Studio Express
Basically a stripped down version of SSMS,
Microsoft SQL Server Management Studio Express (SSMSE) is a free, easy-to-use graphical management tool for managing SQL Server 2005 Express Edition.
In 2005 this GUI was a separate download, but in 2008, just install SQL Server Express 2008 with Tools to get it.
|
Nautilus Web based SQL Server Admin/Navigator.
Nautilus is a tool for developers, advanced users and auditors. It allows users to navigate SQLServer 2000 & 2005 databases. With a browser you can locate records and follow foreign keys to related records. You can also generate many scripts.
|
CompareData
CompareData is a native Windows cross-dbms application that allows you to visually compare and synchronize data between two SQL databases using ODBC drivers. You can retrieve some/all data for a table/view from two databases and compare the data visually to see differences highlighted on the screen. You can also compare data of two sql queries and dbms metadata.
Price: $395
|
DataFrom
This software enables you to do data conversion across various database/file management systems.
Price: $259
|
DBTYP.NET
DBTYP.NET 2009 is tool for visual cross database comparison and synchronization that performs both, structure and data comparisons of SQL Server, MySQL and Oracle databases.
Price: $199
|
ScriptDB Console application.
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.
Price: $0.00
|
SQLDBDiff and other free tools
SQLDBDiff is a tool that compares the schema and the data of SQL Server databases.
Price: $30.00
|
SQLScripter
The data export and scripting utility for Microsoft SQL Server.
Cost: 79 Euros.
|
TableDiff
A utility that compares two tables for differences in data and schema.
Works with SQL Server 2000/2005/2008.
Price: $0.00
|
SQLSafe - Freeware edition
"Idera’s SQLsafe Freeware Edition is free SQL Server database backup and recovery tool based on our award-winning SQLsafe product. SQLsafe Freeware Edition gives you a really high-performance backup and recovery engine, a scriptable interface (command line and XSP) and the ability to backup and compress any size and any number of databases, all for free."
|
SQLSharp
CLR based extension methods for SQL Server.
|
SQLServer Examples
A portal containing nothing but TSQL examples.
"The examples on this portal will provide you with the building blocks necessary to quickly resolve different TSQL coding issues."
|
How do I work with Dates (@@LANGUAGE, @@DATEFORMAT, @@DATEFIRST, GETDATE(), GETUTCDATE(), CONVERT(), YEAR(),MONTH(),DAY(),DATEPART(), DATEADD(), DATEDIFF(), etc) ? 4
|
|
|
How do I use LEFT, RIGHT, SUBSTRING, LTRIM, RTRIM, LEN, DATALENGTH, UPPER,LOWER, REPLACE, etc on Strings? 3
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|