|
SQL DBCS (SQL Server
Databases Comparison and Synchronization)
SQL
DBCS is every database administrator companion tool. With DBCS
quickly compare the schema and properties of any given number of SQL
Server databases located on a local machine, between remote servers on a LAN
or over the Internet. Find the differences and synchronize your
databases.
DBCS
compare all SQL Servers Objects:
 |
Databases Options
 |
Including but not limited to Auto Shrink, Auto Update
Statistics, Quoted Identifier, Recursive Triggers. |
|
|
|
Tables
|
|
Columns
definition and Declarative Referential Integrity (DRI),
Checks, Clustered Index, Indexes, Keys, Primary Key,
Foreign Keys, Triggers |
|
|
Owner, Data used
space, Index space |
|
|
|
Views
|
|
Definition,
Columns, dependencies (SQL Server 2000 specific) |
|
|
|
Stored Procedures
|
|
Definition,
Parameters, dependencies (SQL Server 2000 specific) |
|
|
|
Users |
|
|
Rules |
|
|
Defaults |
|
|
User Defined
Data Type |
|
|
User Defined
Functions |
This the perfect tool to know what the exact differences are between
your latest reference database and your installed base customer
databases. Run SQL DBCS to synchronize your customers databases
before an upgrade to the latest version of your software.
Every
time a developer changed a table or a stored procedure, SQL DBCS gives you a
script to run for the next upgrade. Run DBCS after your customer
upgrade to double-check that all database scripts have been applied
correctly.
Preview of SQL DBCS.
Release scheduled for early 2005.
|
Compare Operation
- Progress Dialog Window |
|
 |
|
SQL DBCS gives you a
complete feedback on the compare or synchronize operation
being performed.
A report windows
describes the current tasks being performed (completed,
running). When a task is running a
progress bar indicates (in %) how much been completed
so far.
A user can
pause/resume or cancel a compare or synchronize operation at
anytime. All changes applied during a synchronize
operation that users cancelled, are automatically roll back. |
|
|
Compare Operation -
Result Window |
|
 |
|
|
|
|
A tree view on the left displays all
databases objects. When an object is selected its properties appear on the right respectively
for each databases. You can visualize then the databases differences
for the selected object. The object view-window uses the same syntax highlight rules than
the SQL Analyzer. |
|
|
|
