Identify your version

To identify the version of the Amazon Microsoft SQL Server RDS integration you're using:

  1. Sign into your Stitch account.
  2. On the Stitch Dashboard, click the Amazon Microsoft SQL Server RDS integration you want to check.
  3. Click the Extraction Logs tab:
    • If you see a list of extraction logs, the integration's version is v1.
    • If you see No logs available for this integration yet., the integration's version is v06-01-2016.

Amazon Microsoft SQL Server RDS version history

All versions for Stitch's Amazon Microsoft SQL Server RDS integration, including release and deprecation dates.

Version Release date Deprecation date End of life (Sunset)
version 1 (latest) July 12, 2019
version 06-01-2016 January 6, 2016 November 21, 2019 February 15, 2020

Amazon Microsoft SQL Server RDS version features

In this section:

Amazon Microsoft SQL Server RDS version comparison

Amazon Microsoft SQL Server RDS
version 1
(latest)
Amazon Microsoft SQL Server RDS
version 06-01-2016
STITCH
Release status

Released on July 12, 2019

Deprecated on November 21, 2019

Supported by

Stitch

Stitch

Stitch plan

Free

Free

Supported versions

2012 through 2017

2000 through 2016

API availability

Available

Not available

Singer GitHub repository

singer-io/tap-mssql

Not applicable

CONNECTION METHODS
SSH connections

Supported

Supported

SSL connections

Supported

Supported

REPLICATION SETTINGS
Anchor Scheduling

Supported

Unsupported

Advanced Scheduling

Supported

Unsupported

Table-level reset

Supported

Supported

Configurable Replication Methods

Supported

Supported

REPLICATION METHODS
Log-based Replication

Supported

Unsupported

Key-based Replication

Supported

Supported

Full Table Replication

Supported

Supported

DATA SELECTION
Table selection

Supported

Supported

Column selection

Supported

Supported

View replication

Supported

Supported

TRANSPARENCY
Extraction Logs

Supported

Unsupported

Loading Reports

Supported

Supported

Data types

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:

  • indicates that the data type is supported. Following the icon is the Stitch data type it will map to.
  • indicates that the data type is supported, but there is additional information you should know. Hover over the icon to view a tooltip with the information.
  • indicates that the data type isn't applicable to the integration. This is usually because the integration doesn't use that particular data type.
  • indicates that the data type isn't supported. In Stitch, columns with unsupported data types will have Unavailable in the Type column of the Tables to Replicate tab.

Refer to the Data typing guide for more info about how Stitch identifies and types data when it's loaded into your destination.

Amazon Microsoft SQL Server RDS
version 1
(latest)
BIGINT INTEGER
BINARY STRING
BIT BOOLEAN
CHAR STRING
DATE STRING , formatted as DATE-TIME
DATETIME2 STRING , formatted as DATE-TIME
DATETIMEOFFSET STRING , formatted as DATE-TIME
DECIMAL NUMBER
DOUBLE NUMBER
FLOAT NUMBER
INTEGER INTEGER
LONGNVARCHAR STRING
LONGVARCHAR STRING
MONEY INTEGER
NCHAR STRING
NUMERIC NUMBER
NVARCHAR STRING
REAL NUMBER
ROWVERSION STRING
SMALLDATETIME STRING , formatted as DATE-TIME
SMALLINT INTEGER
SMALLMONEY INTEGER
TIME STRING , formatted as DATE-TIME
TIMESTAMP STRING
TINYINT INTEGER
UNIQUEIDENTIFIER STRING
VARBINARY STRING
VARCHAR STRING

Questions? Feedback?

Did this article help? If you have questions or feedback, feel free to submit a pull request with your suggestions, open an issue on GitHub, or reach out to us.