Next, we’ll highlight how to conduct routine activities within our innovative database version control solution, dbMaestro TeamWork™, using the sidebar, which is conveniently located on the right side of your TeamWork console. If you cannot see it, you can open it by right-clicking on the sidebar icon in your taskbar.
Assigning Objects to Modules
To get started, you’ll need to open the project you want to work with. Click on the second icon from the left at the top of your sidebar. When the pop up window appears, choose the appropriate project and click “OK”.
You can add a new module to the project by left-clicking it in the tree, and selecting “Add New Module”. When the pop-up window appears, enter the module name and click “OK”.
Next, choose the database you wish to select objects from under “Data Connections”. Note, you will be prompted to enter a password for each data source you select. Once your password has been entered, click “OK”.
All objects within that database will then be displayed. Highlight all the ones you want to assign (you can select multiple objects simultaneously), then left-click and select “Add Object to {module name}”.
When you’re done, those objects will appear under the module in the tree.
Checking Out
To check out objects assigned to a module, left-click the object in the tree within your sidebar, and select “Check Out Object Definition”. When the pop-up window appears, make sure you’ve chosen the correct object, and click “OK”.
Go to your Oracle SQL development environment to make any needed modifications to the object.
Analyzing Changes
To review and analyze the changes you’ve made, go back to your TeamWork sidebar, left-click on the object, and select “View History”. A pop-up window will show all changes made to that object.
Click the “Compare to Live” button on the right side of the screen to compare the saved object definition to the live version. Another pop-up window will appear, displaying all alterations made to both the saved and live objects. If all changes are correct, close the windows.
Rollback Changes
To rollback your changes, left-click on the object in the tree within your sidebar, and select “Rollback DB Object Definition”. When the pop-up window appears, choose the revision you wish to revert back to from the drop down menu, and click “Rollback”.
You can also rollback changes by left-clicking on the object in the tree, and choosing “View History”. Highlight the revision you wish to revert to in the pop-up window, then click the “Rollback” button on the right side of the screen.
TeamWork will ask for confirmation of the rollback request before executing. If everything is correct, click “OK”, then close the History window.
Checking In
To check in the changes you’ve made, left-click the object in the tree, and select “Check In Object Definition”.
When the pop-up window appears, make sure you’ve chosen the correct object, and link it to any related tasks in the “Assign to Changeset” drop-down menu at the bottom. When you’re done, click “OK”.
To view the video tutorial on using the dbMaestro TeamWork sidebar to perform day-to-day tasks, check out the dbMaestro “How to” video collection on our Web site, or visit our YouTube channel.
Tags: Change Management Software, database change management, Database Change Mangagement, database configuration management, database deployment manager, database management software, database schema control, database version control, oracle change management, oracle database version control, oracle version control, SCM, SDLC, Software Change Management, Software Development Life Cycle
[...] example, TeamWork provides an intuitive sidebar, conveniently located on the right side of the console/screen. Through this sidebar, developers can [...]
[...] Using dbMaestro TeamWork in day to day using the sidebar: Learn how to use dbMaestro TeamWork in day to day tasks. Assign objects to modules, check in & out database objects and analyze changes (YouTube video). [...]