Post reply

Automatic Generation of CRUD SPs

  • September 15, 2004 at 5:05 am

    #162627

    Does anyone know of any freeware that will automatically generate CRUD Stored Procedures for a database? We're moving to Stored Procedures from inline SQL in ASP/VBScript and I'd like to not have to write them all by hand.

    I've search this site as well as a number of other SQL sites and Google'd the Internet with little result. I found a lot of code generators (.Net classes, etc), but nothing dedicated to just generating SQL CRUD SP's. So I did my homework before posting...

    If not freeware, then what products do people recommend for this?

    If you don't believe in automatic generation of CRUD SP's then that's fine, I respect your opinion, but please don't post a reply telling me why I shouldn't do it. That's not what I'm asking for and I really don't want to get 50 messages telling me I have Reply posts only to find out they're posts telling me not to automatically generate SP's. 

    Thanks muchly..

     

  • September 15, 2004 at 6:22 am

    #523137

    Are you aware that there's a built-in facility in Enterprise Manager?
    Just select your DB in Enterprise Manager, choose Tools, Wizards from the menu, and a 'Select Wizard' dialog appears. Expand the 'Database' node, and choose 'Stored Procedure Wizard'. You can then choose the DB, tables and types of proc to generate. Note that you can only do CUD (No Read), but read queries tend to require selection logic anyway...
    Hope this helps,
    Mark B.

  • September 15, 2004 at 6:28 am

    #523139

    Hmm.. Never saw that wizard. Thanks. I'll have to check it out and see how good the code is that it generates.

    You're right, a general Read function is probably pretty useless. You really need to write specific Read SP's that are tailored to what tables you need to look at and fields you need to use.

     

     

  • September 17, 2004 at 5:13 am

    #523474

    You Want to Check out MyGeneration.Com. It's a free Template based code generator that will generate your stored procs. Optionally It'll write wrap all the Stored procs into VB, C# classes for you!

    Very Nice tool

    Pat Tormey

    New Hampshire

    USA

  • September 17, 2004 at 5:22 am

    #523475

    Thanks! I'll take a look...

     

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply