View Issue Details

IDProjectCategoryView StatusLast Update
0017163mantisbtdb mssqlpublic2016-07-11 15:55
ReporterSamCPP Assigned To 
PrioritynormalSeverityminorReproducibilityalways
Status newResolutionsuspended 
PlatformMicrosoftOSWindowsOS VersionAll
Product Version1.2.17 
Summary0017163: Image, text, ntext deprecated from MSSQL
Description

Recommended to change the db schema for MantisBT to not use these datatypes in MSSQL as they are flagged to be removed in future versions.

Recommended to use the varbinary type. e.g. varbinary(max) or varbinary(8000) etc.

See http://technet.microsoft.com/en-us/library/ms187993.aspx.

E.g. [mantis_bug_file_table].[content] field.

TagsNo tags attached.

Activities

grangeway

grangeway

2014-04-06 07:22

reporter   ~0039835

Sam,

Same again - marking as suspended.

Keep an eye on mantisbt-dev list if you would like to help out testing the mssql support.

grangeway

grangeway

2014-05-16 15:00

reporter   ~0040333

MantisBT currently supports Mysql and has support for other database engines.

The support for other databases is known to be problematic.

Having implemented the current database layer into Mantis 10 years ago, I'm currently working on replacing the current layer.

If you are interested in using Mantis with non-mysql databases - for example, Oracle, PGSQL or MSSQL, and would be willing to help out testing the new database layer, please drop me an email at paul@mantisforge.org

In the meantime, I'd advise running Mantis with Mysql Only to avoid issues.

Thanks
Paul

Issue History

Date Modified Username Field Change
2014-04-06 06:53 SamCPP New Issue
2014-04-06 07:22 grangeway Note Added: 0039835
2014-04-06 07:22 grangeway Status new => resolved
2014-04-06 07:22 grangeway Resolution open => suspended
2014-04-06 07:22 grangeway Assigned To => grangeway
2014-04-06 11:00 atrol Status resolved => assigned
2014-04-12 19:33 grangeway Target Version => 1.3.0-beta.1
2014-05-16 15:00 grangeway Note Added: 0040333
2014-05-23 15:09 grangeway Project mantisbt => @24@
2014-11-07 14:40 atrol Assigned To grangeway =>
2014-11-07 14:40 atrol Status assigned => new
2014-11-07 14:40 atrol Project @24@ => mantisbt
2014-12-08 02:10 atrol Target Version 1.3.0-beta.1 => 1.3.0-beta.2
2015-03-15 20:00 dregad Target Version 1.3.0-beta.2 => 1.3.0-beta.3
2015-09-06 17:47 vboctoradmin Target Version 1.3.0-beta.3 => 1.3.0-rc.1
2016-01-12 03:43 atrol Target Version 1.3.0-rc.1 => 1.3.0-rc.2
2016-06-12 02:37 atrol Target Version 1.3.0-rc.2 => 1.3.0
2016-07-10 07:57 atroladmin Target Version 1.3.0 => 1.3.1
2016-07-11 15:55 atrol Target Version 1.3.1 =>