The Devil’s In the Details:
Moving SQL Server Data in and out of the Cloud
Have you taken the plunge to host SQL Server in the cloud yet? Every database administrator or architect who is hosting databases or database-driven applications in the cloud needs to move data in and out of the cloud from time to time, across network boundaries and back to local servers. Whether it is for maintenance, reporting or other business needs, it must be as efficient and transparent as possible.
Therein lies the challenge: how can you securely traverse boundaries, ensure data delivery, deal with congestion or latency issues that affect performance, and still meet maintenance windows? These are the “devils’ in the details” of cloud-based SQL Server hosting and application hosting. There are performance, security and cost considerations of moving data in and out of the cloud effectively to keep business running smoothly.
This post provides a view into the options available and makes the case for using NitroAccelerator, a breakthrough compression solution, to address these challenges and make cloud computing easier to manage and support.
First, it is important to consider how up-to-date the data must be in the local instance in order to pick the correct method for moving your data. Can the data be a day or hours old, or does it need to be a real-time copy? The table below shows some of the native methods available and how they are typically used.
Table 1: Common data movement methods
As you can see from the table, there is no native mechanism that performs well over lower bandwidth connections. However, using NitroAccelerator on the end-points, in a proper configuration, can enable real-time replication to remote instances of SQL Server. If the data doesn’t need to be available in real-time and is simply backed up on a regular schedule, NitroAccelerator can be used to shrink the time window used for moving the data.
How are you tackling this challenge? Consider this enlightened approach and check out a free trial of NitroAccelerator!
Dramatically accelerate and secure your end-to-end SQL Server network traffic for:
- SQL Server Tabular Data Stream (TDS)
- Windows SMB File Transfer
- Database Mirroring
- SQL Server Analysis Services (SSAS)