webMethods switch from Oracle to SQL server

Theoretically and ostensibly, no. Practically, there may be times when the available drivers for Linux will not meet the need for SQL Server in some way. Connectivity to SQL Server from non-Windows is not entirely an afterthought but is not a primary focus either.

In the “here is what another company is doing” category – In our AIX environment, we regularly connect to SQL Server instances via JDBC adapter connections without much fanfare. But we do not use SQL Server for the “core” DB for the wM components. We use Oracle hosted on AIX (our DB team preference – interesting how teams vary :slight_smile: ).

For the migration, it is likely to be entirely up to you. One approach is to stand up an environment on the new infrastructure then analyze the tables in old and new to determine a data copy strategy. Should be mostly straight-forward. The wM components might use DB-specific queries/DDL but I would think (hope!) that it would be minimal. You may also need to pay attention to non-DB config files for some items. Another option: manually recreate things. Not appealing I’m sure but would provide an opportunity for some potential house-cleaning to eliminate items that are no longer needed. And perhaps might be faster to do than the DB analysis and chasing errors and “what did we miss?”

HTH!

1 Like