Importing a table containing spatial coumns

Can anyone think of a way of importing a (very large) table containging spatial columns??

Cheers

Martin

 

Source is a local SQLExpress 2008 database. Table has 1.5 million rows. I tried doing a bcp bulk export before I realised you didnlt support that stuff and came out with a bulk export .bin file of a little over 300MB.

I am just backing up my DASP d/b moving it to my machine adding the tabnle there then re uploading it...

 

If you want a coded approach you could use SqlBulkCopy: http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlbulkcopy(VS.90).aspx.
I've tested it on DASP in the past and it did work fine: http://community.discountasp.net/showthread.php?p=37756.

It will work remotely too if necessary.

 

Well in the end I backed up my database, restored it locally, moved the tablke I wanted there using bcp/insert Into and then uploaded it again. It worked but tedious.

I wrote a winform prog that would do it at one point but it would have taken around 6 hours I think as the table had 1.5M rows.

When I looked at myTinyAdmin it did not look liek it would have worked with spatial data (of type geography) - for future reference does it?

 

Sorry should have said thanks for all the input, guys!