Editor's review
This tool helps migrate Access data to SQLite.
Features available with this tool simplifies migration of data from Access database to SQLite. This tool is compatible to Windows down to the latest version 8 in both 32 bit and 64 bit versions. Transfers can be directly from Access table to a table in SQLite. Setting up could be done visually. There is a progress bar that not only tells you how much of the transfer has been done but also what’s left. It is possible to also gather data through a query on the source database. The interface is well organized and setting up a transfer is simple. Users should not find it difficult at all. The IT types that will be managing such data transfers will be able to get started with this intuitive interface quite easily. You have to choose the right source schema, then a table from where the table to table transfer is to be done. The destination table is chosen similarly.
For transfers by query, besides forming the SQL query, you will need to specify the destination table. It is possible to run a batch of transfers. Whenever data from different tables are to be transferred, this mode would be useful. Session parameters can be saved so that next time a similar transfer can be set from retrieved parameters. Batches could be run from the command line interface provided. You will need some experience before you can do this. There is a task scheduler is available so that routine transfers can be scheduled based on convenience of the IT administrators. This is a very good tool.
User comments