In this podcast, the consultants discuss the topic of migrating SQL Server to the cloud. They highlight the benefits of cloud migration, such as cost savings and technological advancements, and note that cloud skills are becoming essential in the job market.
Despite the prevalence of cloud migration, many organizations still use on-prem SQL, including older versions that are becoming unsupported. The consultants emphasize the need for planning, especially with SQL 2019 soon falling out of mainstream support.
They outline various migration options:
- Moving the entire database.
- Moving subsets of data using tools like Azure Data Factory.
They also mention tools to assist in migration, such as Azure Migrate, Azure Data Studio, Backpack files, Bulk Copy, and Data Factory. While transactional replication offers minimal downtime, it is complex and requires skilled DBAs.
The discussion touches on scenarios where organizations might choose not to migrate to the cloud, such as having managed data centers, legacy applications, high-security needs, or limited connectivity.
The consensus is that cloud migration is inevitable for most organizations over the next decade, except for specific edge cases. Hybrid models are effective, particularly as transitional steps, but will likely shift fully to the cloud over time.
The podcast concludes with a note on the importance of assessment tools for migration and a preview of the next episode on "What is a Lake House?". The consultants offer their assistance with migration projects and ongoing maintenance of SQL servers.
You can download Power BI Desktop from here.
If you already use Power BI, or are considering it, we strongly recommend you join your local Power BI user group here.
To find out more about our services and the help we can offer, contact us at one of the websites below:
UK and Europe: https://www.clearlycloudy.co.uk/
North America: https://clearlysolutions.net/
You Might Like
