Offline synch using XML web-services

M

moko

This is a bit long-winded. Can somebody read thru these 2 use cases, and
tell me if it is feasible ? :-

Use Case : Replication before Offline Synch

Scenario 1 : Oracle Server , MSDE client

1. User clicks on 'Go Offline'. System creates a MSDE SQL database in
laptop (client), gets the schemas of the tables in Oracle, creates
corresponding tables in client's MSDE SQL (mapping Oracle datatypes to SQL
datatypes).
2. Offline replication program reads in the tables of the server into a
typed datasets, converts the typed datasets into XML, and stores the XML in
the client. (XML serialization).
3. After all the tables have been converted into serialized XML files,
another client side program reads these XML files, and updates them into the
SQL server. The question is , will ADO.NET's XML classes know how to convert
the datatypes of Oracle into the datatypes of SQL ?

----------------------------------------------------------------------------
------------------------------
Use Case : Offline Synch

Scenario 1 : Oracle server , MSDE client

1. User is offline. He makes transactions. These transactions are stored in
a log table in MSDE database in client laptop.
2. When user connects to his web application on the internet, clicks on
'Synch' button, the synch program converts the log data into XML, and sends
them as SOAP to a web-service. The web-service reads the data and converts
into a typed dataset , and then updates the dataset to the Oracle database
in the server. Again, the question is, will ADO.NET automatically convert
the datatypes of MSDE to Oracle ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,482
Members
44,901
Latest member
Noble71S45

Latest Threads

Top