SqlDbAid

SqlDbAid is a simple-to-use software application that gives you the possibility to compare databases and find out whether or not they have identical content. It features several handy tools and doesn't need installation, apart from SQL Server and .NET Framework.

You can drop the program files in any part of the disk and just click the executable to launch SqlDbAid. Another option is to keep it stored on a USB flash drive to be able to directly run it on any PC with SQL Server and .NET Framework installed. It doesn't add new entries to the Windows registry, though.

It's packed in a classical interface, made from a normal window with a neatly organized structure that houses just a few options. You can begin by connecting to the SQL server with an address, user name and password.

Once connected, you can select a database to view its contents in the main window, as well as check out the name, type, schema, date of modification and description for each table.

It's possible to use a basic search function, refresh information and export it to file, script the database, or perform a data search query. As far as app tools are concerned, SqlDbAid is capable of tracking down primary and foreign key indexes which are missing, examine the limited and sampled limited indexes status, as well as reveal existing indexes.

Databases can be compared by exporting selected objects. You can also investigate server activity regarding the processes, locks, top queries and plan caches, add the DROP query, exclude indexes from scripting, show system databases, or modify the default connection and execution timeout.

The software utility worked smoothly in our tests, without causing the OS to hang, crash or prompt error messages. It had minimal impact on computer performance, consuming low CPU and RAM. SqlDbAid offers a simple and effective solution to scripting and comparing databases.