Database context menu
The context menu of a registered database in the DB Explorer tree allows you to:
-
connect to the selected database (if connection to the database is not active yet);
-
disconnect from the selected database (if connection to the database has been already activated);
- access database tools and services available in the Tasks submenu;
-
access
change management tools;
-
view/edit the
Database properties;
- view/edit the host properties within the Server Configuration dialog;
-
create a new database at the host where the selected database resides;
-
drop the selected database;
- view/edit the selected database registration information within the Database registration manager;
-
register a new database or host using
Register Database Wizard;
-
unregister the selected database;
-
unregister the host where the selected database resides;
-
view/edit the selected database registration information within the
Database Registration Info dialog;
- generate the database script and open it in SQL Editor;
- generate the database script and copy its text to Windows clipboard;
-
access
View Mode options;
- configure representation of hosts and databases in Database Explorer;
-
refresh the selected database;
- test connection to the database (or reconnect if connection has been already established);
- manage DB Explorer Tabs;
-
search for an object within the tree;
- continue searching for database objects that match the defined conditions.
Tasks submenu allows you to:
backup database using the wizard
restore database using the wizard
extract database objects and/or data to an SQL script
copy database objects and data to different location
generate html report of the selected objects
create to-do list
Change Management submenu allows you to:
-
create branch/label/tag using the wizard
- check repository using the wizard
-
get change script using the wizard
- release new version of database using wizard
-
browse
history of object/database changes.
View Mode submenu allows you to:
-
show/hide table subobjects
-
show/hide hosts
- sort databases by their aliases (by default databases are displayed due to their registration order)
- show/hide disconnected databases
- check table subobjects to display in SQL Assistant within the Tables' Details submenu
- check other subobjects to display in SQL Assistant within the Objects' Details submenu.
- create a new DB Explorer tab with the selected database/host only
- rename active tab
- delete active tab.
|
See also: |