Special / Experimental Installations: Difference between revisions
Jump to navigation
Jump to search
m (→Installation on Synology NAS: Removed versions.) |
m (→Reference) |
||
| Line 25: | Line 25: | ||
* [https://stackoverflow.com/questions/23059697/undefined-class-constant-mysql-attr-init-command-in-undefined-class-constant MySQL Attr INIT Command] will be useful | * [https://stackoverflow.com/questions/23059697/undefined-class-constant-mysql-attr-init-command-in-undefined-class-constant MySQL Attr INIT Command] will be useful | ||
== | == References == | ||
* [https://forums.nubuilder.com/viewforum.php?f=30 nuBuilder for MSSQL Discussions] | * [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=10884 Forum Topic] - Install instructions discussion | ||
* [https://forums.nubuilder.com/viewtopic.php?f=30&t=10886 Forum Topic] - MSSQL Migration progress | * [https://forums.nubuilder.com/viewtopic.php?f=30&t=10886 Forum Topic] - MSSQL Migration progress | ||
Revision as of 18:13, 3 May 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
- Download the codebase
- Install SQL Server 2019 Express if you haven't got an SQL Server running yet.
- For Database management, download and install SQL Server Management Studio (SSMS) or use Adminer instead of phpMyAdmin
- Create a database nubuilder4 in MSSQL Server
- Run the script nubuilder4_mssql.sql (if your db has a different name, search & replace in the script)
- If XAMPP is used, configure it for MSSQL
- Modify nuconfig.php:
$nuConfigDBDriver = "sqlsrv"; //-- MSSQL ( mysql for MySQL/MariaDB )
$nuConfigDBPort = "1433"; //-- MSSQL Port
$nuConfigDBHost = "DESKTOP-xyz\SQLEXPRESS"; //-- Server Name
Installation on Synology NAS
- Forum Post
- Install Apache HTTP Server, MariaDB, PHP, phpMyAdmin, Web Station, pdo_mysql (php extension)
- MySQL Attr INIT Command will be useful
References
- nuBuilder for MSSQL Discussions
- Forum Topic - Install instructions discussion
- Forum Topic - MSSQL Migration progress