Editor's review
This is a tool that helps migrate data from DB2 to MS Access databases automatically.
DB2ToAccess is a data conversion tool that helps the DBA and database programmers convert DB2 data to Access. You are able to configure the utility easily through the visual interface. It just takes a few mouse clicks. You will need to specify the schema and then choose the table with simple clicks. You can choose to export all the tables too. The data export can be set up through query too. This visual display also serves as an indicator of the completion of data export. As each table export is completed, you get a "done" indication beside it. If all the tables are to be exported then just select all. On making a mistake you can do a select none and then choose the right ones to export. Thereafter it is a single click on the export button.
The progress bar along with some statistics indicates to you how the job is progressing. You get to see the table name, number of records exported, percentage of the job done and a visual display of the progress. Elapsed time is also indicated. The session parameter that you use can be saved and used over and over again. That too would add to the productivity gain on top of the automatic transfer capability gains. As the program supports Unicode, all the multi byte languages, particularly the Asian ones are supported well. This tool can be really useful when you have this kind of data transfer needs often.
User comments