LLBLGen 2.0 (2.0.0.0 Final) Adapter serviced

Folks, This may have been covered previously but no searches found anything appropriate:

I am building entities based on a DB schema without DBMS supported relationship management. I use the LLBLGen designer to establish the foreign key relationships. All of this works fine.

The DB is hosted for development on an Oracle server but may be deployed to environments with SQL Server as well.

Naturally enough, when I build I get the Oracle version of the database adapter. Is there any way to simultaneously generate the SQL Server adaptor?

I know that I will need to add code to the application to select the appropriate databaseadaptor but this is a small problem, I really don't want to set up a new DB server port the schema, and create an entirely new project with manually created relationships just to get the same entities with a different driver.

Ideas or pointers to previous solutions are very welcome.

Thanks, Fritz

Well, you can use the DDL SQL Templates with the Project Converter tool to quickly create a new target database and to convert a .lgp file from one database type to another database type.

DDL SQL Templates can be found in the Tasks & Templates download section. Project Converter can be found in the Extras download section.

Great, I'll check those out!

F