使用Kinesis Firehose将数据从SQL Server流式传输到Redshift [英] Stream Data from SQL Server into Redshift with Kinesis Firehose

查看:125
本文介绍了使用Kinesis Firehose将数据从SQL Server流式传输到Redshift的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

下面的工具是将数据从SQL Server RDS复制到Redshift的批处理导入方法.

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

是否有更简化的方法,使用Kinesis Firehose进行从MS SQL Server到Redshift的流式传输数据的第二种方法.我知道我们可以使用Kinesis将AWS Aurora SQL直接移到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.

推荐答案

如果您的目标是将数据从Microsoft SQL Server移至Amazon Redshift,则可以考虑使用

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.

请参阅:

  • 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

这篇关于使用Kinesis Firehose将数据从SQL Server流式传输到Redshift的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