Used Compare for Windows?


Editors’ Review

Download.com staff
Compare is a versatile tool for viewing, querying, and updating files currently in use by other applications. It supports SQL execution on local and remote databases, including dBASE, Paradox, and SQL Server, with integrated task scheduling functionality.
Enlarged image for Compare
Compare 0/1
  • Pros

    • Modifies files currently locked by other active applications
    • Executes SQL queries on local dBASE and Paradox databases
    • Connects to remote databases via LAN or TCP/IP
    • Schedules automated data transfers and file update tasks
    • Imports spreadsheet and text data into local database tables
  • Cons

    • Requires established TCP/IP or LAN for remote database access
    • Internal table creation uses the MS Access database format
    • Lacks a graphical interface for building complex SQL queries
    • Focuses primarily on legacy database formats like dBASE and Paradox

Used Compare for Windows?


Explore More


Full Specifications

GENERAL
Release
Latest update
Version
3.5
OPERATING SYSTEMS
Platform
Windows
Operating System
  • Windows 2003
  • Windows NT
  • Windows 2000
  • Windows 7
  • Windows Server
  • Windows ME
  • Windows Vista
  • Windows 10
  • Windows 8
  • Windows XP
  • Windows 98
Additional Requirements
None
POPULARITY
Total Downloads
499
Downloads Last Week
1

Report Software

Program available in other languages


Last Updated


User Reviews

4/5

1 User Votes


Developer’s Description

View, query, edit, update files which are currently in use by other applications
Compare gives you the ability to view/query/edit/update files which are currently in use by other applications, and the flexibility of scheduling when such tasks as data transfers and file updates take place. Compare allows you to write and execute SQL queries on any local dBASE or Paradox database, and, via a LAN or established Internet (TCP/IP) connection, execute SQL commands on remote (or local, 127.0.0.1) MS Access, SQL Server, or other SQL databases, to insert, update or retrieve data. You may also retrieve data from remote spreadsheets or text files, and save the data as a table in Compare's Access database. Then, from within Compare, you can open, edit, re-save, or delete tables. You can also use the SQL 'INTO' clause to create new tables in Compare's database. Save the SQL statements you write, and re-use them at a later time.Compare lets you easily manipulate data in local (or remote, via a mapped drive) dBASE, or Paradox databases, whether two fields in one database or one field in two databases. Compare gives you the ability to specify various criteria, and processes fields based on those criteria. For example: If data in File A is equal/not equal/greater than/less than/before/after data in File B/entered data, delete data in File B/A; replace data in [any field] with data from [any field] (or entered data); or export fields in File A/B to a file you select. If files to be exported from have field names in common, and the fields are selected from both files, Compare can re-create a table in its database with the fields you selected to export from, and additional fields to hold data that is to be exported from the duplicate field(s). You will then be able to VIEW/Edit the table, save it as a name of your choice, and re-open it for editing or delete it at a later time. Alternatively, Compare can create a new record, in the file you open to export to, each time data from a duplicate field must be written.

Download.com
Your review for Compare