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 joins mistake-proof.

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.

• SQL Console 2.00.
  SQLC is an application for console level interaction with an ODBC compliant data source such as a relational or object relational database. ? SQLC provides the end...

• DataHarry 2.5.0
  DB-Tool to compare or replicate data between SQL-database of different vendors

• Entity Developer Express 2.50
  Entity Developer is a free of charge powerful modeling and code generation tool for ADO.NET Entity Framework and LINQ to SQL. You can design an entity model from scratch or reverse-engineer an existing database, in which case you will have the...

• Aglowsoft SQL Query Tools 8.2
  Aglowsoft SQL Query Tools includes three database tools

• SQL Edge 3.3
  SQL Edge not only allows users to execute SQL scripts, but also provides a powerful way to visualize data relationships. With SQL Edge, users can use only one query to retrieve data in a master table, and then browse data in all related detail tables. Users can also insert, edit, and delete table records in the data grids. The SQL editor...

• VBMyAdmin 1.2.1
  VBMyAdmin is a Windows-Application for MySQL database administration / Access to MySQL for Windows (ODBC) and Linux (PHP gateway) / SQL Query Builder for joined tables / Create and drop databases / Create,empty,drop and modify tables / Create,add und change table fields / Manage key und index / Run every SQL-Query / Save output directly as XLS- (MS Excel) or CSV-file / Handles very large databases / FTP-client (SSH2) to down-/upload and delete files or complete folders / Internal online-texteditor / Export/Import databases / Free Tools to Import from XLS- (MS Excel) und CSV-files