Tabular Data Stream

Apr 22, 2026 - 13:15
0 0
Tabular Data Stream

Add protocol versions, and remove incorrect link for Oracle SQL*Net.

← Previous revision Revision as of 07:44, 22 April 2026
Line 27: Line 27:


The [[FreeTDS]] team has developed a free native-library implementation of the TDS protocol,{{cite book | title = SQL server security |author1= Chip Andrews |author2= David Litchfield |author3= Bill Grindlay | page = 260 | publisher = [[McGraw-Hill Professional]] | year = 2003 | isbn = 0-07-222515-7 }} licensed under the [[GNU Lesser General Public License|LGPL]] license. [[Wireshark]] has a protocol decoder for TDS.[http://wiki.wireshark.org/Protocols/tds protocol/tds], Wireshark.org wiki
The [[FreeTDS]] team has developed a free native-library implementation of the TDS protocol,{{cite book | title = SQL server security |author1= Chip Andrews |author2= David Litchfield |author3= Bill Grindlay | page = 260 | publisher = [[McGraw-Hill Professional]] | year = 2003 | isbn = 0-07-222515-7 }} licensed under the [[GNU Lesser General Public License|LGPL]] license. [[Wireshark]] has a protocol decoder for TDS.[http://wiki.wireshark.org/Protocols/tds protocol/tds], Wireshark.org wiki

== Protocol versions ==
Microsoft SQL Server has used several revisions of the Tabular Data Stream (TDS) protocol. Microsoft's MS-TDS specification maps TDS 7.1 to SQL Server 2000, TDS 7.2 to SQL Server 2005, TDS 7.3.A to SQL Server 2008, TDS 7.3.B to SQL Server 2008 R2, TDS 7.4 to SQL Server 2012 and later, and TDS 8.0 to SQL Server 2022 and later.{{cite web |title=[MS-TDS]: Appendix A: Product Behavior |url=https://learn.microsoft.com/en-us/openspecs/windows_protocols/ms-tds/135d0ebe-5c4c-4a94-99bf-1811eccb9f4a |website=Microsoft Learn |access-date=2026-04-22}}

{| class="wikitable"
! TDS version
! Associated Microsoft SQL Server release(s)
! Notable additions
|-
| 7.1
| SQL Server 2000
| Support for ''bigint'' (64-bit integer) and ''sql_variant''.{{cite web |title=FreeTDS User Guide: Versions of the TDS protocol |url=https://github.com/FreeTDS/freetds/blob/master/doc/userguide.xml |website=GitHub |access-date=2026-04-22}}
|-
| 7.2
| SQL Server 2005
| Support for long text types such as ''varchar(max)'', ''varbinary(max)'' and ''nvarchar(max)''; this generation also introduced XML support and Multiple Active Result Sets (MARS).{{cite web |title=[MS-TDS]: Partially Length-Prefixed Data Types |url=https://learn.microsoft.com/en-us/openspecs/windows_protocols/ms-tds/7d26a257-083e-409b-81ba-897e0c672be0 |website=Microsoft Learn |access-date=2026-04-22}}
|-
| 7.3A
| SQL Server 2008
| Support for extended date and time types such as ''date'', ''time'', ''datetime2'' and ''datetimeoffset''.{{cite web |title=[MS-TDS]: Variable-Length Data Types |url=https://learn.microsoft.com/en-us/openspecs/windows_protocols/ms-tds/ce3183a6-9d89-47e8-a02f-de5a1a1303de |website=Microsoft Learn |access-date=2026-04-22}}
|-
| 7.3B
| SQL Server 2008 R2
| Revision of the 7.3 protocol used by SQL Server 2008 R2.{{cite web |title=[MS-TDS]: Appendix A: Product Behavior |url=https://learn.microsoft.com/en-us/openspecs/windows_protocols/ms-tds/135d0ebe-5c4c-4a94-99bf-1811eccb9f4a |website=Microsoft Learn |access-date=2026-04-22}}
|-
| 7.4
| SQL Server 2012, 2014, 2016, 2017, 2019, 2022 and 2025
| Support for session recovery and feature-extension acknowledgements.{{cite web |title=[MS-TDS]: FEATUREEXTACK |url=https://learn.microsoft.com/en-us/openspecs/windows_protocols/ms-tds/2eb82f8e-11f0-46dc-b42d-27302fa4701a |website=Microsoft Learn |access-date=2026-04-22}}
|-
| 8.0
| SQL Server 2022 and 2025
| Mandatory encryption on *all* messages.{{cite web |title=TDS 8.0 - SQL Server |url=https://learn.microsoft.com/en-us/sql/relational-databases/security/networking/tds-8 |website=Microsoft Learn |access-date=2026-04-22}}
|}

TDS 4.2, associated with older Sybase and Microsoft products, and TDS 5.0, used by Sybase, are distinct from the later Microsoft-specific TDS 7.x and 8.0 lines.

==Similar Protocols==


[[Oracle Corporation]] provides [[Oracle Net]] - software analogous to TDS.
[[Oracle Corporation]] provides [[Oracle Net]] - software analogous to TDS.
{{cite web
{{cite web
|url= http://www.microsoft.com/rus/download.aspx?file=/SQL2008/white_papers/OracleSSIS.docx
|url= https://www.oracle.com/database/technologies/appdev/oracle-net-services.html
|title= SQL Server Integration Services with Oracle Database 10g
|title= Oracle Net Services
⚫
|publisher= Oracle
|date= May 2008
⚫
|access-date= 2026-04-22
|series= SQL Server Technical Article
⚫
|publisher= Microsoft
|page= 2
⚫
|access-date= 2017-07-20
|quote= Oracle Net is analogous to the SQL Server Tabular Data Stream (TDS) transport facility.
}}
}}
Read More