How to export SQLite datas into PostgreSQL (same table structure)

[swierzbicki]

Hello,

I need to transfert SQLite datas into PostgreSQL.
Both database does have the same table structure, fields names, fields type...

When dumping SQLite Database (TUniDump), Boolean fields value are exported as integer values. SQL script cannot be executed under PostgreSQL as boolean fields should be exported as TRUE or FALSE.

In my case, dump sounds not like the way to go. What will you advise me ?

[MaximG]

To transfer data between different databases You can try to compose your own application, in which logic of processing of different data types would be implemented. In this case, the TCRBatchMove component might be useful, as it allows data transfer between various datasets. Its detailed description is available at our website: https://www.devart.com/unidac/docs/?dev ... chmove.htm . In addition, to solve this task, you can use the TUniLoader component: https://www.devart.com/unidac/docs/?dev ... loader.htm

[swierzbicki]

Thank you for the tip. This is so far (in my early test) well working.