PostgresToSqlite is simple to use and facilitates the direct information transfer between two database formats. The software specializes in transferring data from PostgreSQL to SQLite, through several alternative processes.
Thanks to the wizard functions, it can guide you through all the steps of the data migration even if you do not have extended SQL knowledge. The software features a separate wizard that can help you through all the steps of each transfer method. Thus, you may migrate a single table, a series of tables or define the source of the transfer via query, all with the guidance of the wizard.
The software requires that you connect to both database managers, in order for you to be able to control a specific segment of information. Thus, you can select the desired tables and rows that you wish to transfer, from one of the existing particular schemas. Moreover, you need to select the exact destination where you wish the data to be transferred.
Indicating the exact source and destination is why a direct connection to both databases is required. In the case of single table transfer, you may even create a new destination structure in the receiving database. The application allows you to configure each table you transfer, by checking the rows for export and unchecking those that should be ignored.
The previewing areas allow you to manually configure the tables, as well as peek at the final result. The data can be transferred by appending the existing information in the destination table, by replacing it or by updating it.
Alternatively, you may create a SQL query in order to define the source of a transfer or to control the entire process. Once you have set all the preferences, you can save the current session, then run or schedule it for a later time. The software supports scheduling tasks for single or recurrent execution.