Documentation

- Overview
- FAQ
- Use Cases
- Case Studies
- Business Continuity
- Geo-Replication (Active)
- RDS Read-Replicas (MS SQL Server)
- Cloud DR (RDS/EC2 SQL Server)
- RDS-to-Redshift Replication
- RDS-to-Hadoop Replication
- Geo-Sharding (Active)
- Prerequisites
- Limitations
- RDS/SQL Server User Management
- Supported MS SQL Server Versions
- VPN/VPC - Replication over VPN/VPC
- Get Started - Configure Multi-AZ or Multi-AR with Readable Replicas
- Attach IAM Role to EC2 and Redshift Cluster
- RDS/SQL Server Backup and restore from/to S3
- Encryption:
- Configure Multi-AZ High-Availability Cluster
- Monitor a Continuous Copy Relationship
- Logs and Errors
- Warnings
- Promote RDS/SQL Server Read-Replica to Primary
- Terminate a Continuous Copy Relationship
- Compare Instance Types (Features & Support Details)
- How To Upgrade
- How To Extend the Default Data Storage
- How to create exportable RDS DB snapshots
- External Resources
API Documentation:
- Default API Configuration
- Instance Management:
- User Management:
- Replication Management:
- CreateReplication
- CreateAllReplication
- ReplicationStatus
- AlterReplication
- DeleteReplication
- StartReplicationService
- StopReplicationService
- AnalyzeReplication
- CreateRedshiftReplication
- AlterRedshiftReplication
- DeleteRedshiftReplication
- CreateS3Replication
- AlterS3Replication
- DeleteS3Replication
- GetLogs
- Multi-AZ HA Cluster Management:
- Lambda/node.js Example:
- Disaster Recovery & No-Downtime Migration Management
SQL Server to Redshift SCD Types 1-2 data feed
This option utilizes a Staging Data Store. It is a SQL Server DB where data is cached before it is pushed to the S3 flat file staging data store from where it is loaded into Redshift. It is not a complete read-replica of the source database. Only tables selected for Redshift replication are pulled into the Staging Data Store. Data changes are continuously being synchronized to the Staging Data Store. From there it is asynchronously exported and uploaded to the S3 Flat File Staging store. This mechanism allows for minimizing the workload on the primary database.
If you choose the option [SQL Server] to [Redshift] SCD Types 1-2 data feed, you will arrive at the following screen:
Populate the required fields for the Master / Source Database and the Staging Data Source, and proceed to the next screen.