Welcome, Guest
Username: Password: Remember me

TOPIC: Switching database server

Switching database server 4 years 3 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 4 years 3 months ago #60449

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • Moderator Lime
  • Posts: 7495
  • Thank you received: 1021
  • Karma: 296
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.171 seconds