Skip to main content
Question

Pulling Feature Classes from Geodatabase to SQL Server

  • August 28, 2019
  • 3 replies
  • 39 views
F
Forum|alt.badge.img

Hi,

I am currently trying to find a solution that might save me a bit of time. I have reader which is geodatabase which contains 10 feature classes and the writer as a SQL Server Database.

I would like to directly load and create new tables in SQL Server that are identical to the feature classes with the same field types.

 

Here are a couple of screenshots on basic setup but obviously hoping to build on top of it. Can anyone recommend any next steps in regards to this issue or had experience in loading data into an enterprise database?

 

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

D
Forum|alt.badge.img

If you apply a SQL Server Writer with a dynamic schema in the attribute definition, it will create the table based on the fme_feature_type attribute and apply the schema from the source Feature Type

F
Forum|alt.badge.img
  • fazsnatch
  • Author
  • August 28, 2019

That is great, I will give it a go

F
Forum|alt.badge.img
  • fazsnatch
  • Author
  • August 29, 2019

If you apply a SQL Server Writer with a dynamic schema in the attribute definition, it will create the table based on the fme_feature_type attribute and apply the schema from the source Feature Type

Hi David,

 

Unfortunatly I could not get this working with SQL server due to a non related FME Issue but good news got it working with postGres SQL.

 

My only issue remaining is the outputs have all been created as tables only. Is there way to get them to pick up the feature classes as the geometry features i.e. points, polygon etc?

Community Stats

32,207
Posts
122,305
Replies
39,891
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.