Business & Finance >
Software Developers, Crystal Report Professionals and Data Analysts - Find Foreign Keys, Model Your Database Automatically.
Write SQL with machine accuracy and human readability. Use for SQL Server, Access, MySQL, Oracle or DBF databases.
idxScout - Find Foreign Keys. Effortless Data Models. SQL Made Simple.
Attention Developers, Crystal Report Professionals and Data Analysts: The mystery hiding inside your database has just been
solved. idxScout investigates keys, indexes and design problems with automatic data modeling. Download it at www.idxSoft.com.
Point it to your SQL Server, Access, MySQL, Oracle or DBF database. Run Key Hunter and see the structure. Use the results as
a model. Press a key or scroll to see data instantly. Find design problems. Check a box and build an SQL Select. Write SQL
Modern databases may contain hundreds of tables each with ten or more fields, meaning you are expected to know thousands of
little pieces. Remembering everything is quite a difficult task. Without design specs you may never fully grasp its complexity.
idxScout features a Key Hunter. It probes the database and finds foreign keys. These keys are presented in an
easy to understand list; not a confusing bunch of boxes and lines. Primary keys and indexes are color coded. You'll see flaws,
missing indexes, duplicated data and structural defects immediately. Tweak the results and you'll have a data model in hours;
not days. No large budget needed. Do a hunt on all fields; you'll be surprised what idxScout finds.
Use SQL Workshop and write select statements fast. Just check and choose the tables and fields you want to query. It's so easy
it will amaze you. You'll never use Select * again. Press CTL-S to view the data, select it if you want it, press preview and
check it off your to-do list.
Let your machine help you build SQL joins. No need to guess anymore. idxScout has the intelligence to predict query joins
for you; it's based on the model. If the join is complex, pick it from the list of relationships. Move the order around with
a click. You'll get joins that are never nested, never confusing, and easily understood.
Use SQL Server, Access, MySQL, Oracle and DBF & more.
idxScout Key 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).
|idxScout Related Software:
- MSSQL-to-MySQL is a program to migrate Microsoft SQL databases to MySQL server.
- DBF Viewer
- A powerful, compact and easy-to-use viewer and editor for DBF files
- Data Quik
- Data Quik is a multipurpose Database Copy Utility.
- DBF Recovery
- A powerful tool for recovery corrupted DBF files. Fix DBF files. Repair dBASE files. Repair FoxPro files.
- Cornolius Database Application
- Cornolius Database Application is a secure multi-user desktop database management utility.
Data Manager - a versatile and user-friendly multi-lingual accounting and finance planning program...
- CD Bank Cataloguer Network license
- is a powerful multi-user software intended for building a database of CD/DVD and other media, accessible via the local network.
- Advanced CSV Converter
- Support all the modern data interchange formats, such as XLS, XML, CSV, TXT, HTML, RTF, PRG and others. The program builds
a sample data record allowing you to build filtering rules.
- Active Document Keeper
- A document storage and management system for home or office use. The Internal storage system allows you to place multiple
documents in one or several document databases...
- SuperPro Software
- Has been designed as a total solution for customer relationship management and service software for business to business sales...
|idxScoutcker Professional Edition
Free to try
Windows 7, 2000, XP, Vista
256 MB RAM;
3 Mb HD Space
1 Gb + memory