Question

SQL SERVER/SSMS Fore Ground Automation

  • 5 January 2023
  • 7 replies
  • 56 views

Badge +4

Hi ,

I have an automation requirement below, Could you please help if this is feasible using AAV11 ?

1.I need to open SSMS in a server/machine and click on connect icon ,enter the details to connect with server

2.Run SQL Script and take the screen shot of the results window.(Note: If we have multiple results need to scroll down the window/page and take the screenshot)

3.Right click on one of the tables and go to properties and take the screenshot of results window.

4.Now whatever the screenshots took above ,come back to an excel sheet and paste it one by one.

5.Disconnect from the server and connect to another server and perform the same steps again for multiple servers.

As per the commands available in v11 I believe we can connect to database and perform some operations in the backend. Just wondering if we can perform the foreground operations which I mentioned above with SQL .

Please suggest.

Thanks,

Avinash

 


7 replies

Userlevel 5
Badge +9

Hi @Y.Avinash ,

Yes, you can automate the steps aforementioned using A11.

Please note, To get the details via Fore Ground Automation the challenge is high.

You need to cover the all the possible cases (Success and Fail ), When you’re automating system/windows based application will be executed on X/Y coordinates. During the execution, the windows size should be correct level for each executions, If any changes then the task will be failed. 

 

Thanks! 

 

 

 

Badge +4

Hi @Y.Avinash ,

Yes, you can automate the steps aforementioned using A11.

Please note, To get the details via Fore Ground Automation the challenge is high.

You need to cover the all the possible cases (Success and Fail ), When you’re automating system/windows based application will be executed on X/Y coordinates. During the execution, the windows size should be correct level for each executions, If any changes then the task will be failed. 

 

Thanks! 

 

 

 

@Tamil Arasu10 : Thanks for the response but what are the options available in v11 and which are those to use for automating the above steps in foreground.

Userlevel 5
Badge +11

Hi @Y.Avinash 

Have you tried with Object Cloning?

Userlevel 5
Badge +9

Hi @Y.Avinash ,

You can use the object cloning and Manage Windows controls to automate the SSMS.

Userlevel 5
Badge +10

@Y.Avinash Is it necessary to use SSMS, when you pass db connection url string it uses the same, if your requirement is to run the sql statement and get the results it is not mandatory to use SSMS.

Badge +4

@Y.Avinash Is it necessary to use SSMS, when you pass db connection url string it uses the same, if your requirement is to run the sql statement and get the results it is not mandatory to use SSMS.

@rbkadiyam : To take the screenshots of the results we need the SSMS in foreground right ? The existing commands will work in background and we can export the results in CSV.

Userlevel 5
Badge +9

 

@Y.Avinash ,

 

Create a new taskbot and record the actions you performed over SMSS. It looks like:

 

 

The best option is using a query to database in order to get the data you need. This can be done using an ODBC connection to database.

Let me know your thoughts

REgards

Reply