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
Select 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.
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.