Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to execute the same SQL Script on various Servers in one Execution

Hello,

 

I would like if it possible to combine the execution of the same SQL Script but on three different servers and to get one table?

 

So imagine that I have Server A, Server B and Server C and the Script1.

 

What I would like to do it is to execute in one time the following steps and get one combine table

 

connect to Server A

Execute Script1

Disconnect from Server A if necessary

connect to Server B

Execute Script1

Disconnect from Server B if necessary

connect to Server C

Execute Script1

 

 

Then get one combine table.

Up to now, I am able to run each separatly by I need to combine the table after.

So I wonder if there is a way to carry out that SQL Task in power bi in one time.

Regards,