Welcome, Guest
Username: Password: Remember me

TOPIC: Switching database server

Switching database server 3 years 5 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.

Re: Switching database server 3 years 5 months ago #60449

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 6429
  • Thank you received: 839
  • Karma: 249
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 ....

:)
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.099 seconds
Donation Image