Technical information - Studio 6.0

Cross-Database Studio 6.0 

Compare:

• table/view columns properties:
  • column name
  • data type
  • column length
  • column precision
  • column scale
  • column NULL allow
  • column default value
• primary key properties:
  • primary key name
  • primary key column name
• index properties:
  • index name
  • column name
  • index owner
  • unique
  • sort type
• foreign key properties:
  • foreign key name
  • primary table name
  • primary column name
  • foreign table name
  • foreign column name
  • update rule
  • delete rule
• stored procedure (for different versions of database of same vendor):
  • stored procedure name
  • stored procedure body
• table/view data:
  • all or selected table/view data
• batch comparison:
  • including comparison of the table structures, primary keys, indexes, foreign keys, data
  • scheduling is available

Comparison results can be reported to the screen or saved in XML/HTML files.

Synchronize:

• Manual synchronization
  • columns properties
  • primary key properties
  • index properties
  • foreign key properties
  • table/view data
• automatically synchronization
  • all or selected table/view data
  • batch data synchronization (scheduling is available)

Replicate (Migrate):

• Cross database migration of table/view (structure and/or data) based to data types conversion mechanism and custom defined fields list
• batch migration (scheduling is available)

Create & Use custom DBBalance's internal objects:

• virtual tables
• stored queries
• table/view filters

Use Batch operations and Scheduling mechanism:

• for comparison (including comparison of structures, primary keys, indexes, foreign keys, table/view data)
• for table/vie data synchronization
• for replication (migration)

Settings:

• conversion rules for all data types' pairs across databases of different vendors
• strategy for comparison, synchronization, migration
• different types of comparison reports