What’s new in DatabaseSpy
2011r2?- Advanced Charts in DatabaseSpy -
Data sets often require special chart styles to create the most
accurate and vivid graphical representation. DatabaseSpy 2011r2
Enterprise Edition extends charting functionality introduced in
v2011, supporting the new advanced chart types (Stacked Bar charts,
Area charts, Stacked Area charts, Candlestick charts and more.
What’s new in DatabaseSpy 2011?
Charts in
DatabaseSpy
A graphical representation of data in a chart
is much more vivid and communicates meaning more quickly than tables of
numeric data. DatabaseSpy 2011 Enterprise Edition supports an entirely
new set of charting features to graphically represent SQL query results.
A new link in the Results window toolbar opens the Chart Selection
dialog to initiate data charting. The following chart types are
available to provide the most appropriate representation of various data
sets:
- Line charts
- 2D and 3D bar charts
- 2D and
3D pie charts
- Round gauge and bar gauge charts
Numerous customization options are available for each chart type,
including control of foreground and background colors, definition of
axis ranges and labels, control of fonts colors and sizes, and more.
DatabaseSpy 2011 charts may be exported to image files in .png, .bmp,
.gif, or .jpg files in sizes specified by the user Exported charts can
be used to create eye-catching visual elements to highlight reports of
all types. Customized chart settings can be saved in settings files and
loaded later for reuse. Charts can be generated based on relational
data, or on calculations performed in SQL statements.
*Altova DatabaseSpy includes
these robust and highly-flexible components and capabilities:
-
Connectivity to all major databases
- Quick connect wizard
-
Database project manager
- Online database browser
-
SQL editor
- Database design editor
- Export and
import functions
Altova DatabaseSpy is designed to be
the database professional’s multi-purpose tool, since it connects to all
of the following database types:
- Microsoft SQL Server 2000
and 2005
- Microsoft Access 2003
- Oracle 9i and 10g
-
IBM DB2 8.x and 9
- MySQL 4.x and 5.x
- Sybase 11
In fact, DatabaseSpy is designed to work with any database that uses an
ADO or ODBC connection.
Once you have connected to a database,
Altova DatabaseSpy lets you browse data or examine the database
structure. You can select any table and retrieve all rows or select just
a sample to inspect the table structure. You can even open multiple
databases of different types at the same time to analyze their contents.
Simplify SQL Development
DatabaseSpy includes a built-in
SQL Editor with auto-completion, syntax checking, color coding, and drag
and drop editing to make generation of SQL statements faster, easier,
and more accurate. The SQL Preview function lets you test single SQL
statements or complex SQL scripts and see the results without risking
permanent changes to your databases. DatabaseSpy also features a
graphical Database Design Editor that permits visual design and creation
of the structure of a database without the need for any knowledge of SQL
syntax. You can drag and drop existing database tables into the Design
Editor to modify them, or you can construct brand new tables from
scratch. DatabaseSpy makes it convenient to organize database
connections, SQL files, design files, and favorites into projects for
easy management. Projects are organized into files and saved for quick
reloading and reuse.
Databases to XML and other export and
import options
DatabaseSpy includes export and import
functionality that lets you export database data to any of five
different file formats: XML, XML Structure, CSV, HTML, and Excel, and
import database data from CSV files.
DatabaseSpy has special
features to help database professionals migrate existing database
content for use in XML-based applications. Besides exporting databases
to XML files, DatabaseSpy lets you export database tables directly into
Altova XMLSpy. You can then use all the advanced features of XMLSpy to
accelerate your multi-faceted development project.
Third-party
applications such as accounting software packages and other business
tools often contain underlying databases but do not provide
full-featured database access or functionality. Altova DatabaseSpy can
give a progressive user access to the underlying database to better
understand the application, or to drill into the data to perform
maintenance tasks that would otherwise be cumbersome if not impossible.
As you might expect, DatabaseSpy connects to your relational databases
via existing user names and passwords, so functionality for a given user
is dependent on the privileges configured for that user’s particular
database account. A read-only user can employ DatabaseSpy simply to
view, locate, and sort data. A database administrator with a
fully-authorized user ID, on the other hand, can use DatabaseSpy to
modify existing database tables and their relationships, or design,
create, and populate a new relational database from scratch.