SQL Server to AWS RDS SQL Server

Automated the replication process to ensure data is consistently refreshed in the cloud warehouse. Designed and delivered a central data‑warehouse solution for a global retailer, replicating transactional data into a consolidated AWS RDS SQL Server instance to enable enterprise‑wide group reporting.

What we did

• Developed a central data warehouse solution for a global retailer.
• Connected to the on-premise SQL Server transactional database and replicated data to a central AWS RDS SQL Server instance.
• Automated the replication process to ensure data is regularly updated in the cloud warehouse.
• Central reporting and insights capability.

Tech

← Back to all work