Check out the LimeSurvey source code on GitHub!
Welcome, Guest
Username: Password:

TOPIC: Switching database server

Switching database server 5 years 2 months ago #60350

  • jonoF
  • jonoF's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 5
  • Karma: 0
What is the best way to switch the database server used for limesurvey (in this case from MySQL to MS SQL Server)? Should I just update config.php and run admin/install again - will that work? Or is there a better way?
The administrator has disabled public write access.

Switching database server 5 years 2 months ago #60449

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • Moderator Lime
  • Posts: 9254
  • Thank you received: 1319
  • Karma: 382
Hello,

There are no easy way to change the database type after installation. I think the best is :
-* Update LS at the last stable version
- Export all of your survey
- Export all of your answer
- Export all of your token table
-* Install LimeSurvey with the new DB tye
- Import, import, import ....

:)
Assistance on LimeSurvey forum and LimeSurvey core developpement are on my free time (Say thanks ?).
A bug not reported is a bug not corrected. | Please, read the documentation | La doc en français à besoin de vous
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.209 seconds
Imprint                   Data Protection Statement                  Revocation information and revocation form