The Very Simple Database Inspector
 |  |  |
| Feature List
| |
|
Compare Databases
Compare the structure of two databases, and highlight the difference
Synchronize Databases
Once the differences are identified, you can update the destination database with
a click of the mouse
Multiple Database Types
The database inspector supports a variety of database types, all in one package
Easy to Use
The database inspector has been designed with ease of use and transparency in mind. All
SQL may be viewed before it is run on the destination database, and you can see the structure
of the destination at any time. The database inspector will even alert you if a change is going
to cause problems or cannot be run
Sql Editor
Unlike other synchronization software, the database inspector allows you to make changes to
your sql on the spot. No more copy/paste to third party editors
Save Frequent Work
Save your common comparisons for quick reference later. The database inspector has been created
to make deploying your database changes as painless as possible
Command Line Support
All features of the database inspector may be accessed via the command line, allowing to generate
and store script files any on your computer, at any time.
Scripting
Run changes immediately on your destination database, or save to a script file for updating later or archiving.
Complete Version History...
| |
 |  |  |
The Very Simple Database Inspector is a free database comparison and synchronization tool designed
to quickly and easily synchronize structures between two or more databases, including triggers, functions, views, tables, stored procedures, indexes, & primary keys.
Read below for more details of the various features, or click here to download
and get started immediately
Multiple Database Support
The Very Simple Database Inspector supports both Sql Server and Microsoft Access
so you don't have to buy multiple synchronization packages for your differing development architectures.
Structure Synchronization
The Very Simple Database Inspector will detect differences between your databases and provide SQL to
allow one-click synchronization between
table definitions,
column definitions,
primary key information,
stored procedures,
views,
functions,
triggers,
and indexes
All changes are presented in a filterable list allowing you to isolate particular types of changes. Simply
click on an item to synchronize the structure between the two databases
Synchronize Mapping Tables
Chances are your database contains one or more mapping tables - tables which contain hard-coded data which
is required to be static across all databases, such as a list of countries. The Very Simple Database Inspector
allows you to identify your mapping tables and synchronize their contents between databases.
Helpful Warnings and Suggestions
Where an item is unable to be updated, or the software has detected some type of anomoly, the
Very Simple Database Inspector will advise the user in clear easy to read language, and
in some cases provide instructions on circumventing or resolving the problem
Sql Editor
Use the built in Sql Editor to customize your commands to exactly how you want. Unlike other
synchronization software, you do not have to copy/paste your sql to a third party editor.
All changes
you make are updated back to the synchronization tool and can be applied with a simple mouse click
Search Function
The search function allows you to quickly find structures in your database according to a key word or phrase.
An excellent
use of this is for finding stored procedures or views which refer to a column name. Alternatively, you may want to find indexes
which refer to a particular table
Rules Wizard
Not all structures should be synchronized, and the Very Simple Database Inspector recognises this.
Use the Rules Wizard to recognise certain structures and perform actions on them, such as ignoring any changes.
The Rules Wizard turns the Very Simple Database Inspector from a blind comparison tool into an
intelligent, adaptive tool which will accomodate a large variety of database structures and personal preferences
Third Party Integration
The Very Simple Database Inspector embraces the power of your other software by allowing you to specify
command line arguments to run against it. Use key phrases to send either the source or destination sql to
any software of your choice (which supports command lines).
Script Database Changes
Instead of implementing your changes immediately your destination database, you may instead save them to a script file to run at a later date, or to use as an archive.
The Very Simple Database Inspector also allows you to script an entire database structure for backup or restore purposes.
Synchronize Databases from the Command Line
The entire range of Database Inspector features may be accessed directly from the command line, allowing
you to schedule periodic updates or backups without the need for an interface.
|