SQL Scriptor is a handy application that can be used by all those looking to organize and manage the updates of their SQL databases, as well as their release process. One first needs to connect to the database, then they can check their scripts and execute them with ease.
Establish SQL connection
In order to get to enjoy the functions of SQL Scriptor, you will be required to create a successful connection to your SQL server, by specifying the account name, the path to the scripts folder, the server and the database names.
If you want, you can leave the path to the script folder empty, and in this case, the application will display the script execution records found in the target database.
Additionally, you also need to mention the type of authentication you prefer - if the Windows Authentication checkbox is marked, no extra info is required. However, if you do not use this method, you also have to enter the dedicated username and password, then login to the database.
Check and execute database scripts
Once you are logged in to your database, SQL Scriptor processes the data from the script folder you previously mentioned and also analyzes the target database so as to identify the scripts related to the same module.
You will also be able to examine the history of all updates you executed in the past, as well as explore all the scripts that need to be executed next. You can also skip some of them, if you are not interested in their functions just yet.
While executing the scripts you selected, SQL Scriptor displays confirmations for the ones that were completed successfully, and it also presents you with detailed information for the ones that returned an error.
All in all, SQL Scriptor will come in handy to all experienced users who want to manage their database updates from a centralized interface, where they can also review the script errors.