I am writing an application to synchronize data between Oracle Database on a server and MS Access on a client machine. Should XML be used in this situation? If so, then how?
Created May 4, 2012
XML can be used in any data transfer and synchronization. I am synchronizing data between an SQL server and an Oracle database. The use of XML is more appropriate if there is significant difference in the database schema and the way the data is represented between the two sides. Using the XSLT and style sheets it is easy to process and manipulate the data. But, handling the data through the utility is also a complex process. While there are good JDBC drivers and libraries available for an Oracle database, I am not aware if there are good drivers for Access database. Moreover, the Access database does not support the standard SQL.
The possible steps would be:
If the database schema, or some of the table structures are same, it is better to use ODBC drivers to connect the client and the server to synchronize the data. In this case the possible steps would be: