Special / Experimental Installations: Difference between revisions
Jump to navigation
Jump to search
m (→Installation on Synology NAS: Removed versions.) |
m (→References) |
||
| (2 intermediate revisions by 2 users not shown) | |||
| Line 21: | Line 21: | ||
== Installation on Synology NAS == | == Installation on Synology NAS == | ||
* [https://forums.nubuilder. | * [https://forums.nubuilder.cloud/viewtopic.php?f=23&t=10901 Forum Post] | ||
* Install Apache HTTP Server, MariaDB, PHP, phpMyAdmin, Web Station, pdo_mysql (php extension) | * Install Apache HTTP Server, MariaDB, PHP, phpMyAdmin, Web Station, pdo_mysql (php extension) | ||
* [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. | * [https://forums.nubuilder.cloud/viewforum.php?f=30 nuBuilder for MSSQL Discussions] | ||
* [https://forums.nubuilder. | * [https://forums.nubuilder.cloud/viewtopic.php?f=30&t=10884 Forum Topic] - Install instructions discussion | ||
* [https://forums.nubuilder. | * [https://forums.nubuilder.cloud/viewtopic.php?f=30&t=10886 Forum Topic] - MSSQL Migration progress | ||
Latest revision as of 09:53, 29 January 2022
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