Special / Experimental Installations: Difference between revisions
Jump to navigation
Jump to search
Created page with "== 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. * [http..." |
|||
| (8 intermediate revisions by 2 users not shown) | |||
| Line 10: | Line 10: | ||
# Create a database '''nubuilder4''' in MSSQL Server | # 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) | # Run the script '''nubuilder4_mssql.sql''' (if your db has a different name, search & replace in the script) | ||
# If XAMPP is used, [https://stackoverflow.com/questions/32978554/how-to-configure-xampp-to-use-with-mssql configure it for MSSQL] | |||
# Modify '''<tt>nuconfig.php</tt>''': | # Modify '''<tt>nuconfig.php</tt>''': | ||
<pre> | <pre> | ||
$nuConfigDBDriver = "sqlsrv"; | $nuConfigDBDriver = "sqlsrv"; //-- MSSQL ( mysql for MySQL/MariaDB ) | ||
$nuConfigDBPort = "1433"; | $nuConfigDBPort = "1433"; //-- MSSQL Port | ||
$nuConfigDBHost = "DESKTOP-xyz\SQLEXPRESS"; //-- Server Name | $nuConfigDBHost = "DESKTOP-xyz\SQLEXPRESS"; //-- Server Name | ||
</pre> | </pre> | ||
== Installation on Synology NAS == | |||
* [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) | |||
* [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.cloud/viewforum.php?f=30 nuBuilder for MSSQL Discussions] | |||
* [https://forums.nubuilder.cloud/viewtopic.php?f=30&t=10884 Forum Topic] - Install instructions discussion | |||
* [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