Posted by click37 on 02/22/07 15:04

Say I want to run this script:

Select * from company

I need it to run on DB1, DB2, DB3, DB4 and DB5

DB1 and DB2 are located on Server1
DB3 is on Server2
DB4 and DB5 is on Server3

The long and manual way I would have to do it, is copy the SQL smt.
Connect to Server1, paste and run it on DB1, then DB2. Connect to
Server 2, run it on DB3 and so on.

Is there a way to configure the script that will allow me to run the
query once, and it'll give me the results from all the DBs I want it
to hit ?


Thanks for helping.


On Feb 20, 8:57 pm, Josh Assing <Xjo...@jAssing.com> wrote:
> "it depends"
>
> I might be able to write you a custom program for free to do it if you give me
> more details.
>
> There'sways to send aqueryto an sql server via script; but it's not pretty.
>
> Tell us more about what you need to do; or email me off the NG if you want a
> mini app
>
> -j
>
> On 20 Feb 2007 14:04:44 -0800, clic...@gmail.com wrote:
>
> >in the market place that will run aqueryon multiple DBs across
> >multiple servers? Without having to manually connect to each server?
> >If so, can anyone provide a link for it.
>
> >Thanks
>
> --- AntiSpam/harvest ---
> Remove X's to send email to me.

[Back to original message]