|
Teratrax Database Manager User Interface
The main window of Teratrax Database Manager is composed of the Server
Explorer pane and the Items pane. The Server Explorer pane lets
you navigate all your server objects
(including servers and
databases) in a hierarchical
structure composed of
multiple nodes. Each node represents a different type of database objects.
You can add your enterprise servers to the Server Explorer with a single
right-click. By default, you have the "(local)" server added so you can
start working with databases on the local computer right away.
The Items pane displays a
list of all items contained in the selected node of the Server Explorer.
Right-click on objects in the Items pane to see a list of features
applicable to that object (For example, if you right-click on a stored
procedure name, the compile option will be visible). The moving Splitter
separates the Server Explorer pane from the Items pane and allows you to
resize the two panes. Click inside a pane to make it the active pane.
Alternatively, you can use the Tab key to move between panes.
The following is a list of items in the Teratrax Database Manager main
menu:
File Menu
- Connect: Opens the Connect dialog box
to connect to SQL Server or MSDE.
- Disconnect: Disconnects user from SQL
Server or MSDE. Teratrax Database Manager uses connection pooling to allow
for faster connections to servers. If you need to completely remove the
connections, either kill the connection process or shut down Teratrax
Database Manager.
- SQL Query: Opens a new blank SQL
Query window for you to write custom SQL commands. Commands that return a
result set, will activate the grid for data editing.
- Import Data: Opens the Import Data dialog allowing you to
import Excel and CSV files into the
database.
- Export Data: Opens the Export Data dialog allowing you to
export database tables and views into CSV files.
- Open: Opens the item in the Items pane.
- Refresh: Refreshes the Items pane.
- Add Server: Adds an item to the server
list. Edit the item name to reflect the server name or IP address you want
to connect to. If you use IP address, make sure the server can listen to
IP connections and the firewall allows for such a connection if the server
has a firewall. For named instances of SQL Server or MSDE, use "Server
Name\Instance Name" (MyServer\Inst1)
- Remove Server: Removes a server from
you server list. If you choose to add the server at a later time, the
saved connection parameters will be lost.
Database Menu
- New: Creates a new database and
saves the physical database files in the data folder of the server.
- Backup: Performs a backup of the
selected database (See Backup and
Restore Databases).
- Restore: Restores a database (See
Backup and Restore Databases).
- Zipped Backup: Allows you to backup a database and
and compress its contents in the gzip format.
- Zipped Restore: Allows you to restore a compressed
backup file (in gzip format).
- Shrink Database: Shrinks the size of a
database without removing the active part of the database log.
- Truncate Log: Removes the active part
of the database log and shrinks the size of the database. A complete
database backup is required after a Truncate Log to be able to recover the
database in the future in the case of a database failure.
- Attach Database: Attaches the database
contained in the file you specify to the current server.
- Detach Database: Detaches the database
leaving the files in the directory the database was created in (useful if
you are creating another copy of a database).
- Delete: Deletes the selected database
from the server. Teratrax Database Manager will warn you before
permanently removing the database. Delete cannot be undone. Use this
option with care.
Actions Menu
-
Query:
Builds the query that allows you to retrieve all table or view rows
without executing it. This option is recommended for large tables.
-
Query All Rows:
Builds and runs the query that allows you to retrieve all table or
view rows.
-
Copy: Copies a table to be pasted at a later time. You can copy and
paste tables between different databases on the same server.
-
Paste Structure: Creates a copy of the table that was copied by the
Copy command but without any data (empty table). The new table will be
identical in structure but will not contain any constraints such as
primary keys, foreign keys, etc...
-
Paste Data: Creates an identical copy of the table that was copied
by the Copy command. The new table will be identical in structure and data
but will not contain any constraints such as primary keys, foreign keys,
etc...
-
New:
Creates a new object based on the selected node in Server Explorer.
-
Edit: Edits the object selected in the Items pane.
-
Script: Scripts the
object selected in the Items pane.
-
Rename:
Renames the object selected in the Items pane.
-
Enable/Disable: Enables or disables triggers, foreign keys
and check constraints.
-
Rebuild Index(es):
Performs a table/index Rebuild. Use this features on large tables
to fine-tune your database performance.
-
Run:
Opens a new SQL Query window with the commands to run a stored
procedure.
-
Compile:
Marks a stored procedure or trigger for compilation next time it
runs. This will cause the stored procedure or trigger to run slightly
slower the first time it runs after compilation but subsequent executions
will be faster.
-
Kill Process:
Terminates a user process. If the specified process has a lot of
work to undo, this action may take some time to complete, particularly
when it involves rolling back a long transaction.
-
Make Primary Key:
Makes a column the primary key of the table.
-
Delete:
Deletes an object from the database. Drop cannot be undone. Use
this option with care.
Security Menu
-
New Server Login (SQL):
Creates a new server login that allows a user to connect to the
server using SQL Server Authentication. Although a login can connect to
the server after it has been created, access to user databases is denied
until a user account for the login is created in each database that the
login must access.
-
New Server Login (Windows):
Creates a new server login that allows a Microsoft Windows NT user
or group account to connect to the server using Windows Authentication.
Although a login can connect to the server after it has been created,
access to user databases is denied until a user account for the login is
created in each database that the login must access.
-
Add Login To Server Role:
Adds a server login as a member of an existing server role. Any
permissions applied to the role are inherited by the server login.
-
Change Password:
Changes the login password. Use null instead of '' for a blank
password.
-
Delete Server Login:
Deletes a server login from the server. Delete cannot be undone.
Use this option with care.
-
New Database User:
Creates a new user account in the current database and associates
it with a server login. When a connection is made through the associated
server login, the permissions given to this user account would be in
effect when the connection uses the current database.
-
New Database Role:
Creates a new user account in the current database and associates
it with a server login. When a connection is made through the associated
server login, the permissions given to this user account would be in
effect when the connection uses the current database.
-
Add User To Database Role:
Adds a security account as a member of an existing database role in
the current database. Any permissions applied to the role are inherited by
the user.
-
Delete Database User:
Deletes a user from the database. Delete cannot be undone. Use this
option with care.
Jobs Menu
-
New:
Creates a new job and schedules it to run at the specified
date/time interval. See Creating and Scheduling Jobs
for details.
-
Start:
Starts a job immediately irrelevant of the time it is scheduled to
run.
-
Drop:
Deletes a job from the server. Delete cannot be undone. Use this
option with care.
Tools Menu
-
Find:
Allows you to search for database objects that contain a certain
your search term in their name OR in their SQL definition. You can use
this tool to search for stored procedures that reference certain tables or
contain certain code or comments. You can also use this tool to filter the
items (database objects) in the Items pane so you can locate the item you
are looking for.
-
Customize Menus:
Allows you to fully customize menus and
toolbars for fast access to your most used features.
Help Menu
-
Help: Opens help.
-
Check For Updates: Allows
you to check if there are any updates and service packs available for
Teratrax Database Manager.
-
Product Home Page: Opens
Internet Explorer and navigates to the Teratrax Database Manager website.
-
About: Displays
information about Teratrax Database Manager.
|
|
|
