Vishful thinking…

Arc to SQL2008

ArcToSQL2008

An ArcCatalog command to export FeatureClasses to MS SQL Server 2008 (click image above to download)

Once installed, you should be able to open the “Tools -> Customize” dialog in ArcCatalog

arctosql2008_1Under the “GeoSpatial.NET” Categories, the “ArcToSQL2008″ command should be available. Drag the command to any of the toolbars.

arctosql2008_2Select the FeatureClass you want to export to the SQL Server 2008 database and click the “ArcToSQL2008″ button on the toolbar. The dialog below should pop-up. Enter the name of the SQL Server 2008 database server and click connect. The Database drop-down will get populated with all available databases on the server. Select a database from the list and enter the name of the table that you want the FeatureClass exported to. Click OK. The FeatureClass will get exported and a message box should pop-up when the import is completed.

 arctosql2008_3

Some highlights of the tool:

  • Exports FeatureClasses in a Projected Co-ordinate System as SQLGeometry in SQL 2008.
  • Exports FeatureClasses in a Geographic Co-ordinate System as SQLGeography in SQL 2008.
  • Any errors that occur during the export are logged in a log file found under in the install directory.
  • The tool is built using a broader GIS framework that should enable developers to customize the export process to their liking. I still have a little bit of house cleaning on the code for the broader GIS framework. I will post when it is all done. Hopefully that will be real soon. Contact me if you want to look at it sooner…

Things left to do:

  • Better UI showing the progress of the export operation.
  • More flexibility to the export operation by allowing the user to select the fields to be exported.
  • The export operation can be made faster by using the geometry builder classes to construct the SQLGeometry and SQLGeography objects. I took the shortcut for now and just parsed out the geometries from WKT strings.

3 Responses

Subscribe to comments with RSS.

  1. David Howard said, on November 3, 2009 at 11:50 pm

    Will this tool work with Arc 9.3.1? I was able to export from a 9.2 featureclass to SQL2008 but with 9.3.1 the table is created but is empty.

  2. SamF said, on December 19, 2010 at 4:26 am

    I get the following error when attempting to install Arc2Sql2008 I get the following

    ********************************************************************

    Error 1001. Unable to get installer types in the C:\Program Files [86]\Default Company Name\ArctoSQL2008installer\ArctoSQL2008.dll assembly –> Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information.

    ****************************end of error msg **************************

    I am running Windows Vista Home premium with sp2
    Arc 9.2 sp6
    on an hp notebook with 6gb memory and the 64 bit operating system

    I have also attempted to load this on another computer at work 32 bit xp system and got the same message.

    I attempted to disable my virus and anti maleware software but that did not help (turned it back on).

    Any advice you have would be appreciated.

  3. reinier said, on February 25, 2011 at 8:25 pm

    I get the following error when attempting to install Arc2Sql2008 I get the following

    ********************************************************************

    Error 1001. Unable to get installer types in the C:\Program Files [86]\Default Company Name\ArctoSQL2008installer\ArctoSQL2008.dll assembly –> Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information.

    ****************************end of error msg **************************


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: