Altova DatabaseSpy is a versatile multi-database tool that simplifies SQL editing, database design, and other tasks. Developed by the creators of XMLSpy and MapForce, it connects to major databases and offers an affordable alternative to single-database solutions.
Connecting to databases and their components has never been more straightforward thanks to DatabaseSpy's easy-to-use database connection wizard. It also organizes connections and related project files, which considerably reduces hassle in accessing databases. Users can easily open connections to multiple databases of different types simultaneously. The software clearly presents tables, views, stored procedures, and data in convenient windows, allowing users to edit database content directly.
DatabaseSpy's SQL Editor enhances query writing by offering code completion, syntax coloring, drag & drop editing, and much more. Users can retrieve data from multiple tables and display results in individual, named windows for maximum clarity. Additionally, DatabaseSpy generates customized business intelligence charts promptly and in a style of your choice, which includes line, bar, pie, area, gauge, and candlestick.
The software's powerful Design Editor facilitates graphical design and visualization of database schemas and structures. Its XML support enhances XML data inspection in tables and manages XML Schemas to validate that data. It also exports data in five distinct formats and can import data from CSV and XML files.
DatabaseSpy has a broad range of database connectivity, including Microsoft SQL Server, PostgreSQL, Oracle, MySQL, IBM DB2, Informix, Sybase, Firebird, SQLite, MariaDB, Teradata, Microsoft Access, and more.
The software is available in both 32-bit and 64-bit versions. With all these incredible features, DatabaseSpy is undoubtedly your go-to software for saving time, simplifying your work, and ensuring accuracy in all your data.
Version 2023sp1: Bug fixes and other enhancements