Is there any way to migrate existing LLBLGen project from MS SQL Server database engine to Oracle?

Which version of LLBLGen are you using ?

LLBLGen Pro 2.6 and 3.1.

In v2.6 you can. You have to download the **Project Converter ** at LLBLGen Site -> Customer Area -> v2.6 -> Extras. Compile the Project Converter source code and follow the readme.txt instructions.

And in v3.1:

-> right click 'relational model data' in project explorer or catalog explorer and select 'Add relational model data storage for a database' and select Oracle (ODP.NET). (you have to install ODP.NET)

If you use bit fields in sqlserver: - right click project node in project explorer -> edit type conversion definitions - specify a type converter for Boolean -> Int16 (NUMBER(1, 0)) - Right click project node -> properties - make sure AutoAssignTypeConverterToFieldMapping is checked.

-> then right-click 'Entities' in project explorer -> select Automap unmapped entities.

It will generate the oracle tables from this. Click 'Project -> Validate and Adjust Relational Model data', and fix errors you ran into, eventually adding fields manually on the field mappings tab.

Then export the DDL SQL create script and you're done.

Thanks!