Andy Brownsword goes old-school:
Connecting different versions of SQL Server can allow us to combine or transfer data between environments. This can become a challenge when the versions are really different.
Have you tried to connect SQL Server 2008 to a SQL database in Azure? – it can throw up a few curve balls.
In this post we’ll look at how to solve 3 of the issues you might come up against.
When reading the title, my first response was, “But why not use PolyBase?” Then Andy threw the SQL Server 2008 bit at me, and then my response was, “But why not use a product that isn’t nearly old enough to vote?”
Nonetheless, Andy does a great job of demonstrating how this would work, and it can work for later versions of SQL Server as well.