Contact Us
Case study

Gopanza, eCommerce: Migration of SQL Server from Azure to AWS RDS

February 8, 2024
Download Case Study

Gopanza is a leading e-commerce technology provider that digitally transforms brick and mortar grocers by facilitating online franchising.

Challenge

Facing the need for a scalable, secure, and cost-effective database solution, the challenge for Gopanza was to seamlessly migrate infrastructure in order to harness automated management.

Solution

Gopanza’s technology enables customers to create and manage white label online stores (for desktop and mobile devices) including payments, self-checkout, delivery, inventory, loyalty, and shopping pattern analysis, all with real-time reporting.

In support of its offering, Gopanza sought AWS RDS’ (Amazon Relational Database Services) auto-management capabilities to streamline database administration and drive operational efficiencies.

Gopanza needed to move all information from Azure to AWS without negatively impacting customers.

50% cost savings compared with Azure.

Enhanced database capabilities achieved quickly, easily, and with minimum effort, powering:

  • Scalability
  • Reliability
  • Security
  • Integration
  • Rentability

Seamless

RDS allows for easy scaling of database instances to accommodate fluctuations in ecommerce traffic, ensuring seamless performance during peak periods.

High Availability

RDS leverages recurrent backups and multi-AZ instances to enhance the availability and reliability of database infrastructure, thereby minimizing the risk of data loss and downtime.

Encrypted

Data is encrypted in transit and at rest, ensuring strong data protection and database access security via a three-tier architecture.

Fully Managed

As a fully managed service, RDS enables easy database instance creation and configuration, handling software updates, backups, and configurations seamlessly.

Impact

Gopanza partnered with IO Connect to launch migration of their infrastructure to AWS, including computing clusters, databases, and applications. AWS RDS was the best option to migrate Gopanza’s SQL Server database as compared to Azure. The primary challenge with Azure was its non-support for .bak files when exporting databases. Azure instead generates .bacpac files, incompatible with RDS import.

As a fully managed database service, RDS powers the ability to set up, operate, and scale relational databases in the cloud without the need for managing the underlying infrastructure.

After Gopanza’s initial migration, a series of tests were executed. Gopanza was immediately able to see the significant benefits of using AWS RDS, including enhanced database management and reduced maintenance costs.

Gopanza plans to leverage RDS’ full feature set in the future, including multi-AZ, proxies, and integration with other AWS services.

Features

  • Automates routine database tasks such as provisioning, patching, backups, and scaling
  • Ensures high availability through:
  • Recurrent backups
  • Multi-AZ instances
  • Encryption at rest and in transit
  • Integrates with other AWS services

Timeline

  • Migration achieved in three weeks

Related Insights

®2024 IO Connect Services
Privacy PolicyCookie Policy
magnifiercrossmenuchevron-down
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram