Welcome, Guest
Username: Password: Remember me

TOPIC: Merge DB of servers

Merge DB of servers 2 years 10 months ago #69953

  • boni
  • boni's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 13
  • Karma: 0
I have two servers running limesurvey.
I would like to merge them.
What is the easiest way to do that?
I can export server A DB but cannot import (merge) it to this of B.
I can export each survey in A and for each all the response and import them to B.
But, i have to many like that for manual process.
The administrator has disabled public write access.

Re: Merge DB of servers 2 years 10 months ago #69972

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 6451
  • Thank you received: 844
  • Karma: 249
boni wrote:
But, i have to many like that for manual process.
I don't see an easy automatic task to do this, maybe try to make some SQL request, but you have to do some manual task, and the script make time to construct.

Manually, you can export/import lss file and after export/import vv file ( just change the first line of the vv file: copy/apste the first of the new installation)

Denis
The administrator has disabled public write access.

Re: Merge DB of servers 2 years 10 months ago #70014

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5333
  • Thank you received: 296
  • Karma: 249
At the next Limesurvey version there will be a feature to export several (or all) surveys to a ZIP file which can then be imported.

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)limesurvey.org'"
The administrator has disabled public write access.

Re: Merge DB of servers 2 years 10 months ago #70018

  • boni
  • boni's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 13
  • Karma: 0
THANKS.
I wiil wait.
The administrator has disabled public write access.

Re: Merge DB of servers 2 years 10 months ago #70065

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5333
  • Thank you received: 296
  • Karma: 249
boni wrote:
THANKS.
I wiil wait.
You're welcome!

If you enjoy limesurvey please consider a donation to the team .
We do all this in our free time and you don't have to pay a penny for this software.

Without your help we can't keep this project alive.

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)limesurvey.org'"
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.117 seconds
Donation Image