XML in Databases

Working with XML in databases in Altova DatabaseSpy

DatabaseSpy Features for XML:

  • View XML table contents in SQL query results
  • Expand individual XML cells with the Data Inspector
  • Send XML directly to XMLSpy for editing
  • Assign XML as the datatype for database table columns
  • Assign XML Schemas for XML columns
  • Add, drop, or view all database XML Schemas from one convenient dialog
  • Support for database vendor-specific XML terms in SQL queries

Download Trial

Altova DatabaseSpy® 2017 includes special features to explore, manage, and work with XML in databases. XML is established as the preferred method for exchanging structured data between enterprises, but storing XML data in a relational database adds a layer of complexity. DatabaseSpy includes robust tools to help you analyze and manipulate databases that contain XML information.

When you expand a database table using the DatabaseSpy Online Browser, columns containing XML data are identified in the Browser Tree. You can also explore XML Schemas registered in the database in the browser hierarchy. To examine any XML Schema in detail, you can send it to XMLSpy, where it is automatically opened in XMLSpy Schema View for intuitive graphical display. You can also copy XML data from the results window to paste into another application.

The DatabaseSpy Tools menu offers more tools to manage XML Schemas registered in your database. The XML Schema Management dialog lets you add or drop an XML Schema from the database. You can also decompose an XML Schema for applications that require shredding – or decomposing – XML data into multiple columns in database tables.

Database XML Schema management in Altova DatabaseSpy

Designing Databases for XML

You can explore, modify, or design database tables with XML datatypes using the DatabaseSpy Design Editor.

XML columns are identified by an icon next to the column name, as well as in the Type field. You can open the column properties window to view detailed information.

As you would expect, the DatabaseSpy Design Editor lets you assign XML as the datatype when you create a new column in a database table.

Next, you can assign a default XML Schema for the XML column in the Properties window – all without writing any SQL statements.

Supported Databases:

  • Firebird 2.5
  • IBM DB2 for iSeries® v6.1, 7.1
  • IBM DB2® 8, 9.1, 9.5, 9.7, 10.1, 10.5
  • Informix® 11.70
  • Microsoft Access™ 2003, 2007, 2010, 2013
  • Microsoft® Azure SQL
  • Microsoft® SQL Server® 2005, 2008, 2012, 2014, 2016
  • MySQL® 5, 5.1, 5.5, 5.6
  • Oracle® 9i, 10g, 11g, 12c
  • PostgreSQL 8, 9.0.10, 9.1.6, 9.2.1, 9.4
  • Progress OpenEdge 11.6
  • SQLite 3.x
  • Sybase® ASE 15
XML properties for a database table column in Altova DatabaseSpy