AWS-to-Azure Replication

Case Study - AWS to Azure Intercloud Replication

AWS RDS-SQL-Server-to-Azure SQL Database InterCloud replication brings SaaS VMS provider the best of both worlds - deploy core systems on AWS and leverage Power BI analytics on Azure, while also achieving InterCloud DR

SimpleVMS.com utilizes CloudBasic’s low-latency intercloud SQL server replication to solve the “AWS or Azure” dilemma and definitively preclude cloud provider lock-in for the benefit of its ever growing user base.

EXECUTIVE SUMMARY: SimpleVMS.com provides a feature-rich cloud-based Vendor Management System (VMS) that streamlines the contingent workforce acquisition process of a broad range of customers. The company utilizes RDS SQL Server on AWS for its core systems and has chosen Microsoft's Power BI suite of analytics tools to power the BI reporting of its service platform. Rather than switching from AWS to Azure for its suite of analytics tools, SimpleVMS was able to utilize the benefits of both by using CloudBasic's low-latency InterCloud replication engine. The company has deployed its core productions systems on AWS cloud and not only can leverage Microsoft’s Power BI reporting tools on Azure, but also achieve the additional benefit of InterCloud DR.


The Business Environment

In a dynamic business environment, where the only constant is change, modern enterprises are facing an increasing number of challenges, for which their long-term full-time employees may not be qualified or prepared to handle. As a result many organizations today, from small businesses and local schools all the way to NASA and the NSA, depend on short-term project-based contract labor for an ever increasing number of functions. Freelancers and independent contractors bring much needed flexibility, expertise, and overall efficiency into the labor pool. But as the gig economy is now in full swing, the intricate management of this contingent workforce brings a new level of complexity for management - from job postings and interviews, to employee integration, performance management, and payments. The sheer volume of communication with multiple staffing vendors and prospect hires alone can overwhelm any HR department.

The Client

Enter SimpleVMS.com - a cloud-based Vendor Management System that simplifies every step of the recruiting, retention, and vendor payment process. The founders of SimpeVMS, based in Cincinnati, Ohio, understood that with the current economic trends procuring contract employees would turn into a management burden of massive scale. The company set out to streamline the entire process and the result was a simple web-based solution with a vendor-paid model, allowing companies to consolidate their entire contingent vendor pool, manage HR policy compliance, and hire outstanding people in a very short time frame, while reducing the overall cost. The feature rich solution made management of the Contract Labor Workflow a breeze – from the job posting and applicant screening, to the successful completion of the contract term. In addition, and as expected from any modern Software-as-a-Service solution, a customizable reporting and analytics module provides full process visibility across financial, compliance and vendor performance measures. To learn more visit https://simplevms.com/

The Case

With such a comprehensive solution to a serious management challenge, and an attractive vendor-paid model, it was only logical that SimpleVMS would grow in popularity. A first-class cloud infrastructure is paramount for the reliability and scalability of the service, and it was only natural that the company chose the ubiquitous Amazon Web Services as its cloud infrastructure provider for its core systems and Amazon RDS SQL Server as the primary database.

One particular issue, however, posed a challenging technology and business dilemma. A very important advantage for customers, and something traditional staffing vendors are unable to provide, is the set of reporting and vendor metrics tools at the end of the contract labor workflow. To enable the powerful customized analytics that measure HR spend and vendor performance, as well as other business intelligence aspects, the company wanted to utilize Power BI – Microsoft’s suite of business analytics tools to analyze data and share insights. Power BI, which provides a 360-degree view of consolidated important metrics in real time, is a perfect fit for SimpleVMS, however Power BI is a service of Microsoft Azure,  and Power BI sources data from databases hosted on Azure. For SimpleVMS switching cloud providers was not an option. The company had to stay on AWS and find a way to bring RDS SQL Server data in near real-time to Azure.

The Solution

BENCHMARK REPORT:

AWS-RDS to Azure-SQL Intercloud Replication
View the performance statistics of AWS-to-Azure Geo-Replication Scenario

As enterprises are steadily increasing their cloud-based service deployments, cloud providers are in fierce competition. They invest massive resources to expand their infrastructure and include value add-ons to lure businesses, and it’s only logical for customers to consider the possibility of cloud provider lock-in and the related potential consequences on business operations.

Fortunately, there is a way to get the benefits from multi-cloud environment and avoid provider lock-in. CloudBasic’s AWS RDS SQL Server to Azure SQL Database continuous replication, delivering latency of less than 3 seconds for SimpleVMS' replication scenario, enabled the company to continue using AWS for its primary systems, while at the same time deploy Power BI on Azure for reporting and analytics.

The Results

CloudBasic’s Intercloud Replication solution brings multiple benefits. For starters, SimpleVMS doesn’t have to switch cloud providers in order to utilize Azure Power BI. The low latency SQL Server replication brings the substantial additional benefit of an InterCloud Disaster Recovery solution. Should any event impede the performance of the host AWS region or availability zone, SimpleVMS can quickly fail-over to Microsoft Azure and maintain the uninterrupted integrity of its business services.

Leverage the cloud at its best with CloudBasic RDS Always-On/Geo-Replicate for SQL Server HA/DR! For more information about CloudBasic and its cloud technology products and services, please contact CloudBasic.

RDS Always-On/Geo-Replicate (Multi-AR) for SQL Server HA/DR

RDS SQL Server Multi-AZ and Multi-AR (Cross-Region) Readable-Replicas for HA/DR, reporting, off-loading of primaries. On-Premise to AWS replication for Cloud HA/DR.

View product details

You'll be in good company:

Amazing Product for RDS SQL Server replication

 

Cloudbasic RDS Always-On/Geo-Replicate for SQL Server provided us with just what we were looking for. It saved us a lot of time during our migration process by taking care of the database schema replication and keeping large amounts of data in sync. Also, the support has been amazing in terms of being available in-spite of the time zone differences. Read full review >>

Bernadette Hensley

Great product, fantastic support team!

We’re a small, growing company so our AWS budget is tight and the CloudBasic replication product is the perfect solution for our needs. This product has allowed us to implement a reliable, near real-time replication solution without resorting to expensive SQL Server/RDS replication solutions. The CloudBasic product has proven to be fast, reliable, easy to set up, use and manage.

Before our AWS migration we managed our own physical SQL Server installation and used SQL Server log shipping to sync our online and reporting databases with typical latencies of 15-30 minute range. With the CloudBasic solution our latencies are now in the 2-5 second range…  Read full review >>

Damien Hanna, Roomex Limited

CloudBasic is an AWS Rockstar!

The CloudBasic RDS Always-On/Geo-Replicate for SQL Server solution is an absolute lifesaver when working with RDS SQL Server! SQL Server on RDS falls short in a lot of aspects when it comes to replication and disaster recovery, and this solution makes the process seamless. We’re able to migrate very large amounts of data and keep the in sync while we move applications around, as well as create usable read-replicas that RDS simply doesn’t provide. Anytime we’ve run into any snags in the process, CloudBasic support has been right there available to help get things going right away. I’m truly impressed with the product and the company behind it! Read full review >>

Chris Kizziar

five-starsGreat product, simplifies architecture and hassle free

CLOUDBASIC RDS Always-On/Geo-Replicate for SQL Server HA/DR/Redshift/S3 provided us a way to replicate multiple on site MSSQL DBs to other datacenters as well as Amazon RDS\EC2 and also from the cloud into our datacenters. After spending weeks of investigating how we could manage this using SQL’s own replication or writing our own replication jobs we found Cloudbasic. We were up and running within a hour and our DBA team could test replication paths hassle free and have full control over the source and destination DBs. The ability to replicate into SQL Web version saves us $10,000’s every year whilst maintaining the ability to have read\write replicas. The Cloudbasic support has been fantastic, helping us with any questions we have and also releasing new features to meet specific needs, we couldn’t ask for more from a product support group. I would highly recommend you trial this product if you are looking at any form of hybrid MSSQL replication and want the most cost optimised solution that works straight out the box (AMI). Read full review >>

118118

five-starsExcellent product and support!

CloudBasic RDS AlwaysOn/Geo-Replicate for SQL Server HA/DR is an excellent product backed by great support. Using the pre-configured AMI we were up and running in minutes. Used CloudBasic to migrate SQL Server databases into RDS, followed by setting up cross-region Multi-AR RDS SQL replications for Disaster Recovery and Multi-AZ High Availability. It works well with RDS Multi-AZ, creates SQL Server read-replicas which can be used for reporting, data-locality and offloading of primary RDS SQL Servers. With help form the responsive CloudBasic support team we were able to migrate our databases with no down time. Setting up DR and HA was straightforward.

I strongly recommend the product and the CloudBasic advisory support team…  Read full review >>

Dev OPS

five-starsI’m really happy I found your product

I’m really happy I found your product as there are not many options for this sort of thing with RDS and SQL Server.

 

