lundi 26 janvier 2015

MSSQL Import/Export: cannot copy geo columns


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