Re: Rolling out structural changes to a distributed SQL environment

Thanks Joe,

Sometimes the simple poor man's tool is the best for the job!

So, to paraphrase.

We pop a job on all the destination SQL servers that execute a payload.

We drop off a payload (scripts) and start the job (or scheduled)

The job picks up the payload and runs it.

Thanks,

Glynn

"Joe Yong" <jyongNOSPAM@xxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:eaIFxLUYFHA.1404@xxxxxxxxxxxxxxxxxxxxxxx
> There's not a whole lot you can do with schema changes using replication
> in SQL Server 2000 (2005 rocks!). I'd go the scripting route on this one.
> If you have the list of servers somewhere, it's fairly easy to write a
> script that pushes a job and set of scripts out to each server.
>
> I'd push the scripts out to the server along with a local job (look up
> sp_add_job and other related sprocs) to fire off the scripts that make the
> changes you need. That makes the operation asynchronous so your dependency
> on the network is kept at a minimal. The job can then post the results
> back to a central location so you know if it was successful or otherwise.
>
> The cool thing about this is you can reuse the scripts for all future
> jobs.
>
> Of course, this is a poor man's solution in the absence of a fancy tool.
> :-)
>
>
> joe.
>
>
>
> "Glynn" <wwgze@xxxxxxxxxxxxxxxx> wrote in message
> news:efh7TpTYFHA.2124@xxxxxxxxxxxxxxxxxxxxxxx
>> Hi All,
>>
>> I'm grappling with the issue of rolling out SQL changes to multiple (150)
>> machines deployed in the field.
>> These machines are joined via a slow 64K WAN.
>>
>> How do you reccomend I deploy scripts in the field? I'm toying with SMS,
>> but am unsure of how to deploy the packages.
>>
>> Is some sort of SQL replication in order?
>>
>> Regards,
>>
>> Glynn
>>
>
>


.

Relevant Pages

  • remote SYSTEM compromise in WASD OpenVMS http server
    ... WASD VMS Hypertext Services is a popular http server for OpenVMS ... - getting the sources of all cgi scripts ...
    (Bugtraq)
  • Re: problem with validated site
    ... server side scripts have drawbacks that must be weighted against their benefits when compared to alternative reliable authoring strategies. ... This has a simple effect with most user agents: Everytime you navigate to a page of the site, it's entirely reloaded. ... For example, it should expand entity references and marked sections (because they're not supported by existing HTML user agents), but shouldn't close omitted tags. ...
    (comp.infosystems.www.authoring.html)
  • SUMMARY: repository for scripts for multiple machines, and multiple users
    ... subversion, cfengine, rdist, rsync, NFS ... I have been messing about with shell scripts to maintain a common base ... regular updates from a central server. ... Highly granular access control is possible with Subversion. ...
    (SunManagers)
  • Re: Is someone trying to hack my Web Host?
    ... >>I was looking through the raw log files to see who's visiting my ... "scripts" directory. ... > web server at home connected to the net. ... int main { ...
    (alt.computer.security)
  • Re: Update on Timer Frequencies
    ... I'm running a video server that is taking in and sending out ... > it's not a perfect test to evaluate timer frequencies (because it doesn't ... There may be clashes between the scripts and the services. ...
    (Linux-Kernel)