ProductsDatabaseSpyData Editing

DatabaseSpy® 2010 allows users to edit the content of database tables in an interactive preview window.

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® 2010 offers convenient database editor tools for 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 Database Editor Supported Databases

Details of data editing fuctionality vary among implementations of relational database systems from different vendors and structural design of specific tables. DatabaseSpy® 2010 supports multiple database types and automatically adapts its Data Editor functionality to the following databases:

• Microsoft® SQL Server® 2000, 2005, 2008
• IBM DB2® 8, 9
• IBM DB2 for iSeries® v5.4
• Oracle® 9i, 10g, 11g
• Sybase® 12
• MySQL® 4, 5
• PostgreSQL 8
• Microsoft Access™ 2003, 2007

 Click here to download a fully functional, free 30-day trial of Altova® DatabaseSpy® 2010!

DatabaseSpy Database Editor Windows

If you’re examining a database table through a SQL select statement, you can click the Execute for Edit button in the SQL Editor window to redisplay a table with editing enabled.

Working with Data

In addition to editing data stored in the database, you can learn more about information presented in any DatabaseSpy® 2010 results table. You can:

• Select a range of cells and copy them to paste into another application
• Print the results table
• Automatically calculate and display information about selected results

To copy a range of cells for use in another application, simply highlight your desired data and choose one of the copy options from the results window right-click context menu.

Either the print button in the SQL Editor toolbar or the File / Print menu option allows you to print results. You can even see a preview of your output with options to navigate pages and zoom for more detail.

The right-click context menu available in the status bar at the bottom of the results window offers options to display calculated results about selected cells. You can select any range, or even a group of non-contiguous cells, within the results window and choose to display:

• The count of selected cells
• The total number of selected cells containing numerical data
• The average of all selected numerical values
• The sum of all selected numerical values
• The minimum selected numerical value
• The maximum selected numerical value

The information is automatically updated as you select new sets of cells within the results. These options can help you find the answers you want quickly, without writing, executing, and debugging additional complex SQL statements.

Edit Database Data

The Editing Mode icon appears in the status bar below the results table. You can then click any table cell and interactively update the contents. When you press Enter to complete the edit, the cell is highlighted in light red to indicate changed data. As you continue editing, all the changed cells remain highlighted.

Editing helpers are available in the Result window toolbar. You can search within the table, maximize the window view, append a new table row, delete a row, and more.

You can also sort the results by any column to display the table data in a more useful form.

The DatabaseSpy® 2010 Data Inspector Window is a helpful option to display long entries in individual cells. The Save button in the Data Inspector Window lets you save the data from any cell in an external file.

The Data Inspector Window displays XML content with color coding. You can even turn on word-wrap and resize the Data Inspector Window for a better view.

Additionally, XML data can be edited offline with XMLSpy® 2010, the industry-leading development environment for all XML-related technologies. The updated external file is easily replaced in the database.

Not all database tables and columns can be edited, due to restrictions on keys and indexes as well as variations in database vendors’ client modules. A DatabaseSpy® 2010 dialog window indicates issues that may prevent editing a table.

As you edit database content, the DatabaseSpy® 2010 database editor only interacts with the database in a limited manner. When all your changes are complete, this lets you review your edits in the highlighted cells, then easily commit them all at once using the Commit button in the Result window toolbar.

To the left of Commit, the Undo button lets you cancel all your edits, restoring the original data in the Result window.

See for yourself how easy it is to edit and update your own database with DatabaseSpy® 2010. Download a free trial today!