BPM, Workflow, and Case

 View Only
Expand all | Collapse all

Migration of BAW from Oracle to SQL Server

  • 1.  Migration of BAW from Oracle to SQL Server

    Posted Thu February 06, 2020 02:50 PM
    Is there a method or tool available for migration of the Business Automation Workflow database from Oracle to SQL Server?

    ------------------------------
    Thanks,
    Tim
    ------------------------------


  • 2.  RE: Migration of BAW from Oracle to SQL Server

    Posted Fri February 07, 2020 12:18 PM
    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
    ------------------------------