Transfer source - RDBMS version compatibility table
- 25 Jul 2024
- Print
- PDF
Transfer source - RDBMS version compatibility table
- Updated on 25 Jul 2024
- Print
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
summary
Correspondence table of driver versions used in the transfer source RDBMS-based connector.
| Transfer source connector | TROCCO Supported Versions | remarks |
|---|---|---|
| Amazon Redshift | PostgreSQL JDBC Driver 9.4-1205-JDBC41 | Uses the same drivers as PostgreSQL |
| Microsoft SQL Server | See Microsoft SQL Server Compatibility below for details. | |
| MySQL | MySQL Connector Java 5.1.49 | (The left column can also work with MySQL 8.0 series. However, the caching_sha2_password authentication feature added to MySQL 8.0 series is not supported |
| Oracle Database | Supported JDBC jar files and Oracle Database versions are as follows
| See FAQ on Oracle JDBC for more information |
| PostgreSQL | - |
supplement
Microsoft SQL Server Compatibility
The supported DB versions are as follows
For more information, see the JDBC Driver for Microsoft SQL Server support table andThe jTDS Project.
| DB version \TROCCO-supported driver | Microsoft SQLServer JDBC Driver 8.2 | jTDS Driver 1.3.1 |
|---|---|---|
| Microsoft SQL Server 2019 | ✓ | - |
| Microsoft SQL Server 2017 | ✓ | - |
| Microsoft SQL Server 2016 | ✓ | - |
| Microsoft SQL Server 2014 | ✓ | - |
| Microsoft SQL Server 2012 | ✓ | ✓ |
| Microsoft SQL Server 2008 | - | ✓ |
| Microsoft SQL Server 2005 | - | ✓ |
| Microsoft SQL Server 2000 | - | ✓ |
| Microsoft SQL Server 7 | - | ✓ |
| Microsoft SQL Server 6.5 | - | ✓ |
Was this article helpful?