I have several tables in SQL 2008 R2 dbs that contain the geography datatype.
I already have a table in my Azure db that contains the geography datatype, so I know Azure supports geography.
I created that table from TSQL script.
When I try to migrate my geography table using SQLAzureMW.exe v3.4.1, I get the error "Either the object or one of its properties is not supported on the target server version".
When I try to generate the scripts using SMS with the "Script for database engine type" set to for "SQL Azure Database", I get the same error. When I change the setting to "Stand-alone instance", the script
generates just fine.
Is BCP the problem here? Does it not know that SQL Azure supports geography?