Cross-Database Studio 6.0

Cross-Database Studio 6.0  offers an effective tool which helps you 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.

Major Features:

1. 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
2. Create & Use custom DBBalance s internal objects:
   • virtual tables
   • stored queries
   • table/view filters
3. 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)
4. Settings:
   • conversion rules for all data types  pairs across databases of different vendors
   • strategy for comparison, synchronization, migration
   • different types of comparison reports
   • Keeps your personal records in a secure database, encrypted with 128 bit encryption, that only you have access to.
   • Maintains records on such persons as want, sex offenders and drug dealers.
   • The ability to export selected records to an Excel file or into an Access database table.
   • When running in Agency Mode you can share a common database across a network, have multiple accounts and user rights, and modify system lists.

Enhancements:

• The new version includes significant improvements in performance
• Ease of use and enhanced security.