The ODBC Browse utility displays the
following window.
1.
Choose Tools
®
ODBC Browse to open the ODBC Browse utility.
2.
Clicking on the DataSource
button
will prompt for the ODBC DataSource to connect to.
3.
Using the drop-down list will display the tables available in the
DataSource. Once a table has been
selected the column names and their data types are displayed.
4.
Pressing the Table Script
button displays an appropriate SQL CREATE TABLE statement.
By copying the text to the clipboard it can be pasted into a SQL query
tool to create a compatible table.
5.
If appropriate you can add some random text/number data to the table by
specifying the number of rows required and pressing the Add
Test Data button.
6.
The Indexes
button opens up the following window that details
any indexes in the table.
7.
Finally, the Compare
button will open the following window that lets you select a source and
destination
data-source to
perform a comparison of data types.
You can specify a prefix or suffix for each column name or nominate the ordinal
(source and destination columns are ordered the same) checkbox.
If no column prefix/suffix or ordinal is selected the comparison is made
between columns with matching names. If
any incompatible data types or sizes are seen then the Differ
column contains T for type
differences and/or S for a size
mismatch.