473,785 Members | 2,423 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

sync question

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

Aug 17 '07 #1
2 1273
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" wrote:
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

Aug 17 '07 #2
m-flo wrote:
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
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.
Aug 17 '07 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
1690
by: dave | last post by:
I am not sure where to ask this question but i was hoping somone could put me in the right direction. I have a pda (ipaq) that i would like to synchronize with my outlook. The data is stored across a local pst file and ms exchange server. How can i setup my pda to sync with contacts that are stored in local pst file and email that is on the server? Is there a way i can choose which folders to sync with? thank you
1
2432
by: kartik | last post by:
I open an fstream in read-only mode, read till the end, then try to sync() before seeking to position 0 & reading again. But the sync fails. I discovered that clear()ing the stream before the sync causes the sync to work. Seeking to position 0 before the sync doesn't seem to help. If you look at sync() as simply invalidating the read buffer (isn't that right?), isn't it illogical for it to fail in this situation? Besides sync()...
2
1625
by: swoozie | last post by:
This may not be a MSSQL-specific question, but I wanted to ask it here first, in case there's a MSSQL and/or SourceSafe solution that will help. Our dev team is having some difficulty with keeping the nightly builds in sync with the stored proc mods. I'm wondering if there are some good case studies on how to avoid this "drift". Something like genning a new DB from checked-in SPs, etc. alongside each regular build,
1
2063
by: pStan | last post by:
Nubie Question...I'm sure this is simple, but here goes anyway. I have a small VB.Net application that uses a local Access Database. I want that same local data replicated to an Internet web site so that I can use an ASP.NET page to work with the data. My DB and Application is not really big enough to mess with SQL server... QUESTION: What is the best way to sync my data to the web. I've tried the built in replication in Access and...
3
2982
by: Ryan Liu | last post by:
Hi, What does ArrayList.Synchronized really do for an ArrayList? Is that equal to add lock(this) for all its public methods and properties? Not just for Add()/Insert()/Remvoe()/Count, but also for Item (this)? Normally,do I need sync at all? Isn't that true without sync the program can run faster?
7
9708
by: Ole | last post by:
Hi, I'm going to develop a socket communication between an instrument (running CE 5.0 with Compact Fraework V2) and a PC. As the instrument should only connect to one PC at a time I believe that the sync version of the socket should be the easiest - or what??? (please tell if I'm wrong). Are there anyone who is able to point to a Server and Client example code in C# VS2005 (I've only been able to find a C++ version) ???
3
2040
by: Angus | last post by:
Hello I have written my own C++ class to handle winsock. It uses an asynchronous programming model so basically you ask for something and then when network has info it gets sent to my class and I can deal with it. Basically, a user class derives from this networking class and overrides functions such as OnCompleteMessage. Sometimes, however, it is more convenient for the user class if it can call a function which then provides the...
3
2797
by: iKiLL | last post by:
Hi , I am trying to debug a problem with a Windows Mobile Application. I need the PDA to Sync(I have writen the sync process myself using a web service) using GPRS while Debugging from the VS IDE. My question is: How can this be done? Is there some settings i need on the PDA. Could some one point me in the direction of an artical on this.
8
6102
by: Michael.Guppenberger | last post by:
Hello everyone, I am currently trying to create a materialized query table which should be in-sync all the time. So my first attempt was to use the "REFRESH IMMEDIATE" option of the create table statement. However, due to the complexity of the underlying query, this is not allowed. As performance is not an issue and I absolutely want to have the MQT in-sync my next try was to create a trigger on the base tables of the MQT. This...
7
5218
by: john | last post by:
I am reading TC++PL3 and on page 644 it is mentioned: "Flushing an istream is done using sync(). This cannot always be done right. For some kinds of streams, we would have to reread characters from the real source - and that is not always possible or desirable. Consequently, sync() returns 0 if it succeeded. If it failed, it sets ios_base::badbit (21.3.3) and returns -1. Again, setting badbit might trigger an exception (21.3.6). A sync()...
0
9646
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9956
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8982
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7504
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6742
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5386
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5514
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4055
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3658
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.