I have a MS SQL Server DB that I am porting to DB2. I have heard you have to make the schema identical to re-use the DatabaseGeneric classes. I have noticed all the tables/columns I make are all CAPS. So I have a table like this in SQL Server:

TableName: Project

Columns:

ProjectId (primary key) ProjectName .. etc

In DB2 it ends up like this

TableName: PROJECT

Columns: PROJECTID PROJECTNAME

How does LLBLGen handle this, or do I have to change the SQL Server schema to match db2's? Thanks for any tips/help in advance.

Best thing you can do is to use PROJECT_ID like names, and if you set the preferences to produce pascal casing (in the preferences/project properties) you'll get ProjectId.

Our project converter is almost out of beta, though we don't have DDL Sql templates yet, so working from the schema is recommended. If you need types to be converted, use a type converter for that in the DB2 specific project to keep a field a boolean for example (as db2 doesn't support a bit type)

Thanks Frans, I will keep that in mind and I will be watching for the project converter to come out of beta!