Check in and Check out
The check-in and check-out of objects that are controlled in Team Coding or the VCS can be done in different ways in SQL Navigator.
Check in/check out individual objects
The Check In and Check Out buttons in Team Coding Manager can be used for both database objects and files.
When you check out an object or file, it locks that item in the database. The item remains locked until you check in your changes through Team Coding. You must check out an object before you can compile it.
If a VCS is being used, there are two parts to a checkout
- Check out the source from the VCS.
- Create a check-out transaction for the object in Team Coding. This is what determines the state of the object in DB Navigator or Team Coding Manager.
If a VCS is not being used with Team Coding, only step 2 from the preceding actions occurs. Team Coding does nothing with your source code in this case.
To check individual items in and out
- Open the script or select the object in the .
- Click
to check out an object or click
to check in an object.
You can also check in or check out an object by right-clicking it in DB Navigator or Team Projects browser, and then selecting the desired command.
Check in all items
To check in all objects at the same time, you can:
- Click
on the Team Coding Manager toolbar.
- Select Team Coding | Check-in all to open a dialog where you can select objects individually from a list.
If a VCS is being used, there are two parts to a checkin:
- Check in the source to the VCS.
- Create a check-in transaction for the object in Team Coding. This is what determines the state of the object in DB Navigator or Team Coding Manager.
If a VCS is not being used with Team Coding, only step 2 from the preceding actions occurs. Team Coding does nothing with your source code in this case.
Automatic Check In and Check Out
You can have SQL Navigator automatically check in an item when you open it and check out an item when you close it. You can also have SQL Navigator prompt you to enter a comment. For more information, see Configure Team Coding.
Undo a checkout
To cancel the check out and reverse any changes, click 