Transfer entire databases or selected tables or fields from IBM DB2 servers to SQLite using this intuitive application with practical options.
- DB2ToSqlite
- Version :2.0 Release 1 Build 170614
- License :Trial
- OS :Windows All
- Publisher :Withdata Software
DB2ToSqlite Description
DB2ToSqlite is a simple to use, but powerful tool that facilitates the migration of data and structures from DB2 to SQLite. The software allows you to connect to both databases then perform the transfer as if copying and pasting text within a file. The software allows you to quickly convert data from one format to another.
DB2ToSqlite allows you to operate the data conversion and migration between databases, in a convenient, graphic environment, where you can easily visualize the process.
Moreover, a progress bar indicates the evolution of the transfer. The process implies, of course, that you need to establish a stable connection to both database programs.
You may manually select the source relational model, as well as the tables and preview the data before transferring it. A few destination parameters must also be configured, for a smooth data transfer: you need to indicate the table/schema in which the information is to be copied and specify the data type for each column.
The software can record all the actions performed during a session, the successful migrations as well as errors, then display them in the built-in log.
Alternatively, you may export all the tables stored in the IBM DB2 database. The batch export function allows you to view the list of tables, the corresponding destination and the fields that need to be configured in advance.
DB2ToSqlite allows you to specify the threshold of tolerated errors, a number beyond which the transfer is considered unsuccessful.
Additionally, you may operate a data export via DB2 query: select the source, destination and select the fields, in order to create an export query.
You may save the settings regarding the source, destination and rows to be transferred as a session. Thus, you can simply load this session at a later time, in order to synchronize the data in SQLite. The tasks can be operated from command line or scheduled to be automatically and/or recurrently performed at the specified time/date.
System requirements
- IBM DB2
- SQLite
Limitations in the unregistered version
- 30 days trial
- Nag screen