DB SynchroComp
By e-dule Software
DB SynchroComp compares two SQL Server (7 - 2005) databases, determines differences between them, and generates the script that will change the target database structure to match the source database structure. After you execute the synchronization script, two databases will have the same structure, and existing data in the target database will remain intact. Database differences will be shown graphically and textually. It is possible to select the objects that are to be synchronized or to synchronize all the objects (this is the default option). You can change some of the comparison options before the comparison of databases. After creating the synchronization script, it will be possible to change it. But usually, there will be no need to change this script. DB SynchroComp changes the database structure only but not the data. After the synchronization of database schemas, the target tables will be populated with the data that existed on the target database before the synchronization, except for newly created fields that can be either null, or populated with some default data that are generated by the program or by the user.
SQL Batch Executor
By JohnMacIntyre.ca
SQL Batch Executor will run SQL scripts for any database with an ODBC compliant driver.
SQLExecMS
By Laplas Soft
SQLExecMS is a lightweight but powerful tool for Microsoft® SQL Server DBAs and database developers.It supports MS SQL Server 7, 2000, 2005 and MSDE. Unique all-in-one interface for management, tuning up, development, deployment and data manipulation. Ultimate tool for MSDE developers and administrators. SQLExecMS doesn''t require any additional installation, just ''drop and run'', that is why it is almost perfect to be built in to your DB product. SQLExecMS doesn''t use DMO or any other ActiveX components, this is one of the reasons why it works much faster than other similar tools. Finally, this application has been created based on long experience of development and of support DB systems. Llist of features divided by categories: -for DBA - Monitor active connections, oldest transactions and vital SQL server performance counters;Check utilization of proc cache;Watch locks; Review space used by DB files, tables and indexes; Manage DB file and filegroups;Turn on and off trace flags;Manage scheduled jobs; Change SQL server and database options;Backup and restore databases; Analyze fragmentation of tables; Analyze wait statistics; Manage indexes and analyze the selectivity of an index; Attach/Detach databases; Review error logs of SQL server; Manage extended stored procedures; Manage logins and users;Use bulk insert. -for Developers-Execute any T-SQL statements;Review estimated execution plan;Find substring in objects DDL; Use SQL history of your sql statements; Use quick reference and assistant; Easily view the table and view data;Manage triggers;Manage indexes;Compare scripts of two databases; Review objects dependencies in tree-like view; Review object properties; Find an object by its ID;Generate SQL script for your DB. And many other handy features....
SQL Password
By LastBit Software
SQL Password is a password recovery tool for Microsoft SQL Server that can recover password for registered user accounts. The following versions of MS SQL Server are supported: 2000, 2005, 2005 Express as well as Microsoft SQL Server Desktop Engine (MSDE) 2000. Because of the nature of the security system used in MS SQL Server, you have two options when recovering lost or forgotten passwords: 1) you can try to recover the original password. MS SQL Server encrypts passwords and they cannot be easily decrypted, so SQL Password uses the following recovery methods to crack them: Brute Force Attack, Dictionary Attack and Smart Force Attack. Although there is a guarantee that the password will be recovered, it may take a long time. So, in most cases (i.e. an administrator who has forgotten his or her password) the best option is the second one: 2) you can reset the password to a known one. SQL Password performs this operation instantly by modifying the master.mdf file where SQL Server stores passwords. If you use this feature, you do not have to wait until the password is cracked, though the original password remains unknown. This change is transparent and you may continue to work with the database as usual, using the new password to log on. You can use SQL Password to recover or reset any password found in the user accounts file of MS SQL Server, including the password for the system administrator (whose username is "sa"). Like every other our password recovery tool, SQL Password is efficient, reliable and easy-to-use. We constantly update it to support the latest versions of MS SQL Server. The latest version supported at the moment is 2005. Please check our website for updates and more information. Note: if SQL Server is configured to use the standard Windows security accounts ("Windows authentication mode"), SQL Password will not be able to recover passwords.
myLittleAdmin for SQL Server 2005
By myLittleTools.net
myLittleAdmin for SQL Server 2005 is the first web-based management tool specially designed for MS SQL Server 2005. It allows to manage almost all objects of your databases and servers, including the new objects like snapshots, schemas, synonyms, credentials, etc. through a web browser. Faster than SQL Server Management Studio, its intuitive interface will seduce all users, from the DBAs to the webmasters, including the web-hosts. This new version of myLittleAdmin has been developed in .NET technology (C#). As always, installation is pretty easy and can be done even if you do not have any administration rights on the server. myLittleAdmin for SQL Server 2005 offers a skinnable interface and multi-language support. With myLittleAdmin for SQL Server 2005, enter a new generation of web-based applications.
Quest Central for SQL Server
By Quest Software
Quest Central® for SQL Server is an integrated database management solution designed to enable administrators to manage complex database environments and simplify everyday tasks. Quest Central for SQL Server provides DBAs with a set of tools to achieve higher levels of availability and reliability, leverage and extend native SQL Server administration capabilities, and adds multi-server and change management capabilities to make database management easier.