Microsoft SQL Server as a backend database

Notice: This plugin is unmaintained and available for adoption.

Description

This plugin allows you to connect Trac to Microsoft SQL Server as a backend database, albeit crudely implemented.

Related tickets:

• ​trac:ticket:329 Adding support for Microsoft SQL Server as a backend database
• #2277 ODBC connection

There is also a fork of this plugin, implemented for Trac 1.1.2 and focused on ticketing: ​https://github.com/Reposoft/trac-mssql, which is released under a Modified BSD license.

Bugs/Feature Requests

Existing bugs and feature requests for MsSqlBackendPlugin are here.

If you have any issues, create a new ticket.

defect	1 / 2

Download

Download the zipped source from here.

Source

You can check out MsSqlBackendPlugin from here using Subversion, or browse the source​ with Trac.

Installation / Configuration

• Download the source, perform setup.py bdist_egg, then place dist/*.egg into your PYTHONPATH.
• Add the following to your trac.ini file:

  [components]
  mssql_backend.* = enabled
  

• Create tracdb database on MS SQL Server.
• Setup tracdb DSN connected to database above with ODBC Administrator.
• Do trac-admin __projectpath__ initenv --inherit=path/to/mssql_enabler.ini new "odbc:/DSN=tracdb;Trusted_Connection=yes" to create project.

Recent Changes

12705 by matobaa on 2013-03-10 14:28:46

fixes mistakes on changeset:12704

12704 by matobaa on 2013-03-10 14:22:25

closes #10920, included license text for
ContextChromePlugin, EpochFieldPlugin, FieldTooltipPlugin, HideFieldChangesPlugin, MsSqlBackendPlugin, NeighborPagePlugin, QueryUiAssistPlugin, ShowWhenMacro, SnapshotPlugin, StatusHistoryChartMacro, and TracLinksPlugin.

12684 by matobaa on 2013-03-05 15:01:19

MsSqlBackendPlugin: support for custom query

(more)

Author/Contributors

Author: matobaa
Maintainer: none (needsadoption)
Contributors: