I used the project converter to convert a SQL Server project to Oracle10g. Ran the DDL templates and ran them. Getting some really long identifiers, which Oracle has a limit on. Here is one of the many errors.
ALTER TABLE "UserPermission" ADD
CONSTRAINT FK_UserPermission_PermissionType FOREIGN KEY
(
"PermissionTypeId"
)
REFERENCES "PermissionType"
(
"PermissionTypeId"
)
ORA-00972: identifier is too long
Also, I am using the express edition (so i don't know if this is different), but going from SQL Server to Oracle, made the statements look like this:
ALTER TABLE "dbo"."UserPermission" ADD ...
The users appear to be case insensitive, so really it should have been "DBO". Since express (not sure of the others), will execute the statements as the current logged in user (DBO), I just did a find/replace and removed "dbo". from the script.
Great work on this so far, it will save people a lot of work