 |
|
| Below are answers to the most commonly asked questions about DatabaseSpy® 2008, the unique multi-database data management and modeling tool from Altova.
- What is DatabaseSpy® 2008 and what does it do?
DatabaseSpy® 2008 is a unique multi-database query and design tool from the creators of XMLSpy that connects to all major databases.
DatabaseSpy® 2008 includes a database browser that displays a hierarchy of database tables and views and the data contained in them.
The DatabaseSpy® 2008 SQL editor makes query writing easy and error free, with drag and drop controls, automatic code completion, syntax coloring, selective execution, multiple results windows, and many additional convenient features.
The DatabaseSpy® 2008 design editor provides a graphical representation of existing database tables and their relationships, and allows graphical creation of new tables without the need to hand-write SQL statements.
Back to Top - Who is DatabaseSpy® 2008 used by?
DatabaseSpy® 2008 is designed for database administrators, database developers, and other IT professionals who regularly work with information stored in databases.
DatabaseSpy® 2008 lets users quickly examine or update database content or structure without hand-writing SQL queries.
DatabaseSpy® 2008 also lets users save commonly-used database connection scripts, tables, views, and SQL queries in project files for quick access.
Back to Top - Why should database professionals use DatabaseSpy® 2008?
Database administrators, developers, and other users will appreciate that DatabaseSpy® 2008 offers a single convenient, consistent interface for relational databases from all major suppliers. This lets users concentrate on the task at hand instead of being distracted by the idiosyncrasies of a given database implementation or the custom syntax required for a SQL statement.
Back to Top - What are some of the typical ways database administrators, developers, and other IT professionals use DatabaseSpy® 2008?
Users employ DatabaseSpy® 2008 to complete many everyday data management, query, and design tasks:
- Examine data in database tables and views
- Develop, test, and store SQL statements that are needed on a repetitive basis
- Export data in any of five formats
- Import data from industry-standard CSV files
- Graphically display structures and relationships of database tables and design new tables
Back to Top - What kinds of databases can DatabaseSpy® 2008 connect to?
DatabaseSpy® 2008 connects to all major relational databases, including:
- 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 II
In fact, DatabaseSpy® 2008 is designed to work with any database that uses an ADO or ODBC connection.
Back to Top - How does DatabaseSpy® 2008 fit with other Altova tools?
DatabaseSpy® 2008 closely complements Altova XMLSpy® 2008. Export options from DatabaseSpy® 2008 allow database professionals to export content in two XML formats that can be saved as XML files or sent directly to XMLSpy® 2008 as active XML documents.
This can provide database administrators and developers convenient access to all the power and flexibility of XMLSpy, the industry leading XML development environment, as they utilize the content of their relational databases in new XML-based applications.
Altova MapForce® 2008 also fits into workflows with DatabaseSpy® 2008. If a data architect, database administrator or developer needs to convert data from a dissimilar format before importing to a new database, Altova MapForce® 2008 is a visual mapping tool offering the power to map any combination of XML, database, text, or EDI files. MapForce® 2006 can connect to databases and convert source data on the fly for direct insertion, but if connection to the target database is not possible or convenient, one of the many output formats supported is a CSV file that can be imported by DatabaseSpy® 2008.
Database managers interested in DatabaseSpy® 2008 will also want to explore the powerful database reporting features of Altova StyleVision® 2008. StyleVision® 2008 connects directly to database tables and employs a drag and drop interface to create eye-catching database reports with rich formatting options for HTML, Word/RTF, and PDF output — all from a single design.
The combination of XMLSpy® 2008, MapForce® 2008, and StyleVision® 2008 with the database browsing, SQL editing, database design, and export/import features of DatabaseSpy® 2008 provides database and IT professionals with a robust toolset for database management, reporting, and XML development needs.
Back to Top - How does DatabaseSpy® 2008 compare to other database administration tools?
DatabaseSpy® 2008 is delivered in one version that connects to all major relational databases at a price that is much more affordable than other major commercial database administration tools. Many other tools are designed to work with a single vendor’s relational database technology, or must be purchased in multiple editions to work with multiple databases.
DatabaseSpy® 2008 performs many tasks, from examining database hierarchy and table relationships, to viewing data, exporting or importing data, and designing new database tables. Compared to single-purpose applications such as SQL editors, visual database design tools, and data export utilities, multiple alternative products would have to be purchased to attain comparable functionality.
DatabaseSpy® 2008 also provides a rich graphical interface with visual selections to perform all major application operations, including icons to identify database components, graphical toolbars for program operations, color-coded text, drag and drop SQL editing, collapsible panels and helper windows, right-click context menus, tabbed results windows, graphical table display, and a host of additional visual properties that give DatabaseSpy® 2008 users convenient access to all its functionality.
Back to Top
Visit the Business Managers’ Page for more information about the technological and business benefits of Altova products.
|
|
|
|
