As Cloud computing is getting more and more popular today, many companies are choosing to deploy a hybrid environment using a mix of on-premises data center and public cloud. It gives the businesses greater flexibility and more data deployment options. For example, a company can host business critical or sensitive data in on-premises data centers and deploy less-critical data or test and development environment in the public cloud. A hybrid cloud environment will also help large companies to migrate on-premises data center to cloud in multiple stages without interfering with the business.
Moving data around efficiently in a hybrid cloud environment is critical and challenging. The Azure blog linked below introduces options in different data movement scenarios built on top of on-premises SQL Server, Azure SQL VMs and Azure SQL Databases.