Hi Jason and all

What I am proposing most of which I have done

A tool for running a developers DDL / SQL script for updating a clients dataset.
Using Synedit the script can be viewed / edited with line numbers/ syntax highlighted
(especially useful for reported script errors as you can go to the line number !)

An automatically generated log that can also be auto emailed if the update errors.

The script can have some simplistic sections - so far I have come up with the following,

The script file will be scanned first to find the number of statements for a progress bar.

set UserInfo - displayed in progress box as script runs
set PromptUser 'message' - The user will be prompted as to if they want to run the next statement or not.


I now have most of the above, in my particular case the client may have up to 200 local databases to update so I am also adding-

A small db that contains details about sites to update, IP's - names etc.

The user will have the option of automatically running through the list updating all the sites and generating a log. I also have a small table of release info on each client database that describes what release level the clients database is so that an upgrade script can be selected accordingly.


What I haven't looked at so far is backing up the user database's before the upgrade run on each client machine.
Can anyone suggest how to do this remotely ? I guess I can call gbak on the machine running the update application ?

I will post the final project on the IbObjects site (Delphi 5) with some documentation and also on the firebird site, hopefully other people can pick it up too and help move it forward after that.

Can anyone else offer / see any ideas for basic facilities that would be useful or that I have overlooked ?. I am trying to use public domain or freeware wherever possible, so aside from IBObjects everything else should be free.

Comments ?

Rgds

Peter
Cyionics Ltd

----- Original Message -----
From: Jason Wharton
To: IBObjects@yahoogroups.com
Sent: Friday, November 14, 2003 12:14 AM
Subject: Re: [IBO] TIB_Script


Sounds like you are on the right track. You won't have to parse anything
other than what you put in the set statements, which should simplify your
work and keep the parsing of the script faster.

A feature I would like to introduce is script variables, looping, etc. If
anyone would like to take that on as a contribution I'd be delighted.

Jason

----- Original Message -----
From: <peter@...>
To: <IBObjects@yahoogroups.com>
Sent: Thursday, November 13, 2003 2:24 PM
Subject: Re: [IBO] TIB_Script


> Hi Jason
>
> I can see how using the set statement I can use that in a parser to find
my own script commands,
> I can also see how using skip it I can put in any commands I want that are
not valid SQL.
>
> e.g.
> prompt 'Run This Statement' ;
>
> or
> Set prompt 'Run This Statement' ;
>
> Is there anything else I should be looking at ?, I have looked through the
source.
>
> When I have finished I will put my project up on the IBO site with a pdf
paper as I think it may be useful to other people.
>
> Rgds
>
> Peter


Yahoo! Groups Sponsor



___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


[Non-text portions of this message have been removed]