I have been looking around, and came accross some positive experiences with SQL server and Mantis in the past
We are planning an upgrade from 1.2.19 to 2.14 , and in order to align with standards we are planning to migrate to SQL Server.
Are there recent experiences with this challenge somebody wants to share.
I already struggle with choosing the appropriate $g_db_type : sqlsrv or pdo-sqlsrv
These options throw errors that bring me to this note:
https://www.mantisbt.org/bugs/view.php?id=15437#c40520
SQL Server 2016 and Mantis 2.14
Moderators: Developer, Contributor
Re: SQL Server 2016 and Mantis 2.14
Investing a couple of days, I managed to convert a MantisBT 1.2.19 installation on xampp to the version 2.14 on IIS.
It's up and running in this configuration:
-Windows 10 Server
-Microsoft IIS
-PHP 7.2
-SQL Server 2016 Database
The trick was installing the products: "PHP 7.2.2 (x64)" and the "Microsoft Drivers 5.2 (x64) for PHP v7.2 for SQL Server in IIS"
with Microsoft Platform Installer and...
1. configuring: $g_db_type = 'mssqlnative'
in: c:\inetpub\wwwroot\mantisbt\config\config_inc.php
2. adding the right extension to c:\Program Files\PHP\v7.2\php.ini:
extension=php_ldap.dll
extension=php_fileinfo.dll
so far... so good
I will need to test all functionality (especially some add-ons)
Meanwhile i regret the Agile extension from gadiv is not compatible with MantisBT 2.x
It's up and running in this configuration:
-Windows 10 Server
-Microsoft IIS
-PHP 7.2
-SQL Server 2016 Database
The trick was installing the products: "PHP 7.2.2 (x64)" and the "Microsoft Drivers 5.2 (x64) for PHP v7.2 for SQL Server in IIS"
with Microsoft Platform Installer and...
1. configuring: $g_db_type = 'mssqlnative'
in: c:\inetpub\wwwroot\mantisbt\config\config_inc.php
2. adding the right extension to c:\Program Files\PHP\v7.2\php.ini:
extension=php_ldap.dll
extension=php_fileinfo.dll
so far... so good
I will need to test all functionality (especially some add-ons)
Meanwhile i regret the Agile extension from gadiv is not compatible with MantisBT 2.x
Re: SQL Server 2016 and Mantis 2.14
It's a new world with this stuff.
You're running Mantis over Windows accessing SQL Server over Windows.
At some point I'm sure we'll see questions about the other combinations:
You're running Mantis over Windows accessing SQL Server over Windows.
At some point I'm sure we'll see questions about the other combinations:
- Mantis over Linux accessing SQL Server over Linux
- Mantis over Linux accessing SQL Server over Windows
- Mantis over Windows accessing SQL Server over Linux
If you want Mantis to work differently, use or create a plugin. Visit the Plugins forums.
Ask developers to create a plugin that you need - and motivate them to help you!
Ask developers to create a plugin that you need - and motivate them to help you!
Re: SQL Server 2016 and Mantis 2.14
Hi Lucvd,
Could you please share the database script for MS SQL server or tools used. Thanks in advance.
Could you please share the database script for MS SQL server or tools used. Thanks in advance.