S
sandra
Hi there
I want to delvelop a larger project and it should include some function as
follow:
1. Using SQL for the Center database
2. 1000 stores can retrive information from web server (web service)
3. When the internet connection broken, the store can still working with
their local data and save it on local manchine, until the internet
connection works, it can auto update the SQL database.
What I design is:
1. stores can retrive all information from web server (Web service) and save
it on local machine using XML
2. when stores run destop application, the application check the difference
between local XML data (load into DataSet) and SQL server data (load into
DataSet) and update the SQL server and local data with the difference.
3.When internet broken, the application will use local data and save it on
local machine.
4. When internet connection works, the application will check the difference
between local XML data and SQL server data and update both.
What I want to know is that my design is correct ?
if it is not correct, how can I design it?
The important things is when internet connection broken, the stores also can
works without SQL server Data.
Thanks in advance
Tony
I want to delvelop a larger project and it should include some function as
follow:
1. Using SQL for the Center database
2. 1000 stores can retrive information from web server (web service)
3. When the internet connection broken, the store can still working with
their local data and save it on local manchine, until the internet
connection works, it can auto update the SQL database.
What I design is:
1. stores can retrive all information from web server (Web service) and save
it on local machine using XML
2. when stores run destop application, the application check the difference
between local XML data (load into DataSet) and SQL server data (load into
DataSet) and update the SQL server and local data with the difference.
3.When internet broken, the application will use local data and save it on
local machine.
4. When internet connection works, the application will check the difference
between local XML data and SQL server data and update both.
What I want to know is that my design is correct ?
if it is not correct, how can I design it?
The important things is when internet connection broken, the stores also can
works without SQL server Data.
Thanks in advance
Tony