How can I run the "conn" command in SQL Window?

[Anderson Oliveir]

How can I run the "conn" command in SQL Window?
In the Command Window I get through the command: "CONN USER / PASS @ DATABASE".
The reason to know this is due to having several queries in sequence, with different databases...

Att
Anderson

 

[Marco Kalter]

There is no connect command in the SQL Window, but you can select a different connection from the status bat at the bottom of the window.

 

[Anderson Oliveir]

Hey Marco!

Thank you very much for your attention!!!

I figured there was this limitation and I wanted to make sure !!!

Can you tell me if I have to do the same query in two different databases (example Production and Tests) to then generate a script with the different data ???

Sincerely

 

[Marco Kalter]

No, this is not possible. You could however use the "Compare Tables" tool to compare the data in the 2 databases and generate a script to equalize them.

 

[Anderson Oliveir]

Thanks again!!!