The employee table from the EMPLOYEE TRAINING enterprise in
Understanding
Relational Database Query Languages
(
Suzanne W. Dietrich,
Prentice Hall, 2001) is
used to demonstrate the exchange of data between various database products
using XML.
Chapter 6 describes data exchange between ACCESS and Oracle. The following
reference provides a more detailed discussion that includes using XML for data
exchange between ACCESS, Oracle and SQL Server.
"Exploring XML for Data Exchange in the Context of an Undergraduate
Database Curriculum"
Suzanne W. Dietrich, Susan D. Urban, Hua Ma, Yang
Xiao and Shama Patel
© ACM, 2005. This is the author's version of the work. It is posted here by
permission of ACM for your personal use. Not for redistribution. The
definitive version will be published in SIGCSE'05, February 23-27, 2005, St.
Louis, Missouri, USA,
http://doi.acm.org/10.1145/nnnnnn.nnnnnn
[ACCESS]
employee.xml
employee.xsd
employee.xsl
[Oracle]
Procedure for inserting XML data
Procedure for exporting XML data
[SQL Server 2000]
Procedure for inserting XML data
Procedure for exporting XML data
Download data
exchange source code