In this article we will see one of the application /Â tool developed by me to run the SQL Query on multiple SQL Server different database at same time. Many time in our projects we found the situation thatÂ we need to execute procedure or sql scripts at 5-10 database.Then we need to open the MS SQL Query Analyzer window and then connect the SQL sever and execute the query on data base manually. With the help of tool i have created you will able to execute single script at multiple SQL server / Database including Azure Data.
This tool is available at github https://github.com/singhvibhuti/MultiSQLExecuter
Download the installer from git hub and install the same in your system.
There might be possibility that you may get access error depends on your operating system settings. If you encounter such problem, go the location where you install the application.
- Right Click on Folder
- Click on Properties
- Click on Security Tab
- Click on Edit
- Permission window will open
- Assign Full Control for all accounts mentioned in Group or Usernames:
- Click on Ok Button.
Now application is ready to perform multiple action on just click.
First you need to add project like many time it happens that we work on multiple project just add new project in system by opening the Add Project Window using short cut key (Ctrl+Shift+N). Enter Project Name and Version and Click on Add Button.
In this way you can add multiple project here. Now you need to enter the SQL connection string by opening the “Connect to DB Window” using short key (Ctrl+N).
Enter the following details:
- Select Project Name
- Enter Server name
- Enter Password
- Enter DB Name (You can add multiple database name separated by (,) if the database lie on same server)
- Select Authentication Type (Windows or SQL)
- If SQL Authentication then enter username and password
- Click on Connect Button.
Application will check the connection settings if connection verified then it will get added to your application.
Now your application is ready for execute query.
Select the project from drop down available at left side and checked the DB where you want to execute the query.
Type or Copy paste the SQL Query on Query Analyzer Panel and click on execute button or Press (F5)
You will able to see progress of query execution on top of query analyzer on progress bar.
This tools is available for free.
Please share your concern if you faced any issues by using this application, your feedback will help me to improve this tool which will help lots of developer like us who is working on multiple SQL environment at same time.
Don’t forget to share your comments.
2,011 total views, 1 views today