Skip to main content
Solved

MSSQL Reader - How to detect underlying DB table schema changes?

  • January 26, 2022
  • 2 replies
  • 24 views

boneill81
Forum|alt.badge.img

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.

Best answer by david_r

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.

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.

2 replies

david_r
Celebrity
  • 8391 replies
  • Best Answer
  • January 26, 2022

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.


boneill81
Forum|alt.badge.img
  • Author
  • 3 replies
  • January 26, 2022

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!