Jump to content

DatabaseSpy: Difference between revisions

Add links
From Wikipedia, the free encyclopedia
Browse history interactively
← Previous edit
Content deleted Content added
VisualWikitext
Dmcgahey (talk | contribs)
60 edits
Revised See also link
XMLer (talk | contribs)
87 edits
latest release info
 
(39 intermediate revisions by 21 users not shown)
Line 1: Line 1:
{{Short description|SQL database profiling tool and GUI}}
{{Userspace draft|source=ArticleWizard|date=May 2010}}
{{Use mdy dates|date=January 2019}}
{{Use American English|date=January 2019}}
{{Infobox software
{{Infobox software
| name = Altova DatabaseSpy
| name = Altova DatabaseSpy
| screenshot = [[Image:DatabaseSpy shot.gif]]
| screenshot = DatabaseSpy shot.gif
| caption = with DatabaseSpy
| caption = SQL editor with results view and graphical design editor in DatabaseSpy
| developer = [[Altova]]
| developer = [[Altova]]
| latest_release_version = 2010r3
| latest_release_version = 2025
| latest_release_date = May 5, 2010
| latest_release_date = October 22, 2024
| operating_system = [[Microsoft Windows]]
| operating_system = [[Microsoft Windows]]
| genre = [[UML Tool]]
| genre = [[Relational database]] tool
| license = [[EULA]]
| license = [[EULA]]
| website = http://www.altova.com/databasespy.html
| website = https://www.altova.com/databasespy
}}
}}


'''DatabaseSpy''' is a [[Comparison_of_database_tools | multi-database query, design, and database comparison tool]] from [[Altova]], the creator of [[XMLSpy]]. DatabaseSpy connects to many major [[Relational_database | relational databases]], facilitating SQL querying, database structure design, database content editing, database schema and content comparison, and database conversion.
'''DatabaseSpy''' is a [[Comparison of database tools|multi-database query, design, and database comparison tool]] from [[Altova]], the creator of [[XMLSpy]]. DatabaseSpy connects to many major [[relational database]]s, facilitating [[SQL query]]ing, database structure design, database content editing, and database comparison and conversion.


