Migrate geography datatype to Azure

Dec 11, 2010 at 7:00 AM

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?

Thanks,

Joe

Coordinator
Dec 12, 2010 at 12:21 AM

Hi,

I am using geography datatypes as well and I am not having any issues with SQLAzureMW.  How about contacting me via codeplex and we can exchange emails.  If you can send me the TSQL of the table that you are having a problem with, then I can put it in my test database and see what is going on.

Thanks,
George