Offline synch using XML web-services

Discussion in 'ASP .Net Web Services' started by moko, Feb 16, 2004.

  1. moko

    moko Guest

    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 ?
     
    moko, Feb 16, 2004
    #1
    1. Advertising

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. =?Utf-8?B?Sm9u?=

    Timeout Value Not In Synch With Error Message

    =?Utf-8?B?Sm9u?=, Aug 30, 2005, in forum: ASP .Net
    Replies:
    0
    Views:
    358
    =?Utf-8?B?Sm9u?=
    Aug 30, 2005
  2. Synch two heights

    , Jul 12, 2006, in forum: HTML
    Replies:
    2
    Views:
    611
    Mark Eggers
    Jul 13, 2006
  3. Jan Limpens
    Replies:
    0
    Views:
    400
    Jan Limpens
    Sep 24, 2006
  4. Greg Hauptmann
    Replies:
    0
    Views:
    99
    Greg Hauptmann
    Sep 14, 2009
  5. adi2293
    Replies:
    0
    Views:
    451
    adi2293
    Oct 17, 2012
Loading...

Share This Page