Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP .Net Web Services > Offline synch using XML web-services

Thread Tools

Offline synch using XML web-services

Posts: n/a
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
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 ?

Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Palm synch with Outlook on TS Keyboard Cowboy MCSE 16 09-25-2004 02:15 PM
Re: Palm synch with Outlook on TS Brendon MCSE 1 09-23-2004 12:53 PM
Re: Palm synch with Outlook on TS Laura A. Robinson MCSE 0 09-23-2004 02:40 AM
Palm synch with Outlook on TS eddi rox MCSE 3 09-23-2004 12:57 AM
Palm synch with Outlook on TS =?Utf-8?B?TWF1cm8=?= MCSE 0 09-22-2004 08:55 PM