CLOUDBASIX SQLReplica for RDS SQL Server
Read Replicas (cross-Region and in-Region) in Amazon RDS for SQL Server Standard, Enterprise and Web editions. Support of RDS-to-EC2 SQL Server Standard and Web Read Replicas, and EC2-to-EC2 SQL Server Standard and Web Read Replicas. In-Region read replicas give you the ability to offload RDS/EC2 SQL Server read workloads from your primary database instance to one or more read replicas to achieve high availability (HA). Cross-Region geo read replicas allow deployment of disaster recovery (DR) SQL Server instances, and cross-AWS-accounts replication to achieve ransomware protection for your RDS SQL Server and EC2 SQL Server Standard, Enterprise and Web edition databases.
CLOUDBASIX InterCloud for AzureSQL-AmazonRDS DR
Cross-Region read replicas from any version or edition of SQL Server in Azure into any version or edition of SQL Server in AWS, in most cases without the need to select advanced options or any custom scripting. In complex migration and disaster recovery deployment cases, advanced configuration options and scripting capabilities are available in the advanced section of the CLOUDBASIX console.
CLOUDBASIX automatically handles any necessary schema conversions, accounts for SQL Server version and edition incompatibilities, and creates SQL Server read replicas in Amazon RDS for SQL Server or Amazon EC2 in a fully automated manner.
Seamless aggregation of various SQL Server versions and editions into Amazon S3 Datalakes. Supported flat file formats are Parquet (allowing faster querying of S3 Data Lakes from products such as Amazon Athena) and CSV. Data lakes can be partitioned in different structures depending on what format is suitable for your reporting/querying product (i.e. Amazon Glue, SAS etc)
CLOUDBASIX SQLReplica for Redshift
Offload RDS SQL Server with Read Replicas in Amazon Redshift.
Databases from different versions and editions of SQL Server on EC2 and RDS are seamlessly aggregated into a single Redshift DW. Creating of exact replicas (SCD Type 1) and laying out of historical data (SCD Type 2) are supported.
See EC2/RDS SQL Server data flow into Redshift!
Best Practices for SQL Server on AWS!
~ Tom Staab, AWS Solution Architect, showcases CloudBasic's RDS SQL Server Multi-AR technology: View presentation >>
Frequently Asked Questions
Yes, cross-Region and in-Region read replicas for both RDS SQL Server and EC2 SQL Server read replicas are supported for all SQL Server editions, including SQL Server Standard and Web. In addition, RDS SQL Server Enterprise cross-Region read replicas are now supported by CLOUDBASIX for RDS SQL Server Read Replicas and Disaster Recovery (DR) on the AWS Marketplace.
Note: Cross-Region read replicas are not supported by the native RDS SQL Server Enterprise read replicas solution.
Unlike Amazon RDS Multi-AZ for SQL Server which creates non-readable replicas, CLOUDBASIX for Amazon RDS SQL Server Read Replicas and Disaster Recovery (DR) creates read replicas which can be used for reporting. Also CLOUDBASIX unlocks cross-Region read replicas for RDS SQL Server Standard, Enterprise and Web editions (for comparison of RDS SQL Server Enterprise read replicas and CLOUDBASIX RDS SQL Server read replicas go to next question).
CLOUDBASIX is available on the AWS Marketplace.
The native Amazon RDS SQL Server read replicas are in-Region only and are supported for the Enterprise edition only with RDS Multi-AZ enabled.
CLOUDBASIX for Amazon RDS SQL Server Read Replicas and Disaster Recovery (DR) supports both cross-Region and in-Region read replicas for SQL Server Enterprise, Standard and Web. RDS Multi-AZ is not required, but CLOUDBASIX RDS is compatible with RDS Multi-AZ for SQL Server. For more information see detailed comparison table In addition, CLOUDBASIX allows creation of substantially lower cost EC2/RDS SQL Server Standard read replicas from RDS SQL Server Enterprise primary source, and EC2/RDS SQL Server Web read replicas from RDS SQL Server Standard.
Yes, multiple read replicas (cross-Region and in-Region) for RDS SQL Server Standard, Enterprise and Web and EC2 SQL Server all editions are supported.
CLOUDBASIX is available on the AWS Marketplace.
CLOUDBASIC for Amazon RDS SQL Server Read Replicas and Disaster Recovery (DR) allows creation of substantially lower cost EC2/RDS SQL Server Standard read replicas from RDS SQL Server Enterprise primary source, and EC2/RDS SQL Server Web read replicas from RDS SQL Server Standard.
CLOUDBASIX is available on the AWS Marketplace.
Yes, CLOUDBASIX for Amazon RDS SQL Server Read Replicas and Disaster Recovery (DR) allows 2 x CLOUDBASIX instances deployed in different availability zones (Multi-AZ) or multi-availability-regions (Multi-AR) to be clustered to achieve high availability replication processing. The replication workload is load balanced by default. If one server goes down the other one picks up the replication workload. Lower latency can be achieved by assigning affinity to the server replicating with lower lag, in which case the HA cluster configuration becomes master-slave (configurable per database).
CLOUDBASIX is available on the AWS Marketplace.
Yes, all SQL Server versions, including Managed Azure SQL Server Instances and Azure SQL Databases are supported.
In addition to the migration use case, CLOUDBASIX can also be used for deploying and testing cross-region RDS SQL Server disaster recovery in AWS environment (prior to migration cut-over).
For more details, visit https://aws.amazon.com/blogs/database/migrating-sql-server-databases-from-microsoft-azure-to-aws-in-near-real-time-with-cloudbasic/
CLOUDBASIX is available on the AWS Marketplace.
Customer Testimonials
Very flexible, thorough, comes with great support
We use Cloudbasic to continually replicate the various databases to a database where we centralize and consolidate data and generate updated reports in real time. The tool is fast, reliable and with a very intuitive interface, which makes it easy for all staff to use.
Whenever we need support, during installation, questions or problems, they have always responded very quickly and are always willing to resolve the issue in a very kind manner. Read full review >>
We have used Cloudbasic to so far migrate over 100 databases from our virtualized SQL environment into AWS RDS SQL (and even some Azure SQL Database) with no downtime for the database users. Our databases are continually online and continually having DDL and DML changes made against them, so it was important to have a solution that would capture all of these changes and ensure that the migration target stayed up to date until the time of our cutover, and based on our research Cloud Basic was the one tool that was capable of achieving that seamlessly. Read full review >>
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 >>
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 >>
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 >>
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 >>
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 >>
I’m really happy I found your product as there are not many options for this sort of thing with RDS and SQL Server.
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.
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.
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.
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
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 >>
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 >>
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 >>
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 >>
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 >>
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 >>