sync question

  • Thread starter Thread starter m-flo
  • Start date Start date
M

m-flo

Hi,

I currently trying to develop a project that consists of 2 part:
1- central web application that is connected to MSSQL 2005 DB
2- an application that use a local MSSQL 2005 DB

i want when u add new/ or change a specific entry in the application ,
the web application get updated. the problem is the application may
not be always connected to the Internet, so i want the application to
queue the changes until the Internet connection is established.

any suggestion?


thanks for your time
 
Look into using the database on the web as a master and the local windows
application database as a slave. When the pc is connected to the internet do
a synchronization. The database replication service is built into SQL server.
 
m-flo said:
Hi,

I currently trying to develop a project that consists of 2 part:
1- central web application that is connected to MSSQL 2005 DB
2- an application that use a local MSSQL 2005 DB

i want when u add new/ or change a specific entry in the application ,
the web application get updated. the problem is the application may
not be always connected to the Internet, so i want the application to
queue the changes until the Internet connection is established.

any suggestion?


thanks for your time
Click to expand...
Yes,

Look intot the SQL Server Replication.
I had the same scenario on a project a while back, however it wasnt the
perfect solution for myself, as it required a significant redesign of
the databases structure. But in the end it was most definatly worth it.
 
Back
Top