Hi,

I'm evaluating the LLBLGen.Pro tool I saw that from a DB schema the mappong objects can be generated. I want to know if the opposite way is possible. Generate the code and the tool will generate the DB schema. Thanks in advance

I don't think it does, but I agree that would be very handy.

LLBLGen Pro won't generate the db schema, nor will it every do that, as it's against the philosophy of the toolkit: you should design your E/R model which is the base of your database schema with a proper toolkit special made for that purpose. LLBLGen Pro is for bridging between the Relational database model and the object model.

It would be useful for deployment though. The code is built from the most recent DB schema. So having a method that builds a new DB from scratch using the code would be great for deploying projects.

Oh but that's a different scenario . Indeed DDL generating templates are useful, and we've plans to create some of those soon.

Otis wrote:

Oh but that's a different scenario . Indeed DDL generating templates are useful, and we've plans to create some of those soon.

Sorry I assumed that's what he meant

or a database default value for the field

I thought that's what he meant too.

There are tools that generate DDL scripts, though. Quite a few, actually...

JimFoye wrote:

There are tools that generate DDL scripts, though. Quite a few, actually...

I agree. I would rather Frans spend his time on other stuff.

Now, if he is going to let you design the entities in the Designer and then Create the DDL, that would be great. Even better if it had a feature like deklairit that automatically updated the db based on a deployed assembly even better.

But, as long as the metadata is always built from an existing db, I am very happy with Db Ghost to generate change scripts.

BOb

I can add EMS Database Comparer to that list. This also generates change scripts very nicely, and for only $ 65,-