Is there any recommended steps to migrate sqlite data to postgresql

0	I recently installed Collect in a multi user environment using postgresql. I have old data in my Standalone Collect environment. What is a recommended steps to migrate sqlite data to postgresql? Thanks Smith collect asked 06 Apr '22, 03:15 simiti 11●4 accept rate: 0%

2 Answers:

active answers oldest answers newest answers popular answers

Dear Smith,
You have 2 options:

take a complete backup of survey(s) and data from the Backup / Restore module in Collect and restore the backup in the new installation of Collect, the one using PostgreSQL
export the content of the database from SQLite to SQL, using for example a software like SQLite browser, that is free, modify the generated SQL and try to restore it into PostgreSQL; the structure of databases is similar, you shouldn't have big issues (skip the part of the database/schema/tables generation while restoring it).

We suggest you to use the first option, that is probably faster.
Let us know, many thanks.
Open Foris Team

permanent link

answered 06 Apr '22, 14:37

Stefano (OF) ♦♦
5.0k●1●1●9
accept rate: 19%

edited 06 Apr '22, 14:37

I managed to migrate the data from SQlite to PostgreSQL but it throws out error. I still cannot get it to work.

(29 May '22, 02:07) simiti

Dear Smith, please try to migrate only the data to the PostgreSQL database. First of all configure Collect to work with a new PostgreSQL database, start it up and let it create an empty schema into it. Then export only the data from the SQLite database and import it into the tables of the PostgreSQL database. We will contact you to your private email address to try to help you with this.

(30 May '22, 13:22) Stefano (OF) ♦♦

Dear Smith,
If you have a small number of surveys in your installation of Collect, the easiest thing would be to take a Backup of each survey and Restore it in the new installation of Collect.
You can easily do it from the Backup/Restore module in the application.
Many thanks,
Open Foris Team

permanent link

answered 08 Jun '22, 10:20

Stefano (OF) ♦♦
5.0k●1●1●9
accept rate: 19%

Your answer

toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Question tags:

collect ×495

question asked: 06 Apr '22, 03:15

question was seen: 1,323 times

last updated: 08 Jun '22, 10:20

Is there any recommended steps to migrate sqlite data to postgresql

Follow this question

Related questions