There is no tooling for this. The actual capabilities you need to successfully do this will differ depending on the end goal. The easiest scenario would be -
We've been developing BAW solutions with Oracle as the underlying DB but were just told we need to be using SQL Server. How can we address this?
Assuming you didn't write code that is directly querying Oracle (or that anything you wrote that does so is using Straight ANSI SQL) you can export your current solution(s) and import them to a new Process Center and they should "just work". The types of queries to worry about are things that don't translate between the various DB Technologies. For example when performing outer joins if you use the ANSI approach leveraging the "Outer Join" keyword you will be fine, but if you used the Oracle where clause that does the same ( my_table.column(+)=other_table.column) this will not work in MS-SQL
Now if your question requires that we also migrate runtime data from one system to another, that is very very complex to do well. There certainly isn't an IBM offered tool to get you there (that I've encountered). We've talked to several customers over the years that had the underlying need and the various approaches to solving that need, but I've not had anyone choose to move forward.
------------------------------
Andrew Paier
------------------------------
Original Message:
Sent: Thu February 06, 2020 01:01 PM
From: Tim Giltinan
Subject: Migration of BAW from Oracle to SQL Server
Is there a method or tool available for migration of the Business Automation Workflow database from Oracle to SQL Server?
------------------------------
Thanks,
Tim
------------------------------