Cross-Database Studio 6.0

Cross-Database Studio 6.0 is a single comprehensive and integrated working environment to compare, synchronize and replicate across databases.

Using Cross-Database Studio 6.0 you can compare, synchronize and replicate data and structure across any database types. DBBalance’s products take the “pain” out of comparison and replication rules definitions while shortening and simplifying processes

Cross-Database Studio 6.0 includes comparison, synchronization and replication results reports in XML and HTML formats. These reports can simply be integrated into any reporting or process control system.

DBBalance’s solutions include a wide spectrum of predefined settings and rules for comparison and replication. There is no need to configure relations between different data-types and objects for comparison and replication between different database types. Simply select the objects you wish to compare, synchronize or replicate, and you’re done. You can always control the settings and define your own rules, if your process requires any special definitions. You can also schedule the time for start of execution.

Technical information(Feature list)

There is no need to install and configure a separate set of ODBC drivers. Our products include a set of world leading ODBC drivers.

Using Cross-Database Studio 6.0 you can compare, synchronize or replicate any set of objects between one database type and another.

• Compare, Synchronize, Replicate:
  • 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)
  • Creating the strategy for full table or partial list of objects
• 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