In an effort to extend our JCL Framework, we're thinking of creating a tool that will retrieve the database schema and make recommended changes to the database based on preset criteria. For example, create a PK here, create a relationship here, add an autoincrement field here, and so on.

This is made primarily to check the database after it has been created and before any code has been generated. This will be primarily be made to make sure the database is better compliant with the JCL Framework.

To create this tool, it is required that I read every aspect of the database schema. I attempted to use the ADO; I failed miserably . I then remembered LLBL Gen's DQE engines, and thought I could use those.

At this point in time, I have 3 questions;

• Am I allowed to use these legally?
• Is there any chance of you providing me with a working example. Specifically for the SQL Server?
• Is there any other way you think this might be achieved? I'd really appreciate your input on this.

Thanks

DQE's generate code (SQL). You need the drivers. The sourcecode is in the SDK. A licensee of LLBLGen Pro can legally use them

THough the complete database schema is in the project. Perhaps that helps.

My thinking cap is NOT on today . You'll have to elaborate a little more.

I already have the SDK. I'm already using the Driver. But I'm unable to use the code . What I want to learn is how to properly utilize the RetrieveSchema function.

THough the complete database schema is in the project.

What project? Oh, the LLBL project. No, that doesn't really help.

Please check the commandlinerefresher sourcecode in the extras section of the customer area. In there, in Engine.cs, you'll see how to populate a catalog. You'll get back a catalog object with the schema information.

You can then examine that through the catalog object model and if you want, produce DDL SQL to alter the schema.

There simply aren't good enough words for me to thank you!!! Brilliant, that's simply brilliant!!!