RE: [cobalt-users] Automatic ASP execution across many virtual sites.

["Simon Watts" <simon@xxxxxxxxxxx>]

>> We need to be able to automatically "push" data from the central db into
>> each client db at a predefined time each day, based upon data changes
made
>> within the central db, in the form of an automatic update. This would
>> obviously need there to be an ASP script called and executed on
>> the main db
>> site at a predefined time each and every day, ie on a schedule.

>You don't need to use ASP to do this. Is the information that is being
>pushed from the central db standardized across all individual dbs? Schedule
>a script to run (on your RaQ) that will pull the information from the
>central db and update the individual dbs.
>
>
>alex

The data structure is exactly the same within all db's, the only difference
being that the stored data in each client db reflects only their own
requirements, but the central db carries ALL records. We have initially
chosen to push, rather than pull, because it means only executing one script
rather than a large nember. We envisage that within 2 years we will have
between 100 and 200 client dbs all being fed by the central db. As you can
imagine, setting off 200 scripts simultaneously would be extremely processor
intensive, whereas 1 script would seem to be simpler to run and administer.
Please correct me if my assumptions are incorrect.

The original qustion was what type of script would we have to set up. Would
it be a perl, asp, php script to initiate the process. The actual script
that does all the work WILL be ASP, but we need to know how to initiate that
script on a predefined schedule.


Regards

Si Watts