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...") |
No edit summary |
||
| 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> | ||
| Line 18: | Line 19: | ||
</pre> | </pre> | ||
Revision as of 12: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
- 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"; //-- mysql (MySQL, MariaDB) or sqlsrv (MSSQL)
$nuConfigDBPort = "1433"; //-- MSSQL Port
$nuConfigDBHost = "DESKTOP-xyz\SQLEXPRESS"; //-- Server Name