Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Migration from Postgresql to MySQL

  • mferraz
  • mferraz's Avatar Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
3 months 4 days ago #254910 by mferraz
Migration from Postgresql to MySQL was created by mferraz
Hi

After the last releases that completely broke our Limesurvey installation, we've realized that the PostgreSQL installations are completely forgotten from any test that most developers can make.

So, is there any safe way to migrate to MySQL?

Please Log in to join the conversation.

  • c_schmitz
  • c_schmitz's Avatar
  • Offline
  • LimeSurvey GmbH Employee
  • LimeSurvey GmbH Employee
More
3 months 2 days ago #254962 by c_schmitz
Replied by c_schmitz on topic Migration from Postgresql to MySQL
I am sorry to hear that. Unfortunately, there is no easy wholesome way to migrate to MySQL, as datatypes can be very different between databases.

Would you maybe be interested to sponsor CI testing on Postgres?

Best regards

Carsten Schmitz
LimeSurvey project leader

Please Log in to join the conversation.

  • mferraz
  • mferraz's Avatar Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
2 months 3 weeks ago #255605 by mferraz
Replied by mferraz on topic Migration from Postgresql to MySQL
Hi.

As a University, we can't do donations, but we can contract/subscribe for services. However, I have to convince them to advance with that.
So in meanwhile, I guess I have to start a new installation from scratch on MySQL and discontinue our PostgreSQL installation.

Please Log in to join the conversation.

  • mferraz
  • mferraz's Avatar Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
2 months 2 weeks ago #255632 by mferraz
Replied by mferraz on topic Migration from Postgresql to MySQL
Is there a way to export users with their permissions?

Please Log in to join the conversation.

  • mferraz
  • mferraz's Avatar Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
2 months 2 weeks ago #255637 by mferraz
Replied by mferraz on topic Migration from Postgresql to MySQL
Also, I'm reading about the comfort update key:
community.limesurvey.org/comfort-update-extension/#

Is the LTS access included in this subscription?

Please Log in to join the conversation.

  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
2 months 2 weeks ago #255639 by holch
Replied by holch on topic Migration from Postgresql to MySQL
Afaik there is no LTS anymore.

I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.

Please Log in to join the conversation.

  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
2 months 2 weeks ago #255640 by holch
Replied by holch on topic Migration from Postgresql to MySQL

Would you maybe be interested to sponsor CI testing on Postgres?


As far as I understood, this means paying for a service. Not a donation.

I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.

Please Log in to join the conversation.

  • mferraz
  • mferraz's Avatar Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
2 months 2 weeks ago #255643 by mferraz
Replied by mferraz on topic Migration from Postgresql to MySQL
So, the description should be updated not to include the LTS access on that URL.

Please Log in to join the conversation.

  • mferraz
  • mferraz's Avatar Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
2 months 2 weeks ago #255644 by mferraz
Replied by mferraz on topic Migration from Postgresql to MySQL
Sure, if we subscribe to a comfort update key in a way to sponsor that?
Or can the support to PostgreSQL installations be improved by subscribing it?

We can't "sponsor" individual one-time services.

Please Log in to join the conversation.

  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
2 months 2 weeks ago - 2 months 2 weeks ago #255654 by holch
Replied by holch on topic Migration from Postgresql to MySQL
I have no insights into what Limesurvey GmbH can offer and what not. I am only providing my view as a user of Limesurvey and my experience in the past.

Any details regarding this must be discussed with Limesurvey GmbH directly. But as Carsten has already respondet in this thread, he might see your questions and respond here, without the need to get in touch with them via support ticket or similar. Time will tell.

Sure, if we subscribe to a comfort update key in a way to sponsor that?


But I highly doubt that a comfort update subscription will be enough to "sponsor" a more indepth testing for PostGre. I think that is a totally different beast. The comfort update subscriptions as a whole sure help to support Limesurvey and its development. But I highly doubt that one additional CU subscription will pay for the additional resources to do thorough testing for PostGre support. I mean, PostGre is supported and generally works. But while I am sure that there is some basic testing by the core developers, at the end the real life test (like with many other softwares today) is by the end user. So it also depends a little bit on the community to test during alpha and beta stages as well as reporting issues in the bug tracker. Reported issues usually get resolved fairly quickly in Limesurvey, in my experience. Just like these issues seem to be resolved in then newest release, according to Denis.

I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.

Last edit: 2 months 2 weeks ago by holch.
The following user(s) said Thank You: mferraz

Please Log in to join the conversation.

  • mferraz
  • mferraz's Avatar Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
2 months 2 weeks ago #255655 by mferraz
Replied by mferraz on topic Migration from Postgresql to MySQL
Yep, I've already contacted the sales, tks.

Please Log in to join the conversation.

Lime-years ahead

Online-surveys for every purse and purpose