Product Id: 34435252
Description: Altova DatabaseSpy 2018 Professional Edition - License - 20 installed users - Win
Mfr Part #: T18P-I020-0P
Altova DatabaseSpy is the unique multi-database query, design, and database comparison tool. It connects to all major databases, easing SQL editing, database structure design, database content editing, and table comparison for a fraction of the cost of single-database solutions. DatabaseSpy boasts an elegant user interface that simplifies querying, visualizing, managing, designing, constructing, editing, and comparing the contents of relational databases. Features like table browsing, data editing, SQL auto-completion entry helper, visual table design, multiple import and export formats, and more, all save time and ensure accuracy. DatabaseSpy is the one database tool to finally liberate data management.
- 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.