Stream Data from SQL Server into Redshift with Kinesis Firehose

Question

The tool below is a batch import method of copying data from SQL Server RDS into Redshift.

AWS Schema Conversion Tool Exports from SQL Server to Amazon Redshift

Is there a more streamlined method, conducting every second way of streaming data from MS SQL Server into Redshift with Kinesis Firehose. I know we can move AWS Aurora SQL directly into Redshift with Kinesis.

Is it a requirement that you use Amazon Kinesis? Or is your goal simply to move data from SQL Server to Amazon Redshift? — John Rotenstein

John Rotenstein John Rotenstein · Accepted Answer · 2018-06-27T04:24:17

If your goal is to move data from Microsoft SQL Server into Amazon Redshift, then you could consider using AWS Database Migration Service. It can copy data as a one-off job but can also migrate on a continuing basis.

See:

Using a Microsoft SQL Server Database as a Source for AWS DMS - AWS Database Migration Service
Using an Amazon Redshift Database as a Target for AWS Database Migration Service - AWS Database Migration Service

Stream Data from SQL Server into Redshift with Kinesis Firehose

1 Answers