Get started with a free trial today
Already have an account? Sign in
All versions for Stitch's Amazon Microsoft SQL Server RDS integration, including release and deprecation dates.
| Version | Status | Release | Deprecation | End of life (Sunset) |
| version 1 (latest) | Released | July 12, 2019 | ||
| version 06-01-2016 | Sunset | January 6, 2016 | November 21, 2019 | February 15, 2020 |
In this section:
| Amazon Microsoft SQL Server RDS version 1 (latest) | |||
| STITCH | |||
| Release status | Released on July 12, 2019 | ||
| Supported by | |||
| Stitch plan | Standard | ||
| Supported versions | 2012 through 2017 | ||
| API availability | Available | ||
| Singer GitHub repository | |||
| CONNECTION METHODS | |||
| SSH connections | Supported | ||
| SSL connections | Supported | ||
| REPLICATION SETTINGS | |||
| Anchor Scheduling | Supported | ||
| Advanced Scheduling | Supported | ||
| Table-level reset | Supported | ||
| Configurable Replication Methods | Supported | ||
| REPLICATION METHODS | |||
| Log-based Replication | Supported | ||
| Key-based Replication | Supported | ||
| Full Table Replication | Supported | ||
| DATA SELECTION | |||
| Table selection | Supported | ||
| Column selection | Supported | ||
| View replication | Supported | ||
| Select all | Supported, with prerequisites | ||
| TRANSPARENCY | |||
| Extraction Logs | Supported | ||
| Loading Reports | Supported | ||
In the table below are the data types Amazon Microsoft SQL Server RDS integrations support and the Stitch data type it will map to, depending on the version of the integration being used:
Refer to theData typing guide for more info about how Stitch identifies and types data when it's loaded into your destination.
Note: This table doesn't display info for versions that have been sunset.
| Amazon Microsoft SQL Server RDS version 1 (latest) | |
| INTEGER | INTEGER |
| BINARY | STRING |
| BOOLEAN | BOOLEAN |
| STRING | STRING |
| STRING | STRING , formatted as DATE-TIME |
| DATETIME2 | STRING , formatted as DATE-TIME |
| DATETIMEOFFSET | STRING , formatted as DATE-TIME |
| NUMBER | NUMBER |
| DOUBLE | NUMBER |
| NUMBER | NUMBER |
| INTEGER | INTEGER |
| LONGNVARCHAR | STRING |
| LONGVARCHAR | STRING |
| INTEGER | INTEGER |
| STRING | STRING |
| NUMBER | NUMBER |
| STRING | STRING |
| NUMBER | NUMBER |
| STRING | STRING |
| SMALLDATETIME | STRING , formatted as DATE-TIME |
| INTEGER | INTEGER |
| INTEGER | INTEGER |
| STRING | STRING , formatted as DATE-TIME |
| TIMESTAMP | STRING |
| INTEGER | INTEGER |
| UNIQUEIDENTIFIER | STRING |
| VARBINARY | STRING |
| STRING | STRING |
| Related | Troubleshooting |
Did this article help? If you have questions or feedback, feel free tosubmit a pull request with your suggestions,open an issue on GitHub, orreach out to us.