Re: Has anyone used the QuestSqlPlus Toad tool from Toadsoft?

On Sat, 31 Aug 2002 15:18:47 GMT, "jim" <jmmcda_at_mindspring.com> wrote:

>I know you think you had a point in there somewhere but damned if I can find
>it. If you can execute the script in Sql*Plus, then you can execute the
>script in TOAD just as well. And are you saying that 99% of your
>development staff spends their time modifying those version controlled
>script files? How positively primitive.

I'm not talking about executing 1 single script but about building from scratch

1. an instance/database (not application specific)
2. several schemas, roles
3. create hundreds of tables in that schemas
4. create triggers, sequences, views & packages
5. grant privileges between the schemas
6. fill a lot of tables with data
7. possibly migrate data from other databases, flat files bla

This all incorporating about 10 manyears of work, implemented in several hundreds of SQL+ scripts. Has to be testable and reproducible. When deploying to test or going productive, I really enjoy to configure a few parameters, start the master batch, go to lunch with the customer's DBA, start the application and go home.

hth

Marc Blum
mailto:marc_at_marcblum.de
http://www.marcblum.de Received on Sat Aug 31 2002 - 13:11:34 CDT