Q What database servers does CDBS software supports?
A For access to databases the software uses ODBC interface. This allows it to realize access
practically to any data store managed by any database management system. Our QA teams have
tested software's work against Oracle, MS SQL Server©, MySQL, PostgreSQL, DB2, Sybase,
Paradox, Microsoft Access©, FoxPro and others.
Q I logged in my database as normal. But I can not see any of the Tables or Views and most of the
program icons and commands are disabled.
A Probably you are connecting to the databases, using credentials of some db user that is not owner
of any db schema. In order to see all schemas that the user has permission to see please try to
connect, using All schemas mode:
Before connecting:
1. Right-click on DSN in the CDB's connection tree
2. Select "Properties" option of popup menu.
The "Connection properties" dialog is displayed.
3. Select "Settings" tab of the dialog
4. Select "All Database Schemas" option from "Schema
Mode" dropdown list
5. Press "Apply" or OK button to save the new settings.
This option allows user to see all permitted tables, not only the tables which are included into his
schema.
Q Does the your tool compare/synchronize Stored Procedures?
A CDBS is able to compare and synchronize Stored Procedures of homogeneous databases. Stored
Procedures are very special database objects. Their syntax, for example, differs from vendor to
vendor. Therefore we don't see any possibility and any sense to compare SP of heterogeneous
databases.
Q CDBS is saying some tables have data differences, despite they look identical. Why?
A The compared textual data, despite it look identical, can differ by presence of invisible
leading/trailing white spaces. You can configure the comparator to ignore such differences. In order
to do this
1. Right-click on the data source connection in the connection tree and select Properties item of
the popup menu. The Connection Properties dialog is displayed.
2. Go to Settings tab of the dialog
3. Select All Database Schemas option from
Schema mode dropdown listand press OK or Apply button to save the new settings
Q Whether CDBS supports scheduling feature?
A Yes. CDBS supports scheduling of batch comparison and synchronization. CDBS has its own
scheduling mechanism and there is no needs to use a third party schedulers, as Windows
Scheduler etc.
Q Does your comparator provide any facility to 'mask' data that we expect to be different?
A Yes, you can tell CDBS to ignore some fields while comparing, to do this. In order to do this,
select a field and right-click on it. The drop-down menu that appears offers the options for the
specific field: to enable/disabe it or to set it as an order field.
Q I have a table in two databases which are identical, but the field order is different. Can CDBS to
ignore this difference?
A Yes. You can sort the fields in the alphabetical order before run the comparison, synchronization
or migration.
Q Is it possible to synchronize only a subset of data, instead of an entire table? For example, I want
to synchronize only rows that meet certain conditions...
A In order to do this you can use the Virtual Tables feature of the product. The Virtual Tables tables
are SQL SELECT statements stored in the internal application database on local machine and
registered for specific data source.
It can display only rows that meet specific conditions, or merge data that is stored in several
tables. You can compare synchronize and migrate those Virtual Tables as you compare,
synchronize and migrate the regular tables. It is clear that by synchronizing the Virtual Tables you
synchronize the phisical tables, whose data is represented by the Virtual Tables.
Q I am trying to migrate/synchronize data between source table which has the column order as
col1,col2,col3,col4 into destination table which has the colum order as col1, col3, col2, col4. My
intention is that the values of col2 of source table should go into col2 - not col3 - of destination
table. Is there any way in the tool to change the mapping of the columns in a source and
destination tables?
A In order to do this you can use the Virtual Tables. Just create the Virtual Table that represents the
data of source table, but has the desired column order - i.e. the order that corresponds to column
order of destination table. Now you can synchronize or migrate data between the created virtual
table and the destination table.