Menu commands and other shortcut keys(Oracle To SQL)

 

Published: April 1, 2016

The following sections describe the keyboard shortcuts to access menu commands and other shortcut keys used in various dialog boxes of SSMA for Oracle application.

To access File menu, the keyboard shortcut used is ALT + F. The following table describes the keyboard shortcuts used to access menu items under File menu.

TO DO THISPRESS
Display the new project dialog box.ALT + F + N
Display the open project dialog box.ALT + F + O
Close the current project.ALT + F + C
Display the save project dialog box.ALT + F + S
Display the connect or reconnect to Oracle dialog box.ALT + F + T
Display the connect or reconnect to SQL Server or SQL Azure dialog box.ALT + F + Q
Access recent projects.ALT + F + P
Exit SSMA application.ALT + F + X

To access Edit menu, the keyboard shortcut used is ALT + E. The following table describes the keyboard shortcuts used to access menu items under Edit menu.

TO DO THISPRESS
Cut selected text to the clipboard.ALT + E + T or CTRL + X
Copy selected text to the clipboard.ALT + E + C or CTRL + C
Paste the most recently added text from the clipboard.ALT + E + P or CTRL + V
Undo the last action.ALT + E + U or CTRL + Z
Redo or repeat an action.ALT + E + R or CTRL + Y
Display the manage bookmarks dialog box.ALT + E + B or CTRL + X
Go to lineALT + E + G or CTRL + G
Save the changes done to statement.ALT + E + S or CTRL + S
Access find submenu.ALT + E + F
Find or quick find.ALT + E + F + F or CTRL + F
Display the advanced search dialog box.ALT + E + F + A or ALT + F12
Launch quick info.ALT + E + F + I or CTRL + SHIFT + SPACE
Go to declaration.ALT + E + F + G or F12
Find previous.ALT + E + F + P or CTRL + SHIFT + F3
Find nextALT + E + F + N or CTRL + F3

To access View menu, the keyboard shortcut used is ALT + V. The following table describes the keyboard shortcuts used to access menu items under View menu.

TO DO THISPRESS
Synchronize metadata explorers.ALT + V + Z
Show tree.ALT + V + H or CTRL + T
Show source part.ALT + V + S
Show target part.ALT + V + T
Show error list pane.ALT + V + E or CTRL + E
Show output pane.ALT + V + O or CTRL + O
Access layouts submenu.ALT + V + L
Add current layout.ALT + V + L + A
Select default layout.ALT + V + L + D or CTRL + ALT + 1
Select without explorers layout.ALT + V + L + W or CTRL + ALT + 2
Display the manage layouts dialog box.ALT + V + L + M

To access Tools menu, the keyboard shortcut used is ALT + T. The following table describes the keyboard shortcuts used to access menu items under Tools menu.

TO DO THISPRESS
Create report.ALT + T + C
Convert schema.ALT + T + N or CTRL + R
Refresh from Oracle database.ALT + T + R
Synchronize with SQL Server or SQL Azure database.ALT + T + S
Save as script.ALT + T + A
Migrate data.ALT + T + M
Stop the current operation.ALT + T + O
Display the global settings dialog box.ALT + T + G
Display the project settings dialog box.ALT + T + P
Display the default project settings dialog box.ALT + T + J

To access Tester menu, the keyboard shortcut used is ALT + S. The following table describes the keyboard shortcuts used to access menu items under Tester menu.

TO DO THISPRESS
Display the test case wizard dialog box.ALT + S + N
Display the repository of test cases dialog box.ALT + S + C
Display the repository of test results dialog box.ALT + S + R
Access Oracle backup management submenu.ALT + S + B
Display add tables to backup for Oracle dialog.ALT + S + B + B
Display restore tables from backup for Oracle dialog.ALT + S + B + R
Display manage backup contents for Oracle dialog.ALT + S + B + C
Access SQL Server backup management submenu.ALT + S + M
Display add tables to backup for SQL Server dialog.ALT + S + M + B
Display restore tables from backup for SQL Server dialog.ALT + S + M + R
Display manage backup contents for SQL Server dialog.ALT + S + M + C

To access Help menu, the keyboard shortcut used is ALT + H. The following table describes the keyboard shortcuts used to access menu items under Help menu.

TO DO THISPRESS
Display about SSMA for Oracle dialog box.ALT + H + A
Display customer feedback options dialog box.ALT + H + C
Display help window.ALT + H + H or F1

To access Context menu for the selected object in Object explorer, the keyboard shortcut used is SHIFT + F10 or Apps key.

TO DO THISPRESS
Access GUI tab.ALT + U
Access logging tab.ALT + L
TO DO THISPRESS
Access project information tab.ALT + P
Access general tab.ALT + G
Access synchronization tab.ALT + S
Access GUI tab.ALT + U
Access type mappings tab.ALT + T
TO DO THISPRESS
Access general tab.ALT + G
Access synchronization tab.ALT + S
Access GUI tab.ALT + U
Access type mappings tab.ALT + T
TO DO THISPRESS
Select the entire EULA text.CTRL + A
Copy the entire EULA text to the clipboard.CTRL + C
Print EULA.ALT + P
TO DO THISPRESS
Move one search result to up or down.Up and down arrow keys
Move to begin or end of the visible search results in the grid.Page up or page down keys
View the selected search result.ENTER key
TO DO THISPRESS
Move one item to up or down.Up and down arrow keys
Move to begin or end of the quick info window.Page up or page down keys
Close the dialog box.ESC key
TO DO THISPRESS
Open the pop up menu.SHIFT + F10
Cut selected text to the clipboard.CTRL + X
Copy selected text to the clipboard.CTRL + C
Paste the most recently added text from the clipboard.CTRL + V
Select all the text.CTRL + A
TO DO THISPRESS
Copy selected items.CTRL + C
Select all the items.CTRL + A
Move one item to up or down.Up and down arrow keys
TO DO THISPRESS
Convert schema.CTRL + R
Cut selected text to the clipboard.CTRL + X
Copy selected text to the clipboard.CTRL + C
Paste the most recently added text from the clipboard.CTRL + V
Launch quick findCTRL + F
Launch quick info.CTRL + SHIFT + SPACE
Go to declaration.F12

Shortcut Keys(Oracle To SQL)

Show: