Tracking Schema reusability in Oracle

Hi,

I am working on a banking application and I am using Workflow Foundation for the development of a workflow subsystem. Our application is architected to work with any back end like SQL Server, Oracle etc. I used the tracking services and the supporting schema (tables and sp's) while developing on SQL Server. I was wondering whether the same tables and stored procedures can be ported into Oracle or not. If not, what is the way around. Do I write the schema myself. That would be a daunting task really. I am anticipated that the tables wont be a problem. Its the stored procedures that I am worried about.

Any help would be appreciated.



Answer this question

Tracking Schema reusability in Oracle

  • davidacoder

    Thanks Tom,

    It was extremely helpful.


  • Spider

    No, they can not be ported to Oracle and you will need to write your own custom persistence / tracking for Oracle. Take a look at this post for a starting point.

  • Tracking Schema reusability in Oracle