DatabaseSpy: Difference between revisions
mNo edit summary |
latest release info |
||
| (5 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
{{Short description|SQL database profiling tool and GUI}} |
{{Short description|SQL database profiling tool and GUI}} |
||
{{Use mdy dates|date=January 2019}} |
{{Use mdy dates|date=January 2019}} |
||
{{Use American English|date=January 2019}}{{Infobox software |
{{Use American English|date=January 2019}} |
||
{{Infobox software |
|||
| name = Altova DatabaseSpy |
| name = Altova DatabaseSpy |
||
| screenshot = DatabaseSpy shot.gif |
| screenshot = DatabaseSpy shot.gif |
||
| caption = SQL editor with results view and graphical design editor in DatabaseSpy |
| caption = SQL editor with results view and graphical design editor in DatabaseSpy |
||
| developer = [[Altova]] |
| developer = [[Altova]] |
||
| latest_release_version = |
| latest_release_version = 2025 |
||
| latest_release_date = |
| latest_release_date = October 22, 2024 |
||
| operating_system = [[Microsoft Windows]] |
| operating_system = [[Microsoft Windows]] |
||
| genre = [[Relational database]] tool |
| genre = [[Relational database]] tool |
||
| Line 37: | Line 38: | ||
* [[SQLite]] |
* [[SQLite]] |
||
*[[Firebird (database server)|Firebird]] |
*[[Firebird (database server)|Firebird]] |
||
* [[Progress |
* [[Progress Software|Progress]] OpenEdge |
||
* Teradata |
* Teradata |
||
* And others |
* And others |
||
Latest revision as of 15:30, 12 November 2024
 SQL editor with results view and graphical design editor in DatabaseSpy | |
| Developer(s) | Altova |
|---|---|
| Stable release | 2025
/ October 22, 2024 |
| Operating system | Microsoft Windows |
| Type | Relational database tool |
| License | EULA |
| Website | https://www.altova.com/databasespy |
DatabaseSpy is a multi-database query, design, and database comparison tool from Altova, the creator of XMLSpy. DatabaseSpy connects to many major relational databases, facilitating SQL querying, database structure design, database content editing, and database comparison and conversion.
DatabaseSpy is a database client application for Windows 7, 8, and 10, Windows XP, and Windows Server 2003 and 2008 that allows database administrators, database developers, and other database-oriented IT professionals to interact with multiple relational databases that may have been created by different developers.
DatabaseSpy features include a quick connection wizard for multiple relational databases, SQL editor with auto-completion, graphical database design tool, database content and schema comparison, and data import and export in multiple formats. DatabaseSpy also includes special support for XML in databases and is available in 32-bit and 64-bit versions.[1]
Supported databases
[edit]DatabaseSpy can connect to multiple databases simultaneously, including databases of different types. DatabaseSpy automatically adjusts to variations in SQL dialects and data type definitions of supported relational databases. DatabaseSpy connects to the following major database types:[1]
- Microsoft SQL Server
- PostgreSQL
- Oracle
- MySQL
- IBM Db2
- IBM Db2 for i
- Informix
- Sybase ASE
- Microsoft Access
- MicroSoft Azure SQL
- MariaDB
- SQLite
- Firebird
- Progress OpenEdge
- Teradata
- And others
User comments
[edit]From its initial release in September 2006, users have recognized the benefits of using a single tool with a consistent user interface to multiple databases to perform routine tasks such as querying or modifying tables.[2][3][4]
The use of a common graphical interface to connect to multiple databases, possibly across different platforms, is cited as a valuable feature.[5]
Licensing
[edit]DatabaseSpy is a licensed software product that uses key protection to prevent unlicensed usage. DatabaseSpy is free to try with a no-cost 30-day trial license.[1]
See also
[edit]References
[edit]- ^ a b c "DatabaseSpy Multi-database Tool | Altova". www.altova.com. Retrieved January 27, 2019.
- ^ McCown, Sean (April 9, 2007). "Altova DatabaseSpy makes DBs user-friendly". InfoWorld. Retrieved January 27, 2019.
- ^ "MSDN Magazine Issues". msdn.microsoft.com. Microsoft. October 2007. Retrieved January 27, 2019.
- ^ Varhol, Peter; August 1, 2008. "Tooling Around in Your Database -- Redmondmag.com". Redmondmag. Retrieved January 27, 2019.
{{cite web}}: CS1 maint: numeric names: authors list (link) - ^ [1] Archived June 4, 2010, at the Wayback Machine SQL Server Magazine, April 26, 2010