| | 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: decimal=decimal;decimal(1-28);decimal(1-28,0-28) 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. | | |
|