Daniel O’Connor, OpenAgent.com.au

five-starsDoes what it says on the box, easy to use, amazing support.

I found this tool when I was looking for a way to transfer databases between our development systems and our production systems. These comprised of a mix of in house physical SQL, EC2 SQL and and RDS. Cloudbasic Geo-replicate solved this problem.

The product improvements I asked for were implemented within days allowing me to extend our use of this product into our devops continuous delivery model.

Oniqua Cloud

five-starsAffordable SQL Server High Availability Solution

As a consultant I look for affordable and easy to maintain solutions for my customers. This SQL Server HA solution features a simple web interface. I did not have to worry about configuring server clusters, log shipping etc. I was able to setup a DB instance replication to a cross-region AlwaysOn RDS in minutes. I was pleasantly surprised that MSSQL Web Edition is also supported. I had to call for support related to DB issues on my end. I was assigned a dedicated support representative who proved to be very helpful. I did an extensive testing to ensure that this product is very reliable. With this product I am planning to scale up my Cloud Disaster Recovery implementation efforts.

Nick Semer, IT Consultant

five-starsSimple, Powerful, with Stellar Support

 

The software delivers what it promises. Its easy to use. The support is fantastic. We were impressed how fast they reached out to us to want to help. The software is fast, economical and affordable. It doesn’t put any stress on your source and destination databases. It seamlessly does what it does and it does it well. I highly recommend this product to anyone.

Otelz Development Team

five-starsSimple cross-region RDS replication solution

We were looking for a way to continuously replicate our RDS based SQL Servers from west to east coast, for disaster recovery and reporting purposes. We started from looking for a SQL Server log shipping and high availability based solution ..then found CloudBasic’s Geo-Replicate server. We launched the server from the market place, entered RDS source and destination information and within minutes were able to stream data. The secondary DBs seeded very fast, and … Read All

Radmeister, Inc.

five-starsEasy setup. Various deployment scenarios.

We were looking to utilize AWS as a fail-over site for our on-premise SQL Server based applications. We turned to the AWS Market place to find solutions to help us speed up implementation. Found this product, and within minutes were able to steam SQL Server data to an RDS SQL Server on AWS. All we had to do is enter source and destination SQL server connection strings. Then selected if we wanted a one time migration of the SQL server or also… Read full review >>

J.P., Solution Architect

five-starsWorks very well. Easy to use. Some minor issues need to be addressed.

We intended to use this software to do a one time migration of SQL databases from our co-located datacenter to AWS. Then figured it is very easy to setup continuous replication from East to West coast (AWS in California to AWS in Virginia). We currently use EC2 SQL Server Web edition in California, replicating to a small RDS Web Edition in Virginia… Read full review >>

John M.

five-starsSimple and inexpensive solution to replicate SQL Servers from West to East coast

Our customer base spans 100+ hospitals, including Tenet Healthcare, Baptist Health of South Florida and Texas Health Resources. We migrated our systems to AWS a year ago. Then shortly after, as part of our business continuity planning, selected the pre-AWS Marketplace version of CLOUDBASIC REPLICATE to … Read full review >>

Versant Holdings, LLC

five-stars-review-on-AWS-MarketplacePowerful Yet Simple Replication Solution

The most important feature we were looking for was to be able to access the end point of the replica for our reporting. This product replicates between SQL servers manages by us. We have to ensure the destination SQL Server is used in read-only mode, but this gives us the flexibility to setup replication in various scenarios: on-prem to AWS, across AWS regions, zone-to-zone. It does seem that SQL Server Web edition is supported in all scenarios as well… Read full review >>

George K.

five-starsCloudBasic SQL Migrate to RDS Solution

I used CloudBasic to Migrate my SQL2012 to an RDS 2012 instance. Install of CloudBasic was easy and once the connection strings were set on the CloudBasic Server webpage, my database connectivity was verified and the db migrated very fast to the RDS instance. CloudBasic is the easiest and fastest solution to replicate your data to an RDS instance for production and or testing. Thank You for making my job easier!!! Read full review >>

Tampa Bay Times

five-starsCloudBasic works great! Easy to setup and comes with outstanding support.

CloudBasic has a nice web user interface. There’s a quick setup feature to start replicating your databases in minutes after you setup the AMI from Amazon’s Marketplace. If you have any questions, RJ and their support team will go to great lengths to make sure CloudBasic gives you the ROI that you’re looking for in a database replication solution. Awesome product. Read full review >>

AnswerFirst Communications