|
PRODUCTS
» DATABASE MANAGER
Database Manager is a complete set of SQL Server management tools
written in Dexterity. Database Manager is the perfect enhancement
for SmartList Builder users, since it gives users access to helpful SQL
information such as:
-
Table Keys
-
Data in SQL tables
-
Data in SQL Views
-
Syntax for Views
With the Query window you can create your
own SQL scripts and views from inside of Dynamics GP.
Contultants love Database Manager! This is
a must-have support tool. No longer do you have to run back to
the server to run a query, or talk your customer through how to find
Query Analyzer on the server.
DATABASE MANAGER TOOLS INCLUDE:
Database Manager:
Database Manager provides access to server, table, view, and stored
procedure properties, and the ability to view data in SQL tables and
views.
From Database Manager you can access:
Trace:
Trace allows you to track the communication between the Dynamics GP and the database. This tool is invaluable for troubleshooting, and
identifying tables needed for reporting.
Query:
Query allows you to create and run ad-hoc T-SQL queries.
You can save and run stored SQL scripts, and export
query results to Excel.
Utilities
The WilloWare Utilities create a TEST company
from a LIVE company with a single button click.
The Utilities can create a new test
database from scratch, or refresh an existing one using data from
your live company.
|
