Post reply

.shp file upload to SQL table -automation

  • April 7, 2011 at 3:57 pm

    #389232

    Hi All,

    Can you please help me to perform the automation of .shp file upload to SQL tables (SQL Server 2008).

    My file has customer info and longitude & latitude information.

    I tried to find find solution online, but failed.

    Solution I tried - download shape2sql tool and tried to upload but it wasn't working for me. it is not giving me an error but, I don't see the data uploaded.

    Please suggest.

    Thanks,

    Swetha K

  • April 7, 2011 at 10:33 pm

    #1308943

    What are you seeing? What kind of observations can you share with us?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • April 8, 2011 at 2:13 pm

    #1309406

    I have selected the file which needs to be uploaded but it doesnt show me the column names and doesnt import any data though hit upload button.

    I should also be able to automate the process of upload. Please suggest.

  • April 8, 2011 at 2:17 pm

    #1309409

    How exactly are you trying to upload the file currently?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • April 8, 2011 at 4:03 pm

    #1309468

    used shape2sql tool. Running shape2sql.exe I selected the file needed to upload, configured the server and table which is used for inserting records, checked create spatial index and planar geometry.

    and hit "upload to database" button.

    which is not giving me any results.

    Swetha K

Viewing 5 posts - 1 through 4 (of 4 total)

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