Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I would like to import my File Geodatabase from ArcGIS 10.1 into MS SQL Server 2012.

I have never done it before, so I expect to do the import the same way as import data from excel table.

Problem is when I open MS SQL Server Import wizard and as a data source I choose Esri geodatabse OLE DB provider - an error occured:

ClassFactory cannot get required class. (Microsoft OLE DB Service Components)

Please does anybody know what I´m doing wrong, or is there some easiest way, for example with ArcSDE?

share|improve this question
    
Isn't is so that shapefiles do not contain topology (for example the relation between two connecting line objects in a road layer), meaning you will loose this information if you first convert to a shapefile? –  Peder Jun 2 at 13:49
add comment

2 Answers

up vote 3 down vote accepted

ArcSDE is the best option to Import and Manage your Geodatabase in Database servers ( SQL server,Oracle ,...) . You can't import File Geodatabase or Personal Geodatabase directly in SQL server . you should use ArcSDE software . The Geodatabase type of ArcSDE is SDE Geodatabase not File Geodatabse. I think you should use ArcSDE to Import And Manage your Geodatabase. Don't doubt to change of Geodatabase type from File to SDE Geodatabase. maybe you'd like to use Permissions,Versioning,History,syncronizing and another capabilities of SDE Geodatabase.

share|improve this answer
    
Does this imply that you are merely pointing to an SDE feature class then converting it to SQL server spatial data type? Couldn't you also convert to shapefile and use the Shp2SQL import tool? –  mapBaker Jun 3 '13 at 18:51
add comment

You could also go via shape file (not the most elegant but gets the job done): FileGeodatabase -> Export to ShapeFile - then use Shape2SQL tool to import shape into Sql Server.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.