ALTOVA Databasespy Enterprise Edition - Smp Lic - Installed 1 User - 1 Year - Windows

Name: Databasespy Enterprise Edition - Smp Lic - Installed 1 User - 1 Year - Windows
Brand: ALTOVA
SKU: A837A125
Price: 42.94 EUR
Availability: InStock

Redcorp# A837A125 Article# TE+M1-I001

Search More Service & Support

Key Specifications

More Details

€ 42.94 ^{Excl. VAT}

FREE Shipping on orders over
€ 100 Ex VAT.

24 - 72h

Quantity

Add to basket

ALTOVA Databasespy Enterprise Edition - Smp Lic - Installed 1 User - 1 Year - Windows

Add to basket

For personal help or faster delivery

+32 2 558 30 00

chat

DatabaseSpy Enterprise Edition is the one tool to finally liberate data management. In addition to all the features of the Professional Edition, DatabaseSpy Enterprise Edition includes generation of a variety of customizable charts directly from SQL query results.

Specs

Features

SQL Editor
- Generate a variety SQL statements in the Online Browser based on existing tables and columns, including SELECT, CREATE, INSERT, DROP, and more
- Open and save SQL statements in files for reuse
- Color-coded auto-formatting with collapsible regions and named result windows
- Customized appearance of SQL code for each supported database
- Refactoring menu to add or remove semicolons and quotation marks, or automatically remove comments from SQL statements
- Dynamic autocompletion window for SQL editing with options to display and insert names of tables, views, columns, functions, datatypes, procedures, and keywords
- Edit views and stored procedures Display query results in multiple named or stacked results tables
Charts of SQL Query Results
- Line charts
- 2D and 3D bar charts
- Stacked bar charts
- 2D and 3D pie charts
- Area charts
- Stacked area charts
- Round gauge charts
- Bar gauge charts
- Candlestick charts
- Chart overlays
- Chart background images and color gradients
- Customize chart titles, axis ranges, colors, fonts, and sizes
- Save charts as .png, .bmp, .gif, and .jpg image files
Graphical Database Design
- Display tables and relationships in graphical view
- Add or modify database tables
- Add or modify columns with datatypes, lengths, nullable characteristics
- Add or modify indexes, keys, and check constraints
- Build database change script to execute immediately, send SQL editor, or save in a file
- Save graphical database diagrams as .png or .emf image files
Database Comparison and Merging
- Compare contents of tables of the same or different database types
- Automatically map tables and columns with the same names
- Permit manual mapping of tables and columns
- Show comparison results with options to show/hide equal or different rows
- Merge differences in database content directly or via change script
- Compare database schemas of the same or different database types with multiple mapping options
- Create merge scripts to components to update structures and components between schemas
- Save database data and schema comparison settings in files for reuse
Data Import and Export
- Import data from XML or CSV formats
- Import data directly or generate a SQL import script
- Export data in XML, CSV, HTML, or Excel formats
Supported Databases
- Microsoft® SQL Server® 2000, 2005, 2008, 2012
- PostgreSQL 8, 9.0.10, 9.1.6, 9.2.1
- Oracle® 9i, 10g, 11g
- MySQL® 5, 5.5
- IBM DB2® 8, 9, 9.5, 9.7, 10.1
- IBM DB2 for iSeries® v6.1, 7.1
- Informix® 11.70
- Sybase® 12, Sybase ASE 15, 15.7
- Microsoft AccessT 2003, 2007, 2010, 2013