 |
|
| Below are answers to the most commonly asked questions about DatabaseSpy® 2009, the unique multi-database data management and modeling tool from Altova.
- What is DatabaseSpy® 2009 and what does it do?
DatabaseSpy® 2009 is a unique multi-database query and design tool from the creators of XMLSpy that connects to all major databases.
DatabaseSpy® 2009 includes a database browser that displays a hierarchy of database tables and views and the data contained in them.
The DatabaseSpy® 2009 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® 2009 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® 2009 used by?
DatabaseSpy® 2009 is designed for database administrators, database developers, and other IT professionals who regularly work with information stored in databases.
DatabaseSpy® 2009 lets users quickly examine or update database content or structure without hand-writing SQL queries.
DatabaseSpy® 2009 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® 2009?
Database administrators, developers, and other users will appreciate that DatabaseSpy® 2009 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® 2009?
Users employ DatabaseSpy® 2009 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® 2009 connect to?
DatabaseSpy® 2009 connects to all major relational databases, including:
- Microsoft® SQL Server® 2000, 2005, 2008
- IBM DB2® 8, 9
- IBM DB2 for iSeries® v5.4
- Oracle® 9i, 10g, 11g
- Sybase® 12
- MySQL® 4, 5
- PostgreSQL 8
- Microsoft Access™ 2003, 2007
Back to Top - How does DatabaseSpy® 2009 fit with other Altova tools?
DatabaseSpy® 2009 closely complements Altova XMLSpy® 2009. Export options from DatabaseSpy® 2009 allow database professionals to export content in two XML formats that can be saved as XML files or sent directly to XMLSpy® 2009 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® 2009 also fits into workflows with DatabaseSpy® 2009. If a data architect, database administrator or developer needs to convert data from a dissimilar format before importing to a new database, Altova MapForce® 2009 is a visual mapping tool offering the power to map any combination of XML, database, text, or EDI files. MapForce® 2009 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® 2009.
Database managers interested in DatabaseSpy® 2009 will also want to explore the powerful database reporting features of Altova StyleVision® 2009. StyleVision® 2009 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.
To facilitate interoperability with other Altova tools, DatabaseSpy® 2009 supports databases as Global Resources. When you define a database as a Global Resource, all the connection settings including user name and password are saved in the Global Resources file, easing connection to the database when you move between applications.
The combination of XMLSpy® 2009, MapForce® 2009, and StyleVision® 2009 with the database browsing, SQL editing, database design, and export/import features of DatabaseSpy® 2009 provides database and IT professionals with a robust toolset for database management, reporting, and XML development needs.
Back to Top - How does DatabaseSpy® 2009 compare to other database administration tools?
DatabaseSpy® 2009 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® 2009 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® 2009 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® 2009 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.
|
|
|
|
