In this post, we’ll discuss how to perform various day-to-day tasks within our innovative database version control solution, dbMaestro TeamWork^TM Management Studio.

Checking In and Checking Out

From your database management software, dbMaestro TeamWork^TM, Management Studio console, select the database you want to work with from the tree on the left. You’ll be prompted to provide your schema password, click “OK” once you’ve entered it.

All database objects will then be displayed in the center of your console. Left-click on the appropriate object, and select “Check Out Object Definition”. Check to make sure the right object has been selected in the pop-up window, then click “OK”.

You can update the object, using the tool of your choice.

Next, go back to the database configuration management software, dbMaestro TeamWork^TM Management Studio console, left-click on the object that was changed, and select “Check In Object Definition”. When the pop-up window appears, enter in notes about the alterations made in the “Comments” pane, and click “OK”.

Associating Changes to Change Sets

When checking out, you can link changes to tasks in the “Assign to Changeset” area at the bottom of the screen. Choose the appropriate task to link to from the drop down menu, and click “OK”.

Later on, this will allow you to produce the changes made for specific change-sets, while ignoring other ones. For example, you can deploy changes to address one bug, yet skip over modifications related to other bugs that are not yet mature.

Analyze Schema Structure Changes

To review changes to schema structures, left-click on the database procedure in the center of your screen, then select “View History”. When the pop-up window appears, highlight the revisions you wish to compare, and click on the “Compare Revisions” button on the right side of the screen.

Another pop-up window will display the changes made in both the base schema and the compared schema. If all alterations are correct, close the window.

Evaluate Table Content Changes

To review changes to table content, left-click the appropriate table in the center of your console, and select “Check Out Data”. When the pop-up window appears, make sure you have chosen the correct table, and click “OK”.

Next, you can update the table’s content, using the tool of your choice.

To check in the table change, return to the dbMaestro TeamWork^TM Management Studio console, left-click the table in the center of the screen, and select “Check In Data”. When the pop-up window appears, make sure you selected the right table, then click “OK”.

Left-click the table again, and choose “View History”. When the pop up window appears, select the revisions you wish to compare, and click on “Compare Revisions” on the right side of the screen. Another window will open to display the changes in both the baseline and the compared tables. If all changes are correct, close the windows.

To view the video tutorial on using the dbMaestro TeamWork^TM Studio 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

This entry was posted on Thursday, June 24th, 2010 at 5:31 AM and is filed under Technical. You can leave a response, or trackback from your own site.