Introduction

pymssql is the Python language extension module that provides access to Microsoft SQL Servers from Python scripts. It is compliant with Python DB-API 2.0 Specification and works on most popular operating systems.

The pymssql package consists of two modules:

• pymssql -- use it if you care about DB-API compliance, or if you are accustomed to DB-API syntax,
• _mssql -- use it if you care about performance and ease of use (_mssql module is easier to use than pymssql).

Project Discussion

Discussions and support take place on pymssql mailing list here: http://groups.google.com/group/pymssql, you can participate via web, e-mail or read-only subscribing to the mailing list feeds.

Project Status

Stable release: 1.0.2 is technically "stable" version. However, its pretty old, there are known bugs (see issues list and google group) and the current maintainers do not plan to do any bug fixes for this release.

Dev release: HG tip built against FreeTDS 0.91 is the best place to start. Its pretty stable and can run most of the SQLAlchemy test suite without problems. See the issues list for known issues.

Development on this project is currently pretty slow as none of the maintainers have much time to spend on it. If you have interest in helping, please post to the google group.

Things you might be interested in:

• Downloads page
• Documentation -- now also in Korean
• Release Notes
• pymssql mailing list
• Various project feeds
• List of open issues
• FreeTDS User Guide