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

asked 06 Apr, 03:15

simiti's gravatar image

accept rate: 0%

Dear Smith,
You have 2 options:

  1. 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
  2. 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, 14:37

OF%20Collect's gravatar image

OF Collect ♦♦
accept rate: 22%

edited 06 Apr, 14:37

Your answer
toggle preview

Follow this question

By Email:

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



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

Question tags:


question asked: 06 Apr, 03:15

question was seen: 118 times

last updated: 06 Apr, 14:37