Special / Experimental Installations: Difference between revisions

From nuBuilderForte
Jump to navigation Jump to search
No edit summary
No edit summary
Line 21: Line 21:


== Reference ==
== Reference ==
* [https://forums.nubuilder.com/viewtopic.php?f=30&t=10884 Forum Topic]
* [https://forums.nubuilder.com/viewforum.php?f=30 nuBuilder for MSSQL Discussions]
* [https://forums.nubuilder.com/viewtopic.php?f=30&t=10884 Forum Topic] - Install instructions discussion
* [https://forums.nubuilder.com/viewtopic.php?f=30&t=10886 Forum Topic] - MSSQL Migration progress

Revision as of 13:55, 13 March 2021

Replace MySQL with MSSQL for nuBuilder 4.5

  • This is a very new experimental work-in-progress.
  • Attempt this only if proficient in the MSSQL PDO stack with PHP.
  • smalos/nuDev repo has the codebase as of Commit #301.

Install Instructions

  1. Download the codebase
  2. Install SQL Server 2019 Express if you haven't got an SQL Server running yet.
  3. For Database management, download and install SQL Server Management Studio (SSMS) or use Adminer instead of phpMyAdmin
  4. Create a database nubuilder4 in MSSQL Server
  5. Run the script nubuilder4_mssql.sql (if your db has a different name, search & replace in the script)
  6. If XAMPP is used, configure it for MSSQL
  7. Modify nuconfig.php:

    $nuConfigDBDriver = "sqlsrv"; //-- MSSQL ( mysql for MySQL/MariaDB )
    $nuConfigDBPort = "1433";     //-- MSSQL Port
    $nuConfigDBHost = "DESKTOP-xyz\SQLEXPRESS"; //-- Server Name

Reference