In Dynamics of Software Development Jim McCarthy makes the argument in #23 Portability is for Canoes. Well the product I am working on needs ro become a canoe. Currently it has a SQL Server backend and it has been sold into an Oracle only shop.
I expect to have a large number of posts on the pain of porting.
The product has been written using a large number (900 ish at the last count) of stored procedures. We have a handfull of views.
The fun part comes comparing Oracle to SQL Server:
In SQL Server parameters need to start with @.
In Oracle parameters may not start with @.
Oracle is case sensative by default.
SQL Server is case insensitive.
Not much of a problem as all of our tables are NAMED_IN_UPPER_CASE.
Oracle has a 30 character limit on database object names.
You know, stored procedures, tables, indexes, constraints.
We have 130 of these to rename.
The one that will bite us are the stored procedures that return reordsets. Oracle does not allow that. This is the fun one.