DatabaseSpy is a database client application for Windows 7, Windows Vista, 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 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.<ref name="ad">{{Cite web|url=https://www.altova.com/databasespy|title=DatabaseSpy Multi-database Tool {{!}} Altova|website=www.altova.com|access-date=2019-01-27}}</ref>
== Major features ==

DatabaseSpy includes these components:<ref>[http://www.altova.com/databasespy.html] Altova website </ref>

Quick connection wizard

Database project manager

Online database browser

Database content editor

SQL editor with SQL auto-completion

Graphical database design tool

Database table compare and merge tool

Database schema compare and merge tool with support for database structure conversion

Editor for views and stored procedures

Data export and import tool

DatabaseSpy also includes special support for XML in databases and is available in 32-bit and 64-bit versions.


== Supported databases ==
== Supported databases ==


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:<ref>[http://www.altova.com/databasespy.html] Altova website </ref>
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:<ref name="ad"/>


Microsoft® SQL Server® 2000, 2005, 2008
* [[Microsoft SQL Server]]
⚫
* [[PostgreSQL]]

* [[Oracle (database)|Oracle]]
IBM DB2® 8, 9 (LUW)
* [[MySQL]]

* [[IBM Db2]]
IBM DB2 for iSeries® v5.4, 6.1
* IBM Db2 for i

* Informix
Oracle® 9i, 10g, 11g
⚫
* Sybase ASE

* [[Microsoft Access]]
⚫
Sybase® 12
* MicroSoft Azure SQL

* MariaDB
MySQL® 4, 5
* [[SQLite]]

*[[Firebird (database server)|Firebird]]
⚫
PostgreSQL 8
* [[Progress Software|Progress]] OpenEdge

* Teradata
Microsoft Access™ 2003, 2007
* And others


== User comments ==
== User comments ==


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.<ref>[http://www.infoworld.com/d/data-management/altova-databasespy-makes-dbs-user-friendly-390] Infoworld, April 9, 2007</ref><ref>[http://msdn.microsoft.com/en-us/magazine/cc163343.aspx] MSDN Magazine, October 2007</ref><ref>[http://redmondmag.com/articles/2008/08/01/tooling-around-in-your-database.aspx] Redmond Magazine: Tooling Around Your Database, August 1, 2008</ref>
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.<ref name="infoworld review">{{Cite web|url=https://www.infoworld.com/article/2662662/database/altova-databasespy-makes-dbs-user-friendly.html|title=Altova DatabaseSpy makes DBs user-friendly|last=McCown|first=Sean|date=April 9, 2007|website=InfoWorld|language=en-US|access-date=2019-01-27}}</ref><ref name="MSDN">{{Cite web|url=https://msdn.microsoft.com/magazine/msdn-magazine-issues|title=MSDN Magazine Issues|date=October 2007|website=msdn.microsoft.com|publisher=Microsoft|access-date=2019-01-27}}</ref><ref>{{Cite web|url=https://redmondmag.com/articles/2008/08/01/tooling-around-in-your-database.aspx|title=Tooling Around in Your Database -- Redmondmag.com|last=Varhol|first=Peter|last2=August 1, 2008|website=Redmondmag|language=en|access-date=2019-01-27}}</ref>


The use of a common graphical interface to connect to multiple databases, even on different platforms, is cited as a valuable feature. "For developers and power users, this offers a great way to tame some of the complexity that they might need to deal with in a heterogeneous environment," wrote one user.<ref>[http://www.sqlmag.com/article/administration-tools2/Altova-DatabaseSpy-2010.aspx] SQL Server Magazine, April 26, 2010</ref>
The use of a common graphical interface to connect to multiple databases, possibly across different platforms, is cited as a valuable feature.<ref>[http://www.sqlmag.com/article/administration-tools2/Altova-DatabaseSpy-2010.aspx] {{Webarchive|url=https://web.archive.org/web/20100604123036/http://www.sqlmag.com/article/administration-tools2/Altova-DatabaseSpy-2010.aspx |date=June 4, 2010 }} [[SQL Server Magazine]], April 26, 2010</ref>

The DatabaseSpy comparison functionality has also been highlighted. “ … its ability to let you compare and merge the contents of database tables via its graphical representation … is especially handy when you are moving from one system to another.”<ref>[http://blogcritics.org/scitech/article/software-review-missionkit-2009-database-comparison/#ixzz0p9YXWgkt] Software Review: Database Comparison and Merging From Altova, May 19, 2009</ref>

DatabaseSpy won a 2009 [[SQL_Server_(magazine) | SQL Server Magazine]] Editors' Best and Community Choice Award. "If you’re managing more than one flavor of database, you’ll want to check out this multipurpose toolset,” said one editor.<ref>[http://www.sqlmag.com/article/monitoring-and-analysis/2009-sql-server-magazine-editors-best-and-community-choice-awards/2.aspx] 2009 SQL Server Magazine Editors' Best and Community Choice Awards</ref>


== Licensing ==
== Licensing ==


DatabaseSpy is a licensed software product that uses key protection to prevent unlicensed usage. Altova offers customers an optional support and maintenance package, which allows them to upgrade to major new versions and maintenance releases. Service pack releases containing bug fixes are available to all users of the current software version. Altova updates its product line to add features and to ensure conformance with continually developing relational databases. All Altova products are free to try with a no-cost 30 day trial license.<ref>[http://www.altova.com] Altova website</ref>
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.<ref name="ad" />


==See also ==
==See also ==
*[[Comparison_of_database_tools | Comparison of database tools]]
*[[Comparison of database tools]]


== References ==
== References ==
<!--- See http://en.wikipedia.org/wiki/Wikipedia:Footnotes on how to create references using <ref></ref> tags which will then appear here automatically -->
<!--- See http://en.wikipedia.org/wiki/Wikipedia:Footnotes on how to create references using <ref></ref> tags which will then appear here automatically -->
{{Reflist}}
{{Reflist|2}}


== External links ==
== External links ==
* [http://www.altova.com Altova website]
* [https://www.altova.com Altova website]
* [http://blog.altova.com/ Altova blog]


{{DEFAULTSORT:Databasespy}}
<!--- Categories --->
[[Category:Database administration tools]]
[[Category:Database administration tools]]
[[Category:Database administration tools]]
[[Category:Database management systems]]
[[Category:PL/SQL editors]]
[[Category:Sybase]]
[[category:PL/SQL editors]]

Latest revision as of 15:30, 12 November 2024

Altova DatabaseSpy
Developer(s)Altova
Stable release
2025 / October 22, 2024
Operating systemMicrosoft Windows
TypeRelational database tool
LicenseEULA
Websitehttps://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]

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]
  1. ^ a b c "DatabaseSpy Multi-database Tool | Altova". www.altova.com. Retrieved January 27, 2019.
  2. ^ McCown, Sean (April 9, 2007). "Altova DatabaseSpy makes DBs user-friendly". InfoWorld. Retrieved January 27, 2019.
  3. ^ "MSDN Magazine Issues". msdn.microsoft.com. Microsoft. October 2007. Retrieved January 27, 2019.
  4. ^ 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)
  5. ^ [1] Archived June 4, 2010, at the Wayback Machine SQL Server Magazine, April 26, 2010
[edit]
Retrieved from "https://en.wikipedia.org/enwiki/w/index.php?title=DatabaseSpy&oldid=1256981867"