Skip to main content
  • EN

Hi Guys,

 

New to FME but really enjoying the journey to date. Today I hit my first confusing issue which although I have resolved I am pretty sure they must be a better way.

 

I had:

  • Created an MSSQL table
  • Created an FME reader which detected the schema including attribute types and so forth.
  • Did some processing and wrote to a file geodatabase.

 

But:

  • I then made some minor changes to the underlying MSSQL table i.e. changed text to decimal etc.
  • However the reader would not detect these changes. I had to delete and recreate the reader for then changed to be detected.

 

Is there some easier method which I am missing to get the reader to detect changes to the table schema in the database?

 

Apologies in advance if the solution is simple but I am missing it!

 

Thanks,

Barry.

You can use the Update reader feature types functionality:

https://desktopmanualbasic.safe.com/DesktopBasic4Components/4.09.UpdatingReaderFeatureTypes.html

It does not automatically detect changes to the underlying tables, but it's easier than recreating the reader.

You can use the Update reader feature types functionality:

https://desktopmanualbasic.safe.com/DesktopBasic4Components/4.09.UpdatingReaderFeatureTypes.html

It does not automatically detect changes to the underlying tables, but it's easier than recreating the reader.

Super David, many thanks for the help, it is very much appreciated!

Reply


Community Stats

30,171
Posts
114,537
Replies
37,835
Members
Terms & ConditionsCookie settings
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.