Skip to main content
Solved

Can IFS run off SQL DB rather than Oracle?

  • November 15, 2021
  • 1 reply
  • 516 views

Forum|alt.badge.img+11

It may be a poorly worded question, but just wondering if its possible

Best answer by Charith Epitawatta

Hi @BLLBrucemo,

IFS runs with Oracle database and there is no way around that. IFS business logic is written in PL/SQL so the application is heavily reliant on Oracle database. 

By “SQL db”, I assume you mean Microsoft SQL Server. It is used for additional installation options such as SSRS, but not used as the main storage tier. 

You can find storage tier documentation here:

https://docs.ifs.com/techdocs/Foundation1/020_installation/020_installing_fresh_system/010_planning_installation/010_storage_tier_considerations/default.htm

Hope this helps!

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

1 reply

Charith Epitawatta
Ultimate Hero (Employee)
Forum|alt.badge.img+31
  • Ultimate Hero (Employee)
  • 1093 replies
  • Answer
  • November 15, 2021

Hi @BLLBrucemo,

IFS runs with Oracle database and there is no way around that. IFS business logic is written in PL/SQL so the application is heavily reliant on Oracle database. 

By “SQL db”, I assume you mean Microsoft SQL Server. It is used for additional installation options such as SSRS, but not used as the main storage tier. 

You can find storage tier documentation here:

https://docs.ifs.com/techdocs/Foundation1/020_installation/020_installing_fresh_system/010_planning_installation/010_storage_tier_considerations/default.htm

Hope this helps!


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