I'm trying to copy data from an SQL 2014 Express database to a SQL 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?
Aucun commentaire:
Enregistrer un commentaire