Einar

>Stored procedure generator, this sounds interesting. Could you reccomend a product?

Well, I am working on a code generator right now. It will generate .Net code structures in C# or VB.Net, or even VFP code - we will be supporting Java code too at some point. As for SQL code, the code factories are being created right now. Whilst its relatively easy to generate T-SQL output, we are trying to generate a kind of super-class code factory to generate the base level SQL for all SQL dialects like T-SQL, PL-SQL and then, use more specific routines that break into the sub-dialects. So, when this is ready, I could get a copy to you.

If you need something pretty quickly, you could try Codesmith or MyGeneration. These tools use a template driven approach where you script your ouput. They both provide access to SQL server meta-data so, it makes generating T-SQL code fairly trivial. Of the two products, Codesmith is better but it costs a few dollars too. The tool I am working on (called Codingo) uses a high level object based syntax. There are code factories for each language. You just select your ouput language and out comes the code.

With the SQL code generator (as opposed to the OOP code generator), once the high-level factory has been created, you could create your code structure using the object syntax and theoretically, you are in a position to output the generated code in any flavour of SQL for which a code factory exists eg., T-SQL, PL-SQL, MySQL, Postgres, Firebird etc.,

The idea of this generator is that you could create business objects, mappers, business rule classes and the necessary stored procedures. This kind of solution makes writing an application much easier because much of the code required in .Net style applications is repetive, long-winded code to generate classes based on data.

If you are not in too much of a hurry, our generator is totally different from the rest and, it has a business object sample framework that it creates to give you an idea of its power. This is likely to be freeware initially so, there would be no cost.

HTH