Compare and
synchronize both schema and data for Microsoft SQL Server 7, 2000, 2005, 2008.
|
|
| Fast performance. |
|
| Create projects to
manage often repeated comparisons. Connection
manager retains common connections for fast recall. |
|
| Advanced command
line script processor to auto execute compare and
synchronize. Includes ability to email alerts or
scripts, all defined in xml script file. |
|
| Compare from
backups |
|
| Ability to create
a new database, ideal for moving selected parts of
one database to another. |
|
|
|
|
| Structure
Compare
|
|
| Compare all
schema objects in a
database |
|
| Generate
synchronize scripts plus execute scripts
from SQL Delta |
|
| Create
schema snapshots and perform offline comparison. |
|
| Compare
diagrams |
|
| Compare
and update full text catalogues |
|
| Unique,
easy to read display of table compare
information |
|
| Optional
case sensitive structure comparison |
|
| Object
owner mapping allows the user to map one or more
database owners to another. |
Note
1 |
| Extensive
database object search capability |
|
| Large
array of filters for displaying specific schema
information |
|
| Ability
to view data of a table or view directly from schema
compare. This feature may help a user contextualize
the differences that may exist between two tables or
views. |
|
| Update
* (star) views tool allows the user to correct
possible inconsistencies within SQL Server where a
view contains a "select * ..." statement and the
underlying table has been changed. |
|
| Qualify
names tool allows the user to correct object name
inconsistencies where an object has been renamed
within the enterprise manager. |
|
| Extensive
reporting including the ability to print the
entire database schema along with a detailed
comparison report. |
|
| Script
view syntax highlighting |
|
| Unique!
Synchronizes in multi
direction directly from SQL Delta. In a single
synchronize process you can update both databases. |
Note
2 |
| Copy
parts or all of the script from script compare
window for all objects including tables |
|
| Preserve
Column order option |
|
| Alert
for column order difference |
|
| Copy
and Save scripts for later use |
|
| Automatic
Dependency management |
|
|
|
|
| Data
Compare
| |
| Supports
user defined key specification as well as Primary
key or unique key |
Note
3 |
| User
defined compare columns |
|
| Filtering
of data within compare tables |
|
| Choose
update rows on a row by row basis |
|
| View
difference rows in context with same data. This is
quite a unique feature allowing you to see the
differences inline with the same data. Very helpful
when analyzing why and where data differences occur. |
|
| Also
view difference rows separately from same data. |
|
| Multi
directional synchronizing. The data synchronize
process can update both databases within the one
process. |
Note
4 |
| Compares
BLOBS as well can ignore Timestamp and GUID fields |
|
| Other
|
|
| Integrated
updates, SQL Delta can check and self-update |
|
- Microsoft Windows 2000 or higher
- 50mb disk space
- 256mb RAM
- 800x600
- Microsoft SQL Server 7 or 2000, 2005, 2008
- MDAC 2.6 or higher (you can download from Microsoft for free if needed)
You don't need any SQL Server client utilities.
Note 1You can map one or more owners from the source database to one or more owners in the target database. This is ideal
for cases where a development database utilizes lower security than a production database, allowing you to keep the databases in sync without sacrificing security.
Note 2
SQL Delta provides a unique feature where you can perform multi-directional scripting. You can send changes for one object (such as table) in one direction and changes to another object in a different direction all in the one session. For example you can script the changes to Products from database A to B and for Customers from database B to A.
Note 3
In some cases a table may not have a primary key or unique index however there are fields that combined to generate a unique ID that can be used for data comparison. SQL Delta lets you choose your own fields to perform the comparison. This is also useful where the primary key is not the ideal unique key and an alternate key is preferred.
Note 4
You can send your data changes in both directions within the same session. Like schema scripting the data comparison update lets you choose one table to update from database A to B and another table to update from database B to A.
