Hi Holger, thanks for the comments. Let me clarify our current and future state.
Currently our webMethods products ( IS, Optimize, MWS, Broker, … ) all run on separate AIX host, and our Oracle database runs on other AIX host, and is managed by a different group.
Our future state is to move the webMethods products from AIX to Linux. Along with that, we need to move our database off of Oracle. Our Database group has recommended Microsoft SQL server. Because the database is managed by a different group, I don’t think it’s a concern to me which operating system they are using. I just need the database to be highly available.
We are currently running webMethods 10.3 on AIX with Oracle 19c on AIX.
We intend to move webMethods 10.3 to Linux with Microsoft SQL server on Windows.
Question 1: If the database is managed by a different group and I don’t think it matters to me what operating system they are on, do you see any issues with webMethods on Linux, and database on Microsoft SQL server in this situation?
Question 2: Does anyone know if we can migrate/copy the database tables from Oracle to SQL Server? For instance we need to migrate the database MWS uses with all the optimize rules and monitored components. SoftwareAG doesn’t have method for exporting/importing those rules and monitored compontents, so without being able to move that data, we’d need to manually recreate it.