Skip to main content
Question

Deploying FME Flow 2023 with a custom configuration database name

mgg_beca
Contributor
Forum|alt.badge.img+10

Hi,

I want to upgrade our FME server 2022 deployment to Flow 2023. We have a three tiered deployment:

  • VM with Core and Web
  • VM with 2 engines
  • SQL Server with fmeserver configuration database
  • Network share with configuration directories

I want to deploy Flow 2023 to a new set of VMs and then cut our DNS over once the deployment is complete, so there is no outage time. However, the point of failure is the database. If I remove it to deploy the 2023 Flow db then the 2022 FME server will stop working.

So, can I deploy the new FME Flow with a custom database name - say fmeflow2023?

 

Or is there another way of solving this that I'm not aware of?

 

Thanks,

Marc

2 replies

merlinegeorge
Safer
Forum|alt.badge.img+5

Hello,

 

You should be able to create a different DB with a custom name in the same DB server. We have a set of sql script files that can be used to create DB, DB user, Schema and tables. You could change the reference of the default DB "fme server" when running the scripts.

imageAnd then during core/web installation, the new DB name can be passed with the other Database Server Parameters.

mgg_beca
Contributor
Forum|alt.badge.img+10
  • mgg_becaContributor
  • Author
  • Contributor
  • July 21, 2023
merlinegeorge wrote:

Hello,

 

You should be able to create a different DB with a custom name in the same DB server. We have a set of sql script files that can be used to create DB, DB user, Schema and tables. You could change the reference of the default DB "fme server" when running the scripts.

imageAnd then during core/web installation, the new DB name can be passed with the other Database Server Parameters.

That’s great thanks 😊

Reply


Helpful Members This Week

Community Stats

30,955
Posts
117,308
Replies
38,743
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.