The object is under version control but for some reason its status cannot be determined (for example, you created a script in your local database while the script with the same name already exists in version control repository, or you upgraded to a higher version of Toad and configured version control for the same repository while you have some uncommitted changes in the database). The object is under version control and has been modified in version control repository. Note:: Toad's Version Control feature does not allow to merge object scripts. The object is under version control and has been modified in both local database and version control repository. The changes are stored in local database only and need to be synchronized with version control repository. The object is under version control and has been modified by user.
The object is under version control and is synchronized with version control repository. The object is added to ignore list and excluded from version control. The object is not added to version control. This is a temporary status that is issued for all objects during version control status processing. Review the following for additional information: Version Control status Hover a mouse over the object in the Object Explorer to see its status. To manage objects and scripts under version controlĭetermine object's version control status. You can create and version control SQL scripts for current database using the Scripts node in the Object Explorer.
See Configure Version Control for Objects for more information. Note: Version Control should be configured in Toad before you start managing objects.
There are two buttons that can be used to manually control the process: They will not be applied in the database unless you commit them. Whenever you execute a DML statement in Worksheet or make any modification using Object Detail, the changes will be applied only in your session. When you disable AutoCommit, you will have to commit or rollback your transactions manually. The last option is to go to the Database menu and select Enable/ Disable AutoCommit.You can also right-click a connection in the Connections View, select Properties and then (un)check the Enable AutoCommit option.Double-click the AutoCommit button in the bottom application bar whenever you work with Worksheet or Object Detail.However, you can also disable AutoCommit for each connection and control the commits manually. This is the default setting in Toad Edge known as AutoCommit. Storage Performance and Utilization Managementīy default, every DML (data manipulation language - INSERT, UPDATE, ALTER, DELETE.) transaction is committed immediately by the database.