There is an unsaved comment in progress. You will lose your changes if you continue. Are you sure you want to reopen the work item?
Can't migrate tables containing geography or geometry spatial columns
When scripting data from a SQL Server 2008 R2 (SP1) table that contains a column of geography or geometry datatype under SQLAzureMW 3.7.7, the results summary produces a warning:
"Either the object or one of its properties is not supported on the target server version."
The rows are seemingly copied to BCP ok, but attempting to upload the data to the target Azure database produces
SQLState = S0002, NativeError = 208
Error = [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'AA.dbo.SpatialTable'.