Post reply

Export table with Geography data type

  • May 30, 2013 at 10:17 am

    #294651

    Hi all

    as the title suggests I need to export the data from one table to another database in a completely different domain, but I ma having problems as its of a Geography data type. Using the export wizard its complaining about data type conversions, does anyone know of a better way of doing this?

    Thanks

  • May 30, 2013 at 2:14 pm

    #1619902

    Hi

    You could try transferring the data over as a varbinary(max). You would need to specify a query where you cast the Geography column as a varbinary(max) rather than selecting the table. Once the table is exported you can then cast it back to a Geography on the target.

    Hope this helps

  • May 31, 2013 at 5:37 am

    #1620019

    Thanks - in the end I used the Generate scripts option of SQL

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply