Execute multiple scripts at once – you can choose to run specific files or a group of files identified by a pattern, which is a file extension such as .sql. When a pattern is specified, all the files that meet the pattern criteria will be executed in the alphabetical order. |
|
Support different transactional execution – you can choose to run the T-SQL scripts in three transaction modes.
- "Execute scripts within one transaction": Runs all the scripts in one single transaction. If one script fails, the entire set is rolled back
- "Execute scripts on separate transaction": Runs the scripts on separate individual transactions. If one script fails, only the script that failed is rolled back.
- "No transaction": Runs the scripts without transaction.
|
|
Robust error handling – depending on the transaction, when a script fails, either the failing script or the entire set is rolled back. A failing script stops the whole process. |
|
Command line options for batch execution – you can choose to run the xSQL Script Executor with command line options.
This can be usefull if the you wish to use in schedule jobs or batch files. |
|
Simple and intuitive interface – a very simple interface allows you to finish your task with very few clicks. Asynchronous execution mode of the scripts provides for a smooth run. |
|