IdxScout v.2.0.4

Advertisement
Advertisement

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.

Foreign Keys, Effortless Data Models & SQL. Find Foreign Keys. Effortless Data Models. SQL Made Simple. Developers, Crystal Report Pros, and Data Analysts will love it. Hunt database keys. Use it for a model. Unique interface makes sense. Works with SQL Server, MySQL, Oracle, MS Access & DBF.

relational databases, sql, queries, sql joins, modeling, mysql, key hunter, machine assisted sql, unique interface, foreign keys, sql server, oracle, ms access, fast

 
  • IdxScout
  • 2.0.4
  • idxSoft LLC
  • WinXP, WinVista, WinVista x64, Win7 x32, Win7 x64
  •  
  • Shareware
  • 843 Kb
  • 499
  • $149.00
 
 

Review IdxScout

  • captcha
 

Other software of idxSoft LLC
  • DocuGrab Word Search and View  v.1.2DocuGrab Word Search and View brings the power of Google, Yahoo, and Bing search engines to your desktop, allowing you to instantly search all your PDF, Word and text files for words and phrases and find the documents you are looking for. A ...
  • PicBlitz Photo Viewer and Organizer  v.3.21.1PicBlitz Photo Viewer and Organizer features a viewer with video-like speed and an organizer with a do it first, save it later design supporting all major digital camera formats. The viewer has a no-click, mouse hover design. Mouse over an image and ...
  • PicBlitz Virtual Photo Manager  v.3.20.0As Quick as a Blink, PicBlitz Virtual Photo Manager has the power to handle more than 500,000 photos and images in the blink of an eye; at speeds you've only dreamed of. Featuring mouse hovering, instant search, slide show, batch resize, brighten, ...

New Database Management software
  • DataNumen DBF Repair  v.3.0DataNumen DBF Repair is a powerful tool to repair corrupt DBF files. It uses advanced technologies to scan the corrupt DBF database and recover your data in it as much as possible, so to minimize the loss in file corruption.
  • DotConnect for Salesforce  v.4.0.0dotConnect for Salesforce is an ADO.NET provider for accessing data of the Salesforce.com cloud CRM and Database.com cloud database through the standard ADO.NET or Entity Framework interfaces.
  • Sharepoint Server Recovery  v.19.0SharePoint Database Recovery Tool provides two recovery options: document recovery and complete database recovery. This software recovers SharePoint data from the corrupted database files with absolute accuracy.
  • Service Admin  v.1.1.122.1Service Admin is an easy-to-use Windows program. It keeps details of all of your customers and enables you to create invoices and job sheets. It has a parts database including min/max stock fields. Pop-up reminders and notes keep you on track.
  • Profile Migrator  v.1.0Profile Migrator by sepago is the powerful tool for a centrally controlled migration of individual user settings on desktops and servers.
  • UToolbox Color Picker Tool  v.1.0Color Picker is a tool to pick the color from the screen. It will display the color value in HTML format and display the Red, Green and Blue components (RGB) of it.