Supporting MSSQL server and Oracle

[norbert]

Until now, we only used MSSQL Server as backend database. Most of our tables have a primary key that is marked as "DB identity" in Servoy.

Now we have a customer that has Oracle as backend database. I understood Oracle natively doesn't support db identity columns, so I'm looking
for a way to support both database types with my workspace.

Is moving to "servoy sequences" the only option to support both MSSQL and Oracle with 1 workspace when requiring "db identity" columns,
or is there another option?

Thanks for your help!