Product Id: 32858866
Description: Altova DatabaseSpy 2017 Enterprise Edition - License - 20 named users - Win
Mfr Part #: T17E-N020-0P
DatabaseSpy Enterprise Edition is a tool to liberate data management. DatabaseSpy Enterprise Edition includes a variety of customizable charts directly from SQL query results.
- Connectivity to all major databases
- Quick connect wizard
- Database project manager
- Online database browser
- Database content editor
- SQL editor with SQL auto-completion
- SQL formatting and SQL refactoring
- Graphical database design tool
- Database table compare and merge tool
- Support for XML in databases
- Support for editing views and stored procedures
- Data export and import tool
- Support for Altova Global Resources
- Database projects organize database management tasks
When you launch Altova DatabaseSpy and connect to any of its supported database types, your work is automatically organized as a project. A DatabaseSpy project contains one or more database connections and can also include SQL files, database design files, database comparison files, and any tables and views you designate as favorites. A DatabaseSpy project file makes it easy to organize all the files related to your database work and to restore quick access to them later. The DatabaseSpy Project helper window displays the contents of the project in hierarchical format regardless of where individual files may be - on your local workstation or across the network.
- Database browser - display databases dynamically
Altova DatabaseSpy contains powerful database browser functionality to let you effortlessly explore the organization of tables, views, and stored procedures that make up your database or zero-in precisely on the information you need. The DatabaseSpy online browser lets you connect to multiple databases simultaneously, so you can easily compare their structures and content. You won't be distracted by the differences between interfaces from different relational database vendors since DatabaseSpy shows all your databases in the same clear, customizable, and easy to navigate display.
- Data editing
Information stored in relational databases is rarely static. Existing records are updated or removed, and new information is added to keep the database up to date and accurate, maintaining business value. DatabaseSpy offers convenient tools to edit database table content. You can begin by selecting any table in the Online Browser window and choosing Edit Data from the right-click context menu.
- DatabaseSpy graphical database design tool
The Altova DatabaseSpy graphical database Design Editor lets you view and edit the structures of all your databases through one graphical user interface. You can examine tables and relationships in an existing database to understand them more easily, you can edit existing database tables to better suit your needs, or you can add entire tables and specify all their column attributes and relationships to other tables from scratch. The DatabaseSpy database design tool graphical view allows you to concentrate on the underlying structure of your data and any required modifications rather than the SQL commands required to implement them. As you work, the DatabaseSpy graphical database designer automatically constructs the SQL statements you will need, but you choose when to execute the database structure change script once all your edits are complete.