Skip to main content
Question

Will DNS aliasing for SQL instances work with FME database connections?

  • October 29, 2019
  • 2 replies
  • 43 views
agelfert
Contributor
Forum|alt.badge.img+8

I'm in the process of moving to SQL Server 2017 for ArcSDE. My plan is to use DNS aliasing to route any ESRI connections to my existing SQL instances (in case I miss any during updates of connection files) to the new 2017 instances. Database names won't change.

Will this work for FME as well? I don't know how FME stores the connection info in the workspace. Mostly concerned with FME Server. Hopefully, there are no IPs stored anywhere!?

So if I'm currently using:

  • Instance: OldSQLBox
  • Database: MyOldDB
  • Windows Authentication

and the new instance is called: NewSQLBox.

Will my FME connection pointing at OldSQLBox, MyOldDB work once aliasing is setup and "traffic gets routes" to NewSQLBox, MyOldDB? (I'm sure you can tell from the jargon here that I'm no DBA - haha!)

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

M
Forum|alt.badge.img+2
  • markatsafe
  • October 31, 2019

@agelfert FME uses the SDE connection files to connection to your SDE. So if DNS aliasing is working in ArcGIS then it should work OK with FME. The SDE connection files does not store the IP address, only the instance names. So I think your instance names will also have to be the same

agelfert
Contributor
Forum|alt.badge.img+8
  • agelfertContributor
  • Author
  • Contributor
  • November 6, 2019

Thanks, Mark. I'm about flip the switch and will report back if I run into any snags.

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.