| || || |
db2db screenshots along with an overview of how to begin using the application:
Register jdbc drivers with the application here. Alternatively, drivers can be used if they are available on the classpath (see userconnection screenshot below).
Create a userconnection, where a userconnection is a collection of details needed to connect to a DBMS e.g. username, password, the JDBC driver (as registered above).
Set up a datatype mapping for each database you want to transfer tables to. db2db works by retrieving data and metadata from a database using JDBC datatypes. In order to create and populate tables in the target database it needs to maintain a mapping from these JDBC datatypes to equivalent types in the target database. As an example, the mappings are of the form:
This indicates that the JDBC type decimal maps to the database specific type decimal. In addition, 0, 1 or 2 arguments may be used with a precision in the range 1-28 and a scale in the range 0-28. There are three ways to create this mapping:
|db2db will query the JDBC driver and the target database to discover mappings.|
|The user can enter the 'base type' (e.g. decimal) and db2db will discover the arguments allowed for that type (e.g. decimal(1-28);decimal(1-28,0-28)).|
|The user can enter the complete mapping.|
Now some tables can be copied from one database to another. A userconnection is chosen as the source database and another as the target database. Tables are chosen for transfer and the transfer is initiated.
An SQL query builder allows SQL queries to be created, saved, opened and run against the database.
The database browse shows information about the database: schemas, tables, table types, data, column datatypes, primary keys, referential integrity constraints, etc.
| || |