|
Altova DatabaseSpy [SMP Renewal (1Yr) for Concurrent Users (10) WIN]
![Altova DatabaseSpy [SMP Renewal (1Yr) for Concurrent Users (10) WIN] boxshot.](/Portal0/Images/Features/boxshots/00245868.JPG) |
Reference Number:
PRS. 163023
Availability: Usually delivered within 2 working days
Media: E-mail
£613.47
(Ex. VAT)
|
Published By: Altova
» Call me about this product
» All variants of this product
» Other products by this publisher
» Similar Products
|
| Not what you're looking for? Use our free
sourcing request
service. |
DatabaseSpy 2008 connects to all major databases, easing SQL editing and database structure design, for a fraction of the cost of single-database solutions. DatabaseSpy provides a straightforward database connection wizard and organizes connections and related project files to make accessing your databases and their components effortless. You can even open connections to multiple databases at once. It clearly presents tables, views, stored procedures, and data in easily negotiable windows, and it also lets you directly edit database content. DatabaseSpy’s SQL Editor facilitates query writing with capabilities like code completion, syntax coloring, drag & drop editing, and more. You can easily write SQL scripts that retrieve data from multiple tables, and results can be displayed in individual, named windows for maximum clarity. DatabaseSpy’s powerful Database Design Editor enables graphical design and visualization of database structures or schemas. You can also use it to duplicate existing structures in differing database types. DatabaseSpy supports IBM DB2 (including IBM pureXML databases), Microsoft SQL Server, Microsoft Access, Oracle, MySQL, and Sybase, as well as other ADO or ODBC databases. XML support includes advanced capabilities to inspect XML data in database tables and to manage the XML Schemas used to validate that data. It exports data in five formats, including XML, XML Structure, CSV, HTML, and Excel, and it imports data from CSV files. |
- Creating and editing database views
- Support for stored procedures
- Database content editing
- Editing indexes and constraints in the Design Editor
- XML and text field preview
- Quick Connect Wizard - Lets users select any database table and retrieve all rows, or select just a sample to inspect the table's structure. DatabaseSpy also allows users to open and access multiple databases of different types at the same time
- Built-in SQL Editor - Makes generating SQL statements faster, easier, and more accurate thanks to helpers like auto-completion, syntax checking, color coding, and drag-and-drop editing
- Database Design Editor - Allows users to visualise or graphically design and build the structure of a database without the need to hand-write any SQL syntax. Users can drag and drop existing database tables onto the design pane to modify them or construct new tables from scratch
- SQL Preview Function - Lets users preview the generated SQL statements for database structure changes in the Design Editor before committing changes to the database
- Database Project Manager - Allows database connections, SQL files, design files, and favorites to be conveniently organised into project files and saved for quick reloading and reuse
- Export and Import Functions - Enables users to export data to XML, XML Structure, CSV, HTML and Microsoft Excel formats and import data from CSV files
- Embedded Database Access - Gives IT staff, developers and power-users access to the underlying databases in business software applications, allowing them to drill into data and perform maintenance tasks that might otherwise be impossible.
|