idxScout 2.0.2

Do relational databases have to be so complicated? idxScout may be the answer you're looking for. It investigates relationships within a relational database, revealing its logical structure. Whether you're a pro or a novice, you'll be writing database queries (SQL) with machine accuracy, giving your brain a break.

In no time you'll understand relationships contained within a database. A modern database may contain hundreds of tables, each with ten or more fields, resulting in a matrix of thousands of individual parts. Learning a database's structure is a very difficult task taking days for professionals and weeks for novices.

Automatically write SQL select statements. idxScout uses an explorer-like interface to easily choose the tables and fields you want to query. Gone are the days where it was easier to select all (*) from a table. Just select what you want, press preview, and check it off your to do list.

Quickly build machine accurate SQL joins. idxScout has the intelligence to predict joins for you. If the join is complex, just pick it from a list of relationships. Joins always straightforward, never nested, and easily understood. Eliminate some frustration and save your brain for better tasks. Time and money saved.

Using a patent pending approach to database management, idxScout makes the terribly difficult, easy. Just import your existing SQL, modify, and export back to your database management system. Microsoft's .NET technology ensures compatibility with SQL Server, MySQL, MS Access, DBF, and many other databases all in a single system. A configured sample database gets you started right away. There's a step-by-step tutorial on the web just in case.