Bookshelf: DAC Toolbars and Right-Click Menu Commands

Table 15 lists commands available in some of the top and bottom pane toolbars and in the right-click menus. The commands that are available depend on the tab that is active.

Table 15. DAC Toolbar and Right-Click Menu Commands
Command	Location in DAC	Description
New	Top and bottom pane toolbars, right-click menu	Creates a placeholder for a new record in the selected list.
Save	Top and bottom pane toolbars, right-click menu	Saves the current record.
Undo	Top and bottom pane toolbars, right-click menu	Undoes changes made to the current record after the last save.
Delete	Top and bottom pane toolbars, right-click menu	Deletes the selected record. If you delete a parent record, the child records are also deleted.
Query	Top and bottom pane toolbars, right-click menu	Opens a blank query.
Refresh	Top and bottom pane toolbars, right-click menu	Retrieves the data from the repository with the last used query.
Preview	Top pane toolbar in Design view tabs: Execution Plans, Subject Areas, and Table Groups	Generates a preview of all tasks and their dependencies.
Edit	Bottom pane toolbar in Design view	Opens a dialog box in which you can add and remove objects associated with the selected repository object.
Details	Bottom pane toolbar in Execute view, Task tab	Provides a list of the task details that are executed when the selected task is run.
Run Now	Top pane toolbar in Design view, Execution Plans tab	Starts a new ETL process.
Start	Top pane toolbar and right-click menu in Execute View tabs: Current Run, Run History	Restarts the selected ETL, after the ETL has failed, stopped, or been aborted.
Stop	Top pane toolbar and right-click menu in Execute View tabs: Current Run, Run History	Stops an ETL in progress. All currently running tasks will complete, and queued tasks will stop. The status of the ETL changes to Stopped.
Abort	Top pane toolbar and right-click menu in Execute View tabs: Current Run, Run History	Causes an ETL in progress to abort. All currently running tasks will be aborted. The status of queued tasks and the ETL itself will change to Stopped.
Auto Refresh	Top pane toolbar and right-click menu in Execute View tabs: Current Run, Run History	Allows you to turn on and off the automatic screen refresh functionality and set the refresh interval.
Copy String	Right-click menu	Copies the contents of a cell (editable and read-only) to the clipboard
Paste String	Right-click menu	Pastes a string from the clipboard into a selected cell that supports a string data type.
Copy Record	Right-click menu	Creates a copy of the selected record, with a unique record ID and (2) appended to its name. The new record is committed to the database when you click the Save button or click outside the cell. In the Design view tabs (except for the Indices tab), Copy Record copies the selected record and the record's child records. In the Design view Indices tab and Setup and Execute views, Copy Record copies only the selected record.
Output to File	Right-click menu	Outputs to a text file in the DAC root folder the contents of the current tab's record list.
Record Info	Right-click menu	Displays the record's unique ID and the timestamp for when it was last updated.
Generate Index Scripts	Right-click menu	Generates drop index, create index, and analyze table scripts for all tables that participate in the ETL process. The results are stored in the log\scripts directory.
Generate Change Capture Scripts	Right-click menu	Generates change capture scripts for tables with defined image suffixes. The scripts may include delete triggers, create and drop statements for delete triggers, and image tables and their indices.
Update Rows	Right-click menu	For some columns, allows you to update the column value for each row to a single value. When you select this command, a dialog box allows you to select the column, and then a second dialog box allows you to enter a value for the column.
Import Database Tables	Right-click menu	Allows you to import table definitions from a selected database.
Import Indices	Right-click menu	Allows you to import index definitions from the database for one or more tables as listed in the result of the query.
Output Task Description	Right-click menu	Saves to an HTML file the description for a selected task definition or for all task definitions.
Run Now	Right-click menu	Starts a new ETL process.
Go To	Right-click menu	Allows you to drill down to a particular record that is associated with the selected record. Available when the Task Definitions, Indices, Tables, and Table Groups tabs are active (Design View).
Mark as Completed	Right-click menu	Changes the status of a stopped or failed ETL to Completed. In the audit trail for this ETL, the status is Marked as Completed. Use this command with caution; it can cause the data warehouse to be inconsistent.
Requeue Task	Right-click menu	Changes the status of the selected, completed task and its dependents to Queued. Available only for failed ETLs.
Get Run Information > Get Log File	Right-click menu	Fetches the log file for this run from the DAC server and saves it in the ServerLog folder.
Get Run Information > Analyze Run	Right-click menu	Saves a description of the run as an HTML file in the Log/Statistics folder.
Get Run Information > Get Chart	Right-click menu	Displays a chart showing changes in task statuses over time in a separate window.
Get Run Information > Get Graph	Right-click menu	Displays a graph showing changes in task statuses over time in a separate window.