idxScout 2.1.2

idxScout - Database Discovery. Find Foreign Keys

Database Discovery. Find Foreign Keys. Model it. Accurate SQL Joins

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 features an explorer-like interface to easily choose the tables and fields you wish 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.

idxScout features :

- Instantly understand relational databases. Save yourself hours.
- Comes with a pre-configured sample database to play with.
- Model your database in minutes.
- See foreign keys in a list or export them to Excel.
- Find missing or unnecessary indexes; fix problems.
- Unique, easy interface. Press Ctl-S anywhere and see the data..
- Write SQL selects and joins with machine accuracy. It's simple.
- Variety. Works with SQL Server, Oracle, MySql, MS Access, and DBF databases.
- Store all hunts and SQL in one place; any and every db format.
- It's fast & so easy to use! (Patent Pending).

Requirements:

- 3 Mb HD Space
- 1 Gb + memory

Limitations:

- 30-day trial

idxScout 2.1.2 is licensed as Shareware for the Windows operating system / platform. idxScout is provided as a free to try download for all software users (Shareware).