Skip to main content
Question

Movement of Database to Linux Machine- Impact

  • August 2, 2017
  • 3 replies
  • 1 view

ciarab
Contributor
Forum|alt.badge.img+9

If I move my database to a windows to a linux machine is there any impact on FME users of this database other than updating database connections

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

david_r
Celebrity
  • 8391 replies
  • August 2, 2017

Normally there should be no other impact than having to update the database connections, but it may depend on your database and your setup. For example, if you're on Oracle and rely on tnsnames.ora, you'll probably have to update that as well.

That said, I'd strongly recommend testing it on the development environment before going into production.


ciarab
Contributor
Forum|alt.badge.img+9
  • Author
  • Contributor
  • 167 replies
  • August 2, 2017

Thanks @david_r it is oracle alright, don't have any experience with Linux myself so just curious should I be thinking of anything else in terms of impact on existing users of this database.

Sounds like with testing it should ( fingers crossed) be ok


ravenkopelman
Safer
Forum|alt.badge.img+1
  • Safer
  • 91 replies
  • August 2, 2017

Agree with @david_r that FME is unlikely to notice the migration, but I would be generally concerned that you will see changes with regards to the default character encoding for the database (typically UTF-8 on LInux, and something else on Windows). This change *might* be visible to some FME workflows, depending on the type of database being read from.