How do I port a SqlServer application that uses IDENTITY columns to oracle?

I do not wish to have to change the application code if possible. The current data access in done with Ado.net mostly Datasets and table adaptors.

Most (all) of the current sql statements in the application are simple enough to work on both oracle and sqlserver with no changes. (apart from a string.replace() to convert @ in parameter names)

asked Oct 29 '09 at 12:51 PM in Default

Ian Ringrose
225 ● 2 ● 6 ● 8

(comments are locked)

1 answer:

In Oracle, you create a number column and use a sequence. A good reference for you would likely be Oracle for SQL Server Developers, Vol. 4: Identity Columns & Sequences.

answered Oct 29 '09 at 12:54 PM

Jonah H. Harris
395 ● 3

Do I then need to change my applicaion code so it makes use of a Sequence?

Oct 29 '09 at 01:51 PM Ian Ringrose

The sequence can be incremented via a BEFORE INSERT trigger (which you would have to write). It depends on what your application did with the identity column. Many times, you don't need to change the app code to handle that difference though.

Oct 29 '09 at 02:41 PM Jonah H. Harris

(comments are locked)