I'm trying to copy data from a SQL Server 2014 Express database to a SQL Server 2008R2 Express database.
Compatibility level for the 2008R2 Express database is set to 100.
As soon as I hit Next in the Select Source Tables and Views window, I get the following error:
[dbo].[Client] -> [dbo].[Client]: The data type could not be assigned to the column "Address_Coords" in "SQL Server Native Client 11.0"
The column is a geometry column.
How can I copy data from one database to another when the database contains geo columns